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.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
At the monthly call, connect with other leaders and find out how community makes your experience even better.
User | Count |
---|---|
22 | |
21 | |
9 | |
7 | |
7 |
User | Count |
---|---|
33 | |
31 | |
24 | |
22 | |
11 |