Grouping row by user and sending email from sharepoint

[nagestiada]

Hello guys I hope you can help me. I tried searching online but can't find any. I have a Sharepoint list and want to send an email of all the rows under their name. My Sharepoint list look like this:

User	Email	Price	Product	Status
Saffa Delaney	saffa.delaney@outlook.com	70	Chair	Sold
Kaylee Flower	kaylee.flower@outlook.com	150	Table	Cart
Kaylee Flower	kaylee.flower@outlook.com	15	Bottle	Sold
Kaylee Flower	kaylee.flower@outlook.com	2	Spoon	Sold
Saffa Delaney	saffa.delaney@outlook.com	67	Tent	Sold

So it will be like receipt

Each user will receive an email on all the product and price under their name with status of sold.

this will be send on a scheduled basis

Thank you so much for your help. Stay safe 

[v-LilyW-msft]

Hi @nagestiada 

Thank you for posting.

According to your description, you want to send email to user with all the products and price under their name with status of sold.

I created a Flow can achieve it, you can refer to the screenshots as below:

Filter Query: Status eq 'Sold'

Get the items which status is sold.

Expression: outputs('Search_for_users_(V2)')?['body/value'][0]['Mail']

This is my list

After flow runs, lilywang and Test2 will receive the email as below:

Hope the content above may help you.

Best Regards

If my solution helps, then please consider Accept it as the solution to help the other members find it more quickly.

[nagestiada]

Hello @v-LilyW-msft, thanks for your reply

Do I really need to search the user even if i already have a column for email?

[v-LilyW-msft · Accepted solution]

Hi @nagestiada 

Yes, you can also not use search the user, I made a slight modification to the flow, the same can be achieved, you can refer to the screenshot below:

Best Regards

If my solution helps, then please consider Accept it as the solution to help the other members find it more quickly.

[nagestiada]

Thank you so much for your help!

Last question if you wouldn't mind.

Is it possible to Update list item via SharePoint REST API

where on the HTML table I am sending i will add a link and when click it will automatically update the status column to Sold

[WHSBPjM]

@v-LilyW-msft ,

Hi, I'm trying to duplicate the exact same solution, however, your second screenshot is a bit confusing. Could you possibly explain where you got these dynamic items from in the Apply to Each loop as mine ran 125 emails instead of the expected 9 that I was expecting?

In my Apply to each after the union expression, where I attempted to use a compose, Power Automate puts it in its very own Apply to each, essentially having one inside another.