web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Lookup Nearest Date in...

Power Automate

Unanswered

Lookup Nearest Date in one list to update second list

(0) Share

Report

Report

Posted on by frome2000

Hi

I have a list of "clients" and a list of "tasks". When a new task is added I need to check through the tasks list for that client id and if the new task due date added is closer than the existing "soonest date" field in the client list, update "soonest date" to the newest date.

I understand how to update between the lists but I am not sure how to get it to compare the dates.

Thanks

Categories:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Michael E. Gernaey 53,968 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hello,

Is this a planner task list, or a SharePoint task list?

If you have the list when you query your list

If(newdate < First(SortByColumns(Filter(mylist, clientid = 12345), datefield, descending)), it is less so swap or whatever , it is not so add it ); //give that a shot. since I dont know the lists I'm guessing here a little at your needed format
Cheers
--------------------------------------------------------------------------------
If I had answered your question, please mark your post as Solved
If you like my post please give it a thumbs up
Thanks
Michael Gernaey MCT | MCSE | Expert | Ex-Microsoft
https://gernaeysoftware.com

Was this reply helpful? Yes No

Join the conversation