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.