Power Automate Exchange

Please login or click SIGN UP FOR FREE to create your FlowUG account to join this user group.
 View Only
  • 1.  Mapping 'Select Multiple' fields in SharePoint

    Bronze Contributor
    Posted Jul 19, 2022 10:20 AM
    I have a strange little problem that I just can't think of a good workaround for:

    We have two SharePoint lists with identical columns. Two of the columns are Person/Group fields where there are sometimes multiple entities selected.

    We're trying to dump the items from one of the lists into the other existing list. I thought this would be a super simple button flow with a 'Get Items' from the first list and a 'Create Item' in the second list, but the fact that these fields allow multiple selections introduces two additional 'Apply to each' boxes around the 'Create Item' and these error out (because they are running on an object rather than a valid array).

    What's the smart solution here?

    ------------------------------
    Autumn Schuman
    ------------------------------


  • 2.  RE: Mapping 'Select Multiple' fields in SharePoint

    Top Contributor
    Posted Jul 20, 2022 12:39 AM

    In your create item action, click the T icon on the right to switch to raw input mode:


    Now it's in that mode, your dynamic content selector will only show properties that are of type array (or any)

    When you add the person column here, no Apply to each loop is automatically created.



    ------------------------------
    Will Page
    Technical consultant
    Christchurch, NZ
    ------------------------------



  • 3.  RE: Mapping 'Select Multiple' fields in SharePoint

    Bronze Contributor
    Posted Aug 31, 2022 11:24 AM
    Error message indicating that Display Name is read-onlyHi, Will! Thanks so much for your prompt reply to my initial issue. I'm struggling now with an error when I try to execute the flow on items with multiple items selected--it's telling me Display Name is read-only, which means it can't map in the array for the select-multiple Person/Group columns.

    Do you have a lovely solution for this too, by chance?

    Thanks so much!
    Autumn


    ------------------------------
    Autumn Schuman
    Power Platform Solutions Specialist
    Coralville IA
    319-830-0636
    ------------------------------