Answered

Grouping row by user and sending email from sharepoint

(0) Share

Report

Posted on by nagestiada

504

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

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Sort by

v-LilyW-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
nagestiada 504 on at

Like
a
(0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Verified answer

v-LilyW-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
nagestiada 504 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
WHSBPjM 59 on at

Like
a
(0)

Report
Copy link

Link copied!

@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.

Was this reply helpful? Yes No