Sending an email a day although an Excel file is modified multiples times the same day

(0) Share

Report

Posted on by fgmarmol

Hello everyone,
After several weeks I have finally gotten my first Power Automate flow working, I am truly proud of my feat.
The problem arose when I have observed that every time the Excel sheet is modified, the flow send a new message, which I do not want. I want to send me only one message a day at 5:00 p.m., even if the Excel sheet has been modified several times before that time.

I'll give you a screenshot of the flow as an explanation, thank you very much.

1st flow.jpg

All responses (5)

Answers (0)

ChristianAbata 8,949 Most Valuable Professional on at

Like (0)

Report

Re: Sending an email a day although an Excel file is modified multiples times the same day

@fgmarmol
fgmarmol 4 on at

Like (0)

Report

Re: Sending an email a day although an Excel file is modified multiples times the same day

Please can you show me how?
fgmarmol 4 on at

Like (0)

Report

Re: Sending an email a day although an Excel file is modified multiples times the same day

Hello, thanks for answering. If I change the modified trigger to the recurrence trigger, how do I verify that the Excel sheet has been modified? Because I want the message to be sent only if new rows have been added, otherwise it would not be sent.
ChristianAbata 8,949 Most Valuable Professional on at

Like (0)

Report

Re: Sending an email a day although an Excel file is modified multiples times the same day

hi @fgmarmol could be better is you use just Delay instead of Delay Until
AlexEncodian 4,409 Super User 2025 Season 1 on at

Like (0)

Report

Re: Sending an email a day although an Excel file is modified multiples times the same day

@fgmarmol

Dont use a when file is modified trigger then. Use a Recurrence trigger (i.e. start flow at 5pm every day)