cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Microsoft
Microsoft

Is there an Excel trigger when a column is changed?

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.

4 REPLIES 4
Highlighted
Super User III
Super User III

Re: Is there an Excel trigger when a column is changed?

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

 



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

Power Automate Video Tutorials
Highlighted
Community Support
Community Support

Re: Is there an Excel trigger when a column is changed?

 

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,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Microsoft
Microsoft

Re: Is there an Excel trigger when a column is changed?

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.

Highlighted
Super User III
Super User III

Re: Is there an Excel trigger when a column is changed?

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. 

 



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

Power Automate Video Tutorials

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Upcoming Events

Experience what’s next for Power Automate

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors
Users online (7,623)