cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Pass value from power automate to power app

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.

22 REPLIES 22
Pstork1
Dual Super User III
Dual Super User III

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. 



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
RandyHayes
Super User
Super User

@Pstork1 

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

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!
Anonymous
Not applicable

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
Dual Super User III
Dual Super User III

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.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
RandyHayes
Super User
Super User

@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. 

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!
Anonymous
Not applicable

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
Dual Super User III
Dual Super User III

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.

image.png

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.

image.png

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.

image.png

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)))


-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Anonymous
Not applicable

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

gokulnathSTG_0-1620823582567.png

sc2:

items property of combo box.

gokulnathSTG_1-1620823669930.png

 

In a combo box it shows true after flow run.

 

Pstork1
Dual Super User III
Dual Super User III

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.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (2,030)