Unanswered

Pass value from power automate to power app

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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.

Categories:

Building Power Apps

All responses (22)

Answers (0)

Sort by

Pstork1 69,661 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

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 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Pstork1

Isn't the HTTP response action still considered a premium action?
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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 69,661 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

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 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@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.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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 69,661 Most Valuable Professional on at

Like
a
(2)

Report
Copy link

Link copied!
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)))
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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 69,661 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

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.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Pstork1 ,
I am using sample output from Parse Json (in Flow run history) as a Schema for HTTP response,.

HTTP response screenshot:

Anything missing?. One thing, Where we need to paste the JSON schema in Body or Generate from Sample?