Showing results for 
Search instead for 
Did you mean: 
Continued Contributor
Continued Contributor

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

Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Users online (47,187)