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

Community site session details

Session Id : YeZwVqxCvWLxIaNz5s4IEP
Power Automate - Building Flows
Answered

multiple select

Like (0) ShareShare
ReportReport
Posted on 15 Jan 2024 20:54:44 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

 

I have the same question (0)
  • CROKat Profile Picture
    155 on 18 Jan 2024 at 00:21:05
    Re: multiple select

    This worked! Thank you very much for putting up with my many questions😅

  • Verified answer
    creativeopinion Profile Picture
    10,474 Super User 2025 Season 2 on 17 Jan 2024 at 23:48:30
    Re: multiple select

    @CROKat In the From field you need to insert the dynamic content of the multi-choice person column. This would be the name of your multi-choice column (in your case, it would be Assigned To). Multi-choice and Multi-choice person columns return an array of choices/people. 

    creativeopinion_0-1705535257640.png

     

    The Select action will take an array (input) and select the content you want to return from that array (output). In this case you want to return the email address. So in the value field, you want to insert the Assigned To Email dynamic content. 

    creativeopinion_1-1705535288911.png

     

  • CROKat Profile Picture
    155 on 17 Jan 2024 at 23:31:10
    Re: multiple select

    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

     

     

  • creativeopinion Profile Picture
    10,474 Super User 2025 Season 2 on 17 Jan 2024 at 22:57:58
    Re: multiple select

    @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 17 Jan 2024 at 22:16:36
    Re: multiple select

    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

  • WillPage Profile Picture
    2,235 Super User 2025 Season 2 on 17 Jan 2024 at 22:16:01
    Re: multiple select

    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 17 Jan 2024 at 22:13:28
    Re: multiple select

    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,235 Super User 2025 Season 2 on 17 Jan 2024 at 04:09:11
    Re: multiple select

    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.
  • creativeopinion Profile Picture
    10,474 Super User 2025 Season 2 on 17 Jan 2024 at 02:08:05
    Re: multiple select

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

  • CROKat Profile Picture
    155 on 17 Jan 2024 at 01:41:57
    Re: multiple select

    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

     

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Telen Wang – Community Spotlight

We are honored to recognize Telen Wang as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 986 Moderator

#2
stampcoin Profile Picture

stampcoin 699 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 577 Super User 2025 Season 2

Loading complete