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

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.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
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 ?

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.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
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.

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.

 

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
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Users online (2,058)