How to get highest date from a lookup column array

(0) Share

Report

Posted on by Tiberian

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!

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Community Power Pla... on at

Like (0)

Report

Re: How to get highest date from a lookup column array

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

Was this reply helpful? Yes No
KarlH 31 on at

Like (0)

Report

Re: How to get highest date from a lookup column array

Good afternoon @Anonymous - would you be so kind to share further insight into your solution? I too have an array of dates from a LookUp column, and just need to return the largest and the smallest date from this field. I don't understand why Flow has made this simple task excessively difficult. 😞

Was this reply helpful? Yes No