Answered

Powerautomate - Excel file data - sending email multiple times

Like (0) Share

Report

Posted on 23 Mar 2023 10:06:08 by nicksawe

I have a flow and this last section is not working as expected. I want to email the team leader, for each entry in the "body" variable. The leader's name is saved in the data, so I used the search for users block to find their email.

However, The moment I add a send an email block using the add an action link at the bottom, it creates another Apply to each block ! It then looks like this:

How do I avoid this, please? In the search for users block I have even set the threshold to 1, hoping this will only return one email but I still get the issue.

Thanks

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

nicksawe 9 on 24 Mar 2023 at 10:50:39

Like (0)

Report

Re: Powerautomate - Excel file data - sending email multiple times

hi @v-chengfen-msft , Thanks for your reply. I ended up solving this by adding a Select and compose ( I think compose alone would have worked as well) before the email. So it now looks like this

Thanks

Was this reply helpful? Yes No
v-chengfen-msft on 24 Mar 2023 at 02:20:49

Like (0)

Report

Re: Powerautomate - Excel file data - sending email multiple times

Hi @nicksawe ,
Can you tell me that you are sending emails to the leader of each record, are there multiple records for the same leader?
Can you show the apply to each for search user when the flow is executed?

Best Regards
Cheng Feng

Was this reply helpful? Yes No