Showing results for 
Search instead for 
Did you mean: 
Responsive Resident
Responsive Resident

How to get specific items from sharepoint list and send email only once by creating HTML table

Hi All, 

I want to get the only the items which are submitted with the specific id, however i managed to get using Filter query function but when i try to send the details as email, there are Multiple email going to same account based on the Items count which which I'm trying to get/ 

Please have a look at the flow



Please have a look at the multiple emails say if i have submitted ID with number 5, and there are 3 other different records nested, its sending email for each of the item created in the list. 



Please see the sharepoint list screenshot


What im trying to do with flow is get the items from sharepoint list with customer_appid = 269 and then create a table and send that as a email to user. 

I got the result, but only issue is im getting 4 emails with same details.

I do not where did i missed and how it needs to be solved. 

Bus if yes can i please know how can i solve this issue. I think that this can be doing using the customer trigger but again not sure will that work. 

Thanks for your help in advance experts. 


Super User III
Super User III

Hello @Tapesh 


Since you're not suing a Apply to each loop, there should not be multiple emails being sent.


What I have noticed in your screenshot was the name of your Flow "Copy of - Adaptive Card test".

Please make sure you do not have other Flows triggering on the same trigger and sending you emails.

Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up

Proud to be a Flownaut!

Check out my blog for Power Automate tips, tricks, and guides

Super User
Super User

Hi @Tapesh ,


I can see that you have asked the same question in General Automate Discussion forum.


I have answered to this. 

Please refer this link to check if that solution works for you. 


If this answered your question, please mark this question as answered and if you liked my response, please consider giving it a thumbs up .

Thank You !!!

Helpful resources

PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.


Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Top Solution Authors
Users online (6,003)