I have a sharepoint list.
I have a date column.
I want Flow to delete all posts in the sharepoint list if the date is older than 60 days from todays date.
How should i filter the flow "get sharepoint objects" so that i then can use the delete command?
My column is called: DueDateXX
I wrote this: DueDateXX gt addDays(utcnow('yyyy-MM-ddTHH:mm:ssZ'),-60)
But i did not get it to work.
Anyone able to help?
Solved! Go to Solution.
You need to add single quotes at each end of the expression - see my example above. Please add the single quotes and try again.
DueDateXX le 'addDays(utcnow(),-60,'yyyy-MM-dd')'
The following example should get you there. Substitute the internal name of your column (DueDateXX) for Created in my expression. Also note the single quotes around the expression.
I still get an error on this
DueDateXX le addDays(utcnow(),-60,'yyyy-MM-dd')
My flow looks other whise exactly like yours on the picture.
You need to add single quotes at each end of the expression - see my example above. Please add the single quotes and try again.
DueDateXX le 'addDays(utcnow(),-60,'yyyy-MM-dd')'
Great, that was it. Works perfectly now.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
47 | |
17 | |
15 | |
12 | |
11 |
User | Count |
---|---|
57 | |
39 | |
23 | |
19 | |
18 |