Setting up recurring email using PowerAutomate

(1) Share

Report

Posted on by NR-08081938-0

Hello,

I'm trying to set up a recurring flow, which sends a marketing email to a little over 1,000 prospects using an excel (for business) file saved on OneDrive (for business). I'd like the flow to send in phases of 300 emails weekly and update the spreadsheet from "Not Sent" to "Sent" after the email is sent. For example, week 1 - flow sends to the first 300 updates spreadsheet to "Sent". Week 2 - flow sends to the next 300 "Not Sent" emails, etc. When I run the test, it doesn't work and it skips at the Condition action. Any thoughts on what I may be doing wrong or recommendations for a better way?

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Vejai SH 555 on at

Like (0)

Report

Hi @NR-08081938-0,

Check for any space in "Not Sent" condition and also in the check your excel file.

You can also add Compose before your condition and see what value is been populating.

Thanks,

Vejai SH

Please mark as answer if my suggestion helps you.

Was this reply helpful? Yes No
NR-08081938-0 4 on at

Like (0)

Report

Hi @Vejai SH

Thanks for your response. I tried that as well with no luck. I tested the same flow with an excel using one email, and it worked. I was thinking it might have to do with "Apply to each" expression? Not sure. In the mean time a created a partially automated flow removing the expression below and pulling from dynamic expression in filter array and manually adding 300 emails to the spreadsheet each week.

Was this reply helpful? Yes No
Suggested answer

Michael E. Gernaey 53,479 Super User 2025 Season 2 on at

Like (0)

Report

Hi @NR-08081938-0

If would really help if you shared the Flow Run. We need to see the flow run that didn't do what you wanted, so that you can open the List, the Filter and then the Apply to Each to see where the missing data is going.

You said you changed it to only have 1 row, but I wasn't sure if you meant in the file, or in the Take or where?

So just showing the Flow run, open the actions, share each Raw Input and Output

That is what will tell us the issue.

Also, do this please

Add a Compose above the Condition

in the please add this (exactly)

-DynamicProperty--Not Set-

This will show for 100% that there are matches.

Between these two things, the only other that would cause this is the Take essentially not working, not failing exactly, but.. we have not seen how many rows are coming out of the LIst and then the Filter, there could simply NOT be 300 for it to take and therefor taking 0

Cheers

If these suggestions help resolve your issue, Please consider Marking the answer as such and also maybe a like.

Thank you!
Sincerely, Michael Gernaey

Was this reply helpful? Yes No