Pass value from power automate to power app

[Anonymous]

Hi,

We are in the process of migration from InfoPath form to power app form. I need to use the values returned from power automate to power app combo box control. ( Items property). 

Note: In power automate i am using get list items which will get the value from List which is present in another site collection. The value returned i need to pass to power app combobox control. The main reason we are using automate is that particular list have more than 12 people picker. So that's why we are using automate otherwise i can add that list as a datasource in power app.

Any idea on this.

Thanks.

[Pstork1]

If the flow was launched from the Power App using a Power App button then you can use the HTTP response action to return a JSON array of values to Power Apps.  That return can then be stored in a collection.  You can use the Collection to populate your ComboBox. 

[RandyHayes]

@Pstork1 

Isn't the HTTP response action still considered a premium action?

[Anonymous]

Hi @Pstork1 ,

thanks for the input.I will be using on New and On Edit in SharePoint integration method.

Still can i use http response action ?

[Pstork1]

Yes, it should work on the OnNew and OnEdit actions.  But be aware, as Randy pointed out the HTTP response is a Premium connector.  But its the only way to get an array of data back from flow.  The Respond to Power Apps only returns an object with properties.

[RandyHayes]

@Pstork1 Thanks for clarifying it is premium.  I haven't used it in a while for that reason...wasn't sure if something had changed in the licensing. 

[Anonymous]

Hi @Pstork1 ,

Instead Respond to Power app step in automate, we need to use http response action.  Is it correct ?

If you have any example please share the screenshots.

Thankyou.

[Pstork1]

This flow is called from a Power app and does a Get Items from SharePoint, filters the rows and columns to only include the essentials, and then returns the results to Power apps.

The Select filters down to only the columns I want to return, then parse JSON to get the details of that array, finally a filter array to filter out unwanted rows.

Finally return the Body from the Filter array using HTTP response.  Be sure to run it once and use the output to get a JSON schema.

In Power Apps the Run command is used to submit any parameters to flow and store the results as a collection.

ClearCollect(MyData, GetItemsDemo.Run(Value(TextInput2.Text)))

[Anonymous]

Hi @Pstork1 ,

Thank you for the detailed explanation. I have created the flow and in HTTP response I am getting all the data.

But in Power app values are not populated.

sc1: --> to run the automate

sc2:

items property of combo box.

In a combo box it shows true after flow run.

[Pstork1]

If you look at colAppCodes after the run are you seeing any values?  If not, double check your schema in the HTTP response.  It looks like you are just getting a status value of True/false.  That's usually a sign that the JSON schema is missing from the response.