I have a Excel spreadsheet stored on a SharePoint document library, and want to send an automated email when a column is changed from "NO" to "YES", with the a couple of values from that row.
Is this possible with Flow?
I have other Flows that work perfectly with putting data INTO the spreadsheet from a SharePoint List, but can't seem to figure out how to trigger upon a cell change in a particular column and using the details of that row.
Unfortunately there are no triggers for Excel (Business and OneDrive) now. If you think it's a good idea then you can post this idea in forum.
Hi @juphi17 ,
Unfortunately, MS Flow does not support similar triggers to monitor whether Excel tables have changed. If you want similar features to be supported by MS Flow, please consider voting for similar idea:
Also, you could post your idea in the Flow Ideas forum, so it might be considered for future releases.
That's unfortunate. I have voted for that.
Question - Is this a possible workaround? SharePoint Lists are supported in Flow, and some of the columns in our Excel spreadsheet originate from a SharePoint List. We already have a Flow already that fills them any new items into our spresheet. Is there a way to sync the data from the spreadsheet back to the SharePoint List? That way I can trigger a Flow from there?
SharePoint List has:
Title, Requester Name, Price, Invoiced
Flow automatically automatically adds any new items into our spreadsheet with the following columns:
Title, Requester Name, Price, <a bunch of other columns that are blank but we fill them in manually>, Invoiced
Is there a way to sync any changes to those 4 columns in the spreadsheet back to the SharePoint List?
That way I can make a Flow that says:
- When List Item is updated
>>>> If Invoiced=Yes
>>>>>>>> Send email, etc.
Yes this might be possible. So keep a unique identifer column in Excel Sheet and SharePoint. Add a schduled trigger flow which will read the excel rows. Add a for each loop to iterate all the rows from Excel Sheet. Then add Get Items (SharePoint) flow step. Here use the filter query Id to match the lists in SharePoint. If not found then add the record in SharePoint. If found then compare and update the columns. Then decide you need to send email or not.
Check out the on demand sessions that are available now!
ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.
See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.