Unanswered

Schedule Run - Sending multiple emails

(0) Share

Report

Posted on by ivmso

Hi - I'm new to Power Automate and I'm trying to build a scheduled flow where it sends an email based on a column named "Reassignment (Yes or No)." If it has been marked as "Yes" then it should send an email out to the corresponding person. However, I want it to send emails each time it runs only if an additional item has been marked as "yes," if not then no email should be sent. Also, there are several items that have been assigned to one person. How could I send this as a list instead of separate emails? My flow is as follows:

Catalog ID = Unique identifier for the item

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Pstork1 68,717 Most Valuable Professional on at

Like (0)

Report

The easiest way to do this would be to use a third value in the Yes/No column, like Pending. Then set the column to Pending when the email should be sent and have the flow then change it to Yes after the email is sent. So when the flow runs again on the schedule it should only send emails if a value is marked as Pending. If its set to Yes then the email was sent previously and doesn't need to be repeated.

Was this reply helpful? Yes No
ivmso 2 on at

Like (0)

Report

@Pstork1 - Do you know how the flow would look? I don't know what functions I would have to use to get the flow to mark it as "yes" after the email has been sent.

Was this reply helpful? Yes No
Pstork1 68,717 Most Valuable Professional on at

Like (0)

Report

You would use the Update a Row action for each row where you see the value to send the email. The dynamic content in the loop should have all the values you need. Just use the Update a Row to change that one column value.

Was this reply helpful? Yes No