web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / How to get highest dat...
Power Automate
Unanswered

How to get highest date from a lookup column array

(0) ShareShare
ReportReport
Posted on by Tiberian 2

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)
  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    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

  • KarlH Profile Picture
    KarlH 31 on at

    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. 😞

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the February Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 67

#2
David_MA Profile Picture

David_MA 64 Super User 2026 Season 1

#3
Expiscornovus Profile Picture

Expiscornovus 39 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!
Survey: Power Automate mobile app
How to Ask for Help with Your Power Automate Workflow
Flows are not visible for users who sign in with their personal accounts
Start and wait for an approval action
Restore a deleted flow
List of actions cheat sheet for Power Automate Desktop
Question for everyone : How are you using Create Text GPT in AI Builder?
Welcome to the Power Automate forum!

Product updates

Microsoft Power Platform Community release plans