Skip to main content
Community site session details

Community site session details

Session Id : 3xC06XZoCOc0NjB5h4p35Y
Power Automate - Building Flows
Answered

How do I format an array using a Select action for a SharePoint list?

Like (0) ShareShare
ReportReport
Posted on 10 Apr 2024 15:02:35 by 413

Hello,

 

I am creating a flow to copy items to a second list based on Status = Awarded. Both lists have 3 multiple select columns 2 of the columns are claims and are formatted nicely when created in the second list. The value column formatting is ugly. See screenshot below. How can I clean this up so it only shows the items in the drop-down list and not the extra brackets, braces and Value text?

 

FormatArray.PNG

  • Verified answer
    creativeopinion Profile Picture
    10,458 Super User 2025 Season 2 on 10 Apr 2024 at 18:07:10
    Re: How do I format an array using a Select action for a SharePoint list?

    @trishmalloy You need to ensure you are using the Select array when updating your SP list. Right now, you are inserting the array as a string of text. 

     

    For your multi-choice column, select this icon to input the entire array.

    creativeopinion_0-1712772360466.png

    Insert the output from the Select action.

    creativeopinion_1-1712772396635.png

     

    If you are looking for a way to send multiple SharePoint List items that have been assigned to a user in an email—check out this YT Tutorial: How to Send a SINGLE EMAIL ✉️ with multiple SharePoint list items | Build THIS Power Automate Flow

     

    IN THIS VIDEO:

    âś… How to send multiple list items in a single email with a Power Automate Flow

    âś… How to create a dynamic date range

    âś… How to use the Convert Time Zone action

    âś… How to use a Filter Query in the Get Items action

    âś… How to count number of items in an array

    âś… How to use the Select action to extract a users display name and email address

    âś… How to create a unique list of email addresses

    âś… How to use the Create HTML Table action

    âś… How to customize the HTML Table with CSS styles

    âś… How to use the Send an email (V2) action

    âś… How to use the Append to String Variable action

    âś… How to create a custom list of items for an email

    âś… How to use the Send an email (V2) action

    âś… How to display singular or plural text based on the number of items returned

     

    Hope this helps!

    If I helped you solve your problem—please mark my post as a solution ✅.
    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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Loading complete