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 Apps / Passing a multi person...
Power Apps
Unanswered

Passing a multi person SP value from Flow back to Power Apps

(0) ShareShare
ReportReport
Posted on by 2

I have a SP list that my intended Power App users don't have access to but I need them to be able to get the data in couple of multi select person columns.

 

So I have a flow called within the Power App using the new V2 connector that allows the new Run As feature where I can designate my service account with Access to the SP list to get the data from the columns instead. As the multi person column is an array, how can I respond back to the Power App with this data. I would like this information to be prepopulated as the default selected items back in the Power App using a separate multi person field within a form 

Categories:
I have the same question (0)
  • victorcp Profile Picture
    2,350 Moderator on at

    Hi,

    I can thought of 3 ways to do that:

    1 - Convert your array into a string, send it to your app and use regex to convert it into a collection

    2 - You can concatenate the email (for example), respond it to your app and split it in the app

    3 - If you have a premium license you can use the response action which you can send a json/array to your app and create a collection with it.

    Hope it helps 🙂

  • v-xiaochen-msft Profile Picture
    Microsoft Employee on at

    Hi @jusnimaks ,

     

    I did a sample for you.

    vxiaochenmsft_0-1662541283630.png

    vxiaochenmsft_1-1662541311198.png

    [
     {
     "Claims": "",
     "DisplayName": "",
     "Email": "",
     "Picture": "",
     "Department": "",
     "JobTitle": ""
     }]

    vxiaochenmsft_2-1662541347207.png

     

    Best Regards,

    Wearsky

  • jusnimaks Profile Picture
    2 on at

    Thanks Wearsky,

     

    When it comes to the third method, I do have the premium connectors available, How would I do this if I have more than 1 multi person fields. Would I have to make a different flow to send a response from each column.

     

     

    I have been playing with method 1. See Screenshot below. I am sending the Claims and DisplayName as text back to the PowerApp, separated by "###" and then each person separated by "##Person##" using a join with the formula

    if(equals(outputs('Compose'),null),'',join(outputs('Compose'),'##Person##'))
    With example data it shows the following
    Claims: "i:0#.f|membership|johnsmith@contoso.com",DisplayName: "John Smith"##Version##Claims: "i:0#.f|membership|bobhope@contoso.com",DisplayName: "Bob Hope"
     
    Now I need to set the DefaultSelectedItems properties into the following format to get it work. What is the best way to perform this manipulation
    Table(
    {Claims: "i:0#.f|membership|johnsmith@contoso.com",
    DisplayName: "John Smith"},
    {Claims: "i:0#.f|membership|bobhope@contoso.com",
    DisplayName: "Bob Hope"})

    jusnimaks_0-1662543086511.png

    Thanks in Advance

     

  • v-xiaochen-msft Profile Picture
    Microsoft Employee on at

    Hi @jusnimaks ,

     

    I think It's too complex if you use 'Response to a powerapps or flow' action because it cannot pass array...

    I strongly recommend that you use the action 'Response' if you already have a premium license.

     

    "How would I do this if I have more than 1 multi person fields. Would I have to make a different flow to send a response from each column."

    No. You don't need to create more flows. You can create an object like this:

    vxiaochenmsft_0-1662544224036.png

    Hopefully it makes sense.

     

    Best Regards,

    Wearsky

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 Apps

#1
11manish Profile Picture

11manish 551

#2
WarrenBelz Profile Picture

WarrenBelz 430 Most Valuable Professional

#3
Valantis Profile Picture

Valantis 298

Last 30 days Overall leaderboard