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

Like (0) Share

Report

Posted on 15 Nov 2023 12:26:03 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

I have the same question (0)

All responses (5)

Answers (0)

ChristianAbata 8,949 Most Valuable Professional on 16 Nov 2023 at 16:22:24

Like (0)

Report

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

@fgmarmol

Was this reply helpful? Yes No
fgmarmol 4 on 15 Nov 2023 at 18:18:39

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?

Was this reply helpful? Yes No
fgmarmol 4 on 15 Nov 2023 at 18:16:45

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.

Was this reply helpful? Yes No
ChristianAbata 8,949 Most Valuable Professional on 15 Nov 2023 at 14:43:40

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

Was this reply helpful? Yes No
AlexEncodian 4,409 Moderator on 15 Nov 2023 at 14:41:52

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)

Was this reply helpful? Yes No