Sharepoint - Flow to reset certain items to default?
Hello, 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!
Microsoft List : formula to calculate the number of X in a column, per user
Hi Community ☺ Thank you in advance for your help ! I'm a beginer with Microsoft List so I'm not even sure that my request/question is doable... So I have a List and in the column A, I have the user's name, in column B their ticket # and in column C I have a list of choices (yes, no, pending, etc.). Is it possible to get an email when the same user gets 10 yes in column C ? With Power Automate, I know how to get an email depending on a value in MS List. However, I don't know how to ensure that we receive an email only when the user X (in column A) reaches 10 value « yes »in column C. Thank you for your responses ☺ And sorry if my english is rusty, I'm francophone 😉 Kindly, Audrey