Delete sharepoint agenda item after date expired

(0) Share

Report

Posted on by Community Power Pla...

Hey all,

Can someone help me build a flow that deletes a sharepoint agenda item after the date expired?

Thanks in advance,

Zenna

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @Anonymous

Is this a list then use Get List Items and set the filter query against the column name? What's your date expiry compared against?

Once the list records are there then iterate the results and use the id to delete the item using Delete item action step.

Thanks

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi @abm

It is a SharePoint calendar, but it is a list yes. Just want to remove the date that has been expired

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (1)

Report

Hi @Anonymous

Thanks for your quick reply. See below example to filter DueDate > todays date.

Next add a foreach loop then use Delete Item action step, map the id from the above filtered collection.

Thanks

Was this reply helpful? Yes No
Verified answer

fchopo 8,003 Moderator on at

Like (1)

Report

Hello @Anonymous
I solved a similar issue with expenses in the following way:
Using a Filter Query you can specify which items you want to get (those that ExpenseDate is less than today (utcNow)). After that, we delete each item.
Hope it helps!
Ferran

Was this reply helpful? Yes No
sudharsan1985 1,325 on at

Like (1)

Report

Hi @Anonymous
Based on your scenario, the flow has to be scheduled daily i assume. Follow the below steps
1. Create a flow of 'Scheduled-from blank'. Give it a name and choose the schedule
2. Add 'Get Items' action and select the appropriate properties. In the advanced option, for 'Filter Query' use the value EndDate lt 'utcNow()'. I have used the default 'EndDate' field for checking the expiry.
3. Add an action named 'Apply to each'. Give the value as body('Get_Items')?['value']
4. Inside the 'Apply to each' action, add 'Delete Item' action and select the appropriate properties. For the 'Id' property give the value as items('Apply_to_each')?['ID']
Thats it, all the agenda or events whose enddate is already expired will be deleted.

Hope it helps, please like it or mark it as a solution if it resolves ur clarification or issue
-Sudharsan K...

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

Hi @sudharsan1985 @fchopo @abm

Thank you for those quick reply's, really helpfull. Thank you!

Was this reply helpful? Yes No