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
Solved! Go to 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
no ideas?
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
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Read the latest about new experiences and capabilities in the Power Automate product blog.
At the monthly call, connect with other leaders and find out how community makes your experience even better.
User | Count |
---|---|
26 | |
25 | |
23 | |
23 | |
17 |
User | Count |
---|---|
59 | |
41 | |
36 | |
31 | |
30 |