You’re offline. This is a read only version of the page.
Hi there,
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.
Hi @juphi17
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.
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?
For example:
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.
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:
https://powerusers.microsoft.com/t5/Flow-Ideas/Triggers-for-Excel-Sheets/idi-p/78301
Also, you could post your idea in the Flow Ideas forum, so it might be considered for future releases.
https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas
Best Regards,
Hi @juphi17
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.
https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas
#1
WarrenBelz
146,660
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
66,004
Most Valuable Professional
Share
Report
All responses (
Answers (
