Hi community,
im trying to create an email to notify of new task assigned from a sharepoint list.
the data pull from 2 columns - task lead, and task member
task lead is a people column with single selection - no issue for this
task member is a people column with multiple selection - issue here
For email address setup, i followed this (
) with success. but im stuck at email body. does anyone know what can i do?
The result i want:
Hi [Task Lead] cc [Task Member 1, 2, 3, 4, 5]
appreciate your sharing
hi @v-xiaochen-msft ,
Thank you for your support, after trying again, it seems that the original thread I paste works for generating the display name too
the result from my testing, the email body will be
Hi John cc Mary, Jones, Andy,
Hi @AndyYWS ,
Please try this:
@{items('Apply_to_each')?['DisplayName']},
@{substring(variables('varName'),0,add(length(variables('varName')),-1))}
Best Regards,
Wearsky
Michael E. Gernaey
497
Super User 2025 Season 2
David_MA
436
Super User 2025 Season 2
Riyaz_riz11
244
Super User 2025 Season 2