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.
User | Count |
---|---|
88 | |
39 | |
23 | |
20 | |
16 |
User | Count |
---|---|
129 | |
50 | |
48 | |
35 | |
26 |