I’m having such a hard time figuring out how Microsoft Office Power Automate works with Lists.
I havs two lists: Contacts and Call Log.
I’d like to update one column “Lastest Call Date” in Contacts list with the value from Call Log list. Basically, Call Log list has various logs of recent calls with clients (that are in Contacts list) and thei respective dates. I’d like to update the Latest Call Date column for each client with the lastest call date from last register in Call Log.
I have tried to create a power automate flow, initiating with Manually Trigger and get items from Call Log. But I don’t know how tl get only the last register date for each client. And then I’d have to run another flow to find the same contact in Contacts list and update the field there with the latest date.
Can anyone help me with that?
Thanks