Group SP List into Body of Email

[ashtonl98]

Hello I need to group unique data stored in SharePoint List - tableA - by the activity then add each user assigned to that activity into a format for an email - bodyA.

tableA

Activity	User
Emails	Liz
Emails	Jamie
Phones	Ryan
On-site	Luke

bodyA

Emails

Liz

Jame

Phones

Ryan

On-site

Luke

[v-xiaochen-msft · Accepted solution]

Hi @ashtonl98 ,

I did a test for you.

union(body('Select'),body('Select'))

items('Apply_to_each')['Activity']

item().Activity

item().User

Best Regards,

Wearsky