Sorting a list of dates

[Mattw112IG]

In dynamics I have a bunch of date fields on a form.

I want to run a flow and return what is the next date in the future.

So if today is 9/15/2021 and the dates form various fields are:

9/14/2021

9/24/2021

9/30/2021

9/18/2021

9/16/2021

I would want 9/16/2021 returned.

I'm assuming I can read these from Dynamics and build an array?  Although many times not all of the field will contain a date, some may be blank... so would need to grab the fields that arent blank, add to an array, run some sort of sort, and return the result??

Does anyone have an example of this i can use or some guidance on the approach?

Thanks,

Terry 

[Mattw112IG]

no ideas?

[v-bofeng-msft · Accepted solution]

Hi @Mattw112IG :

I've made a test for your reference:

1\My SP list:

2\My Flow(On my side today is 9/20/2021)

The Result

Best Regards,

Bof