
Announcements
VERY new to power automate. I am trying to be notified by teams and or email, when "FLAGGED" pops up in my excel worksheet in sharepoint or onedrive.
My overall goal is for auditing purposes, my team has 72 hours to obtain signed documents. I have the rows formatted to automictically fill flagged in the last column when that date passes. I'd like to receive a notification when that happens. I've seen posts that say this is narrowing it down to a modified colum or row is not possible, and others that say it is but everything I've tried fails.
Is this not possible or just very tricky? I've spent hours, any help would be much appreciated!
Thank you!!
Hi @shannelpeters ,
A trick of doing so is:
1. Add an additional column in Excel table, where to save the status of notified or not.
2. Create a scheduled flow that every one or more minutes list all rows of this table and get flagged and not notified rows.
3. In an Apply to each loop, send Email or Teams message for each line item of the table.
Best regards,