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
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Users online (98,783)