Unanswered

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

(0) Share

Report

Posted on by jusnimaks

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:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

victorcp 2,350 Moderator on at

Like (0)

Report
Copy link

Link copied!

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 🙂

Was this reply helpful? Yes No
v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @jusnimaks ,

I did a sample for you.

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

Best Regards,

Wearsky

Was this reply helpful? Yes No
jusnimaks 2 on at

Like (0)

Report
Copy link

Link copied!

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"})
Thanks in Advance

Was this reply helpful? Yes No
v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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:

Hopefully it makes sense.

Best Regards,

Wearsky

Was this reply helpful? Yes No