Unanswered

Is there an Excel trigger when a column is changed?

(1) Share

Report

Posted on by juphi17 Microsoft Employee

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.

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

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

Was this reply helpful? Yes No
v-bacao-msft on at

Like (0)

Report

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,

Was this reply helpful? Yes No
juphi17 Microsoft Employee on at

Like (1)

Report

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.

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (2)

Report

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.

Was this reply helpful? Yes No
takolota1 4,974 Moderator on at

Like (1)

Report

Workaround for "When an Excel row is created", "When an Excel row is modified", and/or "When an Excel row is deleted" triggers

This template triggers some time after users edit an Excel workbook in SharePoint & then for the target Excel table, returns a different set for records that were created, records that were modified, & records that were deleted. This way we can set up additional actions & processes for each edit users made in our target Excel table.
https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/When-an-Excel-row-is-created-modified-or-deleted-workaround/td-p/2264670

You can also set it to only trigger when certain columns are changed.

Was this reply helpful? Yes No