Sharepoint - Flow to reset certain items to default?

Copper Contributor



Our team uses a list to track when we receive certain files. We have a choice column titled Status with 'No Status', 'Received', and 'Complete' options and a Due Date column where we enter the date when that item is due, once received.  Instead of manually going into the list and resetting the values, is there a formula/flow I can use to reset items marked 'Complete' to 'No Status' as well as resetting the due date for that row to an empty cell? I don't want to clear/reset the entire columns since certain rows have different due dates and statuses.  If one row is marked 'Complete' and the 'Due Date' is today (relative), I would like for those rows to reset back to 'No Status' and due date cell as empty.


I appreciate your help in advance!

0 Replies