Hi I am looking to build a flow that would filter a sharepoint list and send the results in an HTML table to email address in the filtered table.
This is my sharepoint list:
In my flow I want to filter the data by Client and then send the filtered data to the email of the Contact.
@efialttes I tried what you had suggested in this post but how select items appears now is causing an issue because in your example the map function of "Select Leader" does not have a key, which i believe is causing an issue when i try to construct this flow: https://powerusers.microsoft.com/t5/Building-Flows/MS-Flow-Send-email-with-filtered-sharepoint-list-items-on-an/td-p/470804
Can anyone please help me with this?
Thanks Reza for the help, the combination of videos helped me resolve the issue.
Hi Reza, thanks for sharing the links. In video 1 you are sending the email to yourself and in video 2 you are sending the email who initiated the flow.
In my scenario I want to leverage my sharepoint list column "Contact" and use that to send an email.
For example abc@xyz.com to be sent the table values that are assigned to particular contact:
Hi @mhaisam
SP filter in flow - Power Automate OData Filter Query flow for SharePoint list - YouTube
HTML in flow - https://www.youtube.com/watch?v=VnWg-Eox37Q
--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.
Thanks,
Reza Dorrani, MVP
YouTube
Twitter
Tomac
986
Moderator
stampcoin
699
Super User 2025 Season 2
Riyaz_riz11
577
Super User 2025 Season 2