Hi,
I need help, please.
I need to run a daily workflow to get files that met the following conditions: Status is pending AND was created 2 days ago or more.
I was able to complete the status part but I couldn't figure out the date part. I tried to use the ticks function and I failed.
Thanks in advance.
Solved! Go to Solution.
Hello @efebo ,
You can use the following filter query -
Status eq 'Pending' AND Created le '@{formatDateTime(addDays(utcNow(), -2), 'yyyy-MM-dd')}'
Try this out !!!
If this answered your question, please mark this question as answered and if you liked my response, please consider giving it a thumbs up .
Thank You !!!
@efebo - You can add a calculated field in SharePoint list with formula as Today()-Created. Then Use that field in the flow.
Like and Mark this as answer if this resolves your issue.
Hello @efebo ,
You can use the following filter query -
Status eq 'Pending' AND Created le '@{formatDateTime(addDays(utcNow(), -2), 'yyyy-MM-dd')}'
Try this out !!!
If this answered your question, please mark this question as answered and if you liked my response, please consider giving it a thumbs up .
Thank You !!!
Thanks, both for answering.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
26 | |
26 | |
23 | |
13 | |
10 |
User | Count |
---|---|
62 | |
50 | |
30 | |
29 | |
25 |