web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / i want to add value of...
Power Automate
Answered

i want to add value of column of type person with multiple value in a table

(0) ShareShare
ReportReport
Posted on by 110
hello i want to creat html table containe value from spo list and of column is person column with multiple item 
any help ?
 
 
Categories:
I have the same question (0)
  • Verified answer
    creativeopinion Profile Picture
    10,508 Moderator on at
    @CU12111019-0 The logic of your flow needs to be adjusted. Take a look at this YT Tutorial: 
     
    How to Handle Multi-Person SharePoint Item Notifications in Outlook and MS Teams with Power Automate
    Do you want to know how to send an email to all users assigned to a SharePoint item? If so—this Power Automate tutorial is for YOU 🫵.
    In a different YouTube tutorial I cover how to build a Power Automate flow that sends a single email to each user with the tasks assigned to them.

    However, that tutorial only covered a scenario where each task is assigned to a single user. What if your task is assigned to more than one user?
    In this Microsoft Power Automate tutorial I’ll cover how to create a flow that is triggered by selecting an item. This automation will send an email to all assigned users for the selected task. I’ll also show you how to adjust your flow so that you can send a message in Teams. Then I’ll show you how to collect a list of unique users that have been assigned to multi-person tasks. Using this concept, we’ll edit the flow from the previous tutorial so that it works with a multi-person column.

    IN THIS VIDEO:
    ✓ How to trigger a flow from a selected file
    ✓ How the multi-person column data outputs
    ✓ How to use the Select action to get all assigned to users of a SharePoint item
    ✓ How to use the Join action to convert an array of email addresses into a string
    ✓ How to send a single email to all assigned to users of a SharePoint item
    ✓ How to send an email to each assigned to user of a SharePoint item
    ✓ How to send a Teams message to each user assigned to a SharePoint item
    ✓ How to return a list of unique users from the multi-person column in a SharePoint list
    ✓ How to use a Filter Array action to return all SharePoint list items assigned to each user
    ✓ How to group Power Automate actions together with the Scope action
    ✓ How to edit a previous flow

    If you still run into issues with your flow, ensure you toggle off the New Designer and click each action to expand it. Upload a screenshot of your flow in edit mode.
     
    Hope this helps!

    Consider giving me a ❤️ if you liked my response!

    👉 Level up your Power Automate skills by checking out my tutorials on YouTube
    👉 Tips and Tricks on TikTok and Instagram
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 976

#2
Valantis Profile Picture

Valantis 863

#3
Haque Profile Picture

Haque 547

Last 30 days Overall leaderboard