Email Confirmation forced in a loop

[HindAlmarzooqiP]

Hi all,

i have this flow. My thing is to initiate this whenever a button is clicked in power app and moving forward it should lead to an approval process(which goes to a manager) and i want to send a confirmation that we received the records for the employee who submitted the data.

However, whenever i add an email step it's forces it to in a for each loop which sends the email multiple times depending on the number of records submitted. i want to send it once. I tried to delete the loop and forces it without but I get another error. Any workaround or clear solution?

Thank youuuuuuuuuuuuuuuuuuuuu

[RobElliott]

@HindAlmarzooqiP you will always get an apply to each if you just add the email action after the get items because that action can potentially bring back multiple items from the list and it would need to loop through them.

To get over that and only send a single email you need to use a Select action as follows. In my example I'm getting dates when a user has been in Europe. As you'll see, immediately after the get items is the select with the left field being the column titles I want and the right field being the dynamic content from the list.

After that I added a Create HTML Table action.

I then added a Compose action with css styles because the default html table in Power Automate doesn't have any styling.

In case you want to copy that style it is in the spoiler below. At the bottom of the Compose you select the outputs of the Create HTML Table action.

Spoiler

<style>
table {
border: 1px solid #1C6EA4;
background-color: #EEEEEE;
width: 75%;
text-align: left;
border-collapse: collapse;
}
table td, table th {
border: 1px solid #AAAAAA;
padding: 3px 2px;
}
table tbody td {
font-size: 13px;
}
table thead {
background: #1C6EA4;
border-bottom: 2px solid #444444;
}
table thead th {
font-size: 15px;
font-weight: bold;
color: #FFFFFF;
border-left: 2px solid #D0E4F5;
}
table thead th:first-child {
border-left: none;
}
</style>

Then in your email you select the outputs of that formatted table:

And this is the result with multiple items from the get items but just in a single email:

Rob
Los Gallardos
Principal Consultant, SharePoint, Forms and Power Platform, WSP Global (and classic 1967 Morris Traveller driver)

[HindAlmarzooqiP]

Hi Rob, wow many thanks for the very thorough reply and organization in your response. I appreciate it. I tried to do however my main goal is to just share an email to say that I have received the input. 

[Akshansh-Sharma · Accepted solution]

@HindAlmarzooqiP ,

Can you please implement these steps which will achieve your requirements

1. create a new Trigger Parameter with name "RequestorEmail"
2. When you are triggring this flow from your app i.e. OnSelect of your button pass this parameter value with the current user email like this FlowName.Run(RequestorEmail:User().Email)​ 
3. Then use the dynamic content from your trigger and add the RequestorEmail into your To property of your send an email action 

This will send an email to the requestor that you received their inputs without the need of Get Items

Let me know how you get on

--------------------------------------------------------------------------------------------------------------------

Please click Accept as solution if my post helped you solve your issue. If the content was useful in other ways, please consider giving it Thumbs Up 😉

LinkedIn- https://www.linkedin.com/in/akshansharma/

[HindAlmarzooqiP]

Hi @Akshansh-Sharma Many thanks!!! appreciate your inputs