Questions: I have an Excel file with multiple worksheets (tabs) stored in SharePoint document library.Is it possible to send an email notificatio

Hi @Robert5, I am afraid that the trigger when a file is modified/updated in a SharePoint folder couldn't do that. It will be fired as

Power Automate - Building Flows

Answered

Send email notification when Excel worksheet updated

Like (0) Share

Report

Posted on 3 Nov 2020 23:37:43 by Robert5

Questions:

I have an Excel file with multiple worksheets (tabs) stored in SharePoint document library.
Is it possible to send an email notification when the data in one specific worksheet (tab) in the Excel file is updated?
I haven't been able to find a solution other than using Visual Basic / macros???
If true, I'm a little surprised Power Automate can't do this...
Otherwise, I tried this route where I have an Excel file stored in a SharePoint document library. I set up a flow when a file is modified/updated in a SharePoint folder, send an email. The issue is for each cell I update in the Excel file, I get an email notification for each one.

I.e. If I access the Excel file and make changes to five cells (even making the changes quickly within seconds), I get five email notifications. I assume because after each cell update, the file autosaves (I.e. update cell one, autosaves; update cell two, autosaves, etc.)...

How can I have Power Automate (Flow) only send ONE email after the user makes all of their updates to the file?

Thank you in advance for any help.

All responses (2)

Answers (1)