SharePoint List - Hiding row and then automatically reappear after X amount of time

New Contributor

Hello community :stareyes:

 

I have a SharePoint List where a column with a choice type is defaulted to 'No' but when it is manually changed to 'Yes', it'll be hidden from the list using the filter settings below:

2021_11_24_17_02_45_Edit_View.png

My questions are:

How can I automatically reinstate rows back to the list after X amount of days?

How can I reset the column choice option to 'No' (Which I guess would need to happen prior to the previous question to get it to show

 

Hope that makes sense!

 

James

1 Reply
Hi there, you would need to create a Power Automate flow to achieve this.

Couple of approaches:
1) Create a Power Automate that triggers on creation of a new SharePoint List Item, then enter a Delay action for the number of days, followed by an update Item action that sets the value back. Note, if the number of days is approaching 30, then the Power Automate will timeout...so move to option 2:

2) Create a Power Automate flow with a daily recurrence trigger (i.e. a Scheduled flow), query the list using the Get Items actions, filtering items by comparing the utcnow expression to the CreatedDate, then iterate through items using a For Each action and update the items accordingly