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 Automate
Answered

multiple select

(0) ShareShare
ReportReport
Posted on by 155

My flow is pulling information from one list (QC Tracker) into another (QC Review) when one column (status column) is updated. One of my fields is "Documents to QC" and it is multi-select. The QC Tracker list has two document types selected - PPT and PDF. When I run the flow, it creates two new list items, one with PDF and one with PPT. How do I make it so there is just one list item that contains both?

 

I think I need to use the initialize variable function, but I'm just not sure how to make it work. Any advice?

 

CROKat_1-1705352018349.pngCROKat_2-1705352037729.png

 

 

CROKat_0-1705351996494.png

 

Categories:
I have the same question (0)
  • creativeopinion Profile Picture
    10,508 Moderator on at

    @CROKat You don't need to initialize a variable. You can use a Select action.

    creativeopinion_0-1705353393435.png

    Click on this icon to switch to input entire array.

    creativeopinion_1-1705353436172.png

    Insert the Select action output.

    creativeopinion_2-1705353445677.png

    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! 

    👉 Watch my tutorials on YouTube
    👉 Tips and Tricks on TikTok

    Take a look a this YT Tutorial I recently uploaded: 3 Mistakes YOU 🫵 are Making with the Apply to Each Action in your Microsoft Power Automate Flow

    In this video tutorial I’ll go over how to avoid these common mistakes when using the Apply to Each action in a Power Automate flow:

    1️⃣ Looping through a Single Item

    2️⃣ Creating Unnecessary Nested Loops

    3️⃣ Looping through an Unfiltered Array

    At the end of the video I share a few helpful insights when it comes to using the Apply to Each action in your flow.

    I'll also cover:

     How to avoid the Apply to Each action with a single item array

     How to use the item() function to access dynamic content in an array

     How to prevent unnecessary nested Apply to Each action loops

     How to use the Select action

     How to convert an array to a string with the Select action

    How to use the Filter Query field

     How to count the number of items in an array

     How to use a condition control

     How to use the concurrency control

     How to set a top count

     How to use Compose actions for troubleshooting

  • CROKat Profile Picture
    155 on at

    Thanks for this suggestion. Where it says Map:"Value" do I put the word "value" or do I put "Documents to QC" which is the name of my field? Same question for the "Multi-Choice Value" next to it! Thanks for your help!

  • CROKat Profile Picture
    155 on at

    I am running into a similar issue with the "Assigned To" field. It is pulling from a Person or Group column in List A, but when the flow was triggered, I got this message that the API operation does now allow writing a value for parameter 'item/AssignedTo[0]/DisplayName.

     

    Would I use this same operation or a similar one to solve this issue as well?

     

    CROKat_0-1705455691017.png

     

  • creativeopinion Profile Picture
    10,508 Moderator on at

    @CROKat It's hard to say without seeing the full flow. Is the Person or Group Column a single or multi-selection?

  • WillPage Profile Picture
    2,323 Super User 2026 Season 1 on at

    Any multi-selectable column in SharePoint is an array. Therefore when you try and use it in an action that expects a non-array input, the Power Automate designer will automatically create an Apply to each loop and then put the action you tried to add the dynamic content into within the loop.

    To get around this issue, you need to convert your array into something else. In the case of a multi-selectable choice column, you would do this:

     

    1. Add a Select action
    2. Put your multi-selectable person column from dynamic content as the Input
    3. Below, click the little T icon to switch to JSON mode
    4. Click in there then go to the expression editor and type item()?['Value']
    5. This creates a single-column collection of the values from the multi-selectable choice column
    6. Next, add an action called Join from data operations
    7. In there, add the output from the previous Select action as the input
    8. Below, add a character or string or characters to join the array elements together. A comma is good, or comma-space or even a line break (enter)
    9. Now you can use that output of that join somewhere without creating Apply to each loops.
  • CROKat Profile Picture
    155 on at

    Thank you for your response! The only options I have to add into my Create Item as far as dynamic content goes is the output of the select action:

    CROKat_0-1705529428079.png

    is that what I put? Or should I be able to add the join action? Full flow below:

    CROKat_1-1705529519299.png

    CROKat_3-1705529585988.png

     

     

     

  • WillPage Profile Picture
    2,323 Super User 2026 Season 1 on at

    Is it the Assigned To column you're trying to add data to? What is the data type of that column?

  • CROKat Profile Picture
    155 on at

    CROKat_4-1705529657375.png

    From: triggerOutputs()['body/DocumentstoQC']

    Map: Key: Value, Enter Value: item()['Value']

    CROKat_5-1705529762722.png

    added Output of the select action for Documents to QC

  • creativeopinion Profile Picture
    10,508 Moderator on at

    @CROKat The Join action isn't necessary in your case. If you are using a multi-choice person column, the data needs to be in this format:

    creativeopinion_1-1705532269168.png

     

    To do this, you will need to adjust your Select action for the Multi-Choice Person Column.

    creativeopinion_0-1705532256631.png

     

    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! 

    👉 Watch my tutorials on YouTube
    👉 Tips and Tricks on TikTok

     

  • CROKat Profile Picture
    155 on at

    Could you tell me what you are putting in the From and Value section? There are so many options, wasn't sure if it is "Assigned To Claims" or "Assigned to Value" etc. I am wondering the same for the Select-Documents to QC action.

    CROKat_1-1705534221791.png

     

     

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 March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 592

#2
Valantis Profile Picture

Valantis 340

#3
11manish Profile Picture

11manish 284

Last 30 days Overall leaderboard