cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Tiberian
Frequent Visitor

How to get highest date from a lookup column array

Hello,

Here is my issue: I try to get the highest date from a lookup column array. Let me explain....

 

I have a Sharepoint list lookup column where multiple values is enable:

multiple array 1.png

The "Doc multi:Date" column show automatically the dates of the documents I added. 

What I want to do is to be able to copy the highest date in an other column...

 

To do this I went to Power Automate and created the following flow:

multiple array 2.png

At this step I am a bit lost. I know that my field "Doc multi:Date" is an array with dates... but what can I do to select the highest date within this array?

 

I have been searching and trying many things to find a solution but with no success.

Thank you for your help!

1 REPLY 1
soysalf
Resolver I
Resolver I

Hi @Tiberian ,

If you create a variable for the highest date and assign the first array item as the variable value, then you should compare the variable value with each array item and if the array item date is higher you should set the variable again. I hope it makes sense. Let me know if you need any screenshots

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,985)