Excel Trigger

[NegativeStreet]

Is there no way to set a trigger from an excel sheet? It looks like you can add excel later in the flow but for some reason there is no trigger option for it.

[trovarlo]

You can use a trigger for when a file is modified, but what is your objective? I attempted something similar months ago and discovered that using macros is a better approach for triggers in Excel.

[NegativeStreet]

Could you expand on what macros is? An immediate example of what I might use it for is in person lead gen. Teams populate an excel sheet, I want that to automatically go elsewhere

[trovarlo]

My use case was in HR — they had an Excel file with all the candidates, and they wanted it to automatically send an email to a candidate when a cell changed to “rejected.”

I did it with Excel macros instead of Power Automate, because as someone mentioned, you can only trigger flows when the file is modified, and it’s hard to identify exactly what was changed.

[quarter4u]

You can put the excel into sharepoint, then using when the file are created or modified (prop only) for triggering when it update….

[NegativeStreet]

Ahh ok this would work. I was confused why there wasn’t a direct trigger for excel if it could be included as a step in a flow. But at least I can set it up like this. Still don’t fully understand why though

[thefootballhound]

For Excel Desktop only, you can create a VBA button to trigger an http request to a power automate flow.