@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 (Highlight to read)
<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>
<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)
