Unanswered

Collection value to Power Automate

(0) Share

Report

Posted on by cbernier12

248

Anyone know how to take a value from a collection displayed in a text field and send that value for use to a Power Automate flow? I've tried this, however it errors in the Power App. 'PowerApp->HTTP'.Run(Gallery3.Selected.id) The Flow is: "PowerApp->HTTP" and I want to use one of the values 'ID' as an input in a http string in Power Automate.

I crossed posted in Power Apps already: https://powerusers.microsoft.com/t5/Building-Power-Apps/Collection-value-to-Power-Automate/m-p/674721/highlight/false#M215487

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (0)

Sort by

CFernandes 8,504 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@cbernier12

Let consider, you have a Power Apps with two simple controls, Camera and Text Inputs.

Create a Collection in Power Apps.

Collect( Controlcollection, { Name: TextInput1.Text, Image: Camera1.Photo } );

You need to Convert the Collection in JSON using JSON function.

Set( JSONVar, JSON( Controlcollection, JSONFormat.IncludeBinaryData ) );

Pass the Variable in Power Automate.

MainFlow.Run(JSONVar)

In Power Automate, one you get the JSONVar variable you are Parse in using Parse JSON action.

You can have a look at my article:
https://clavinfernandes.wordpress.com/2020/02/12/convert-multiple-power-apps-media-controls-from-power-apps-screen-to-
html-and-pdfs/

Or just follow my video at https://www.youtube.com/watch?v=V8LpZpPGtV8

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
cbernier12 248 on at

Like
a
(0)

Report
Copy link

Link copied!

@CFernandes Thanks that moved me forward a bit. I have a gallery of items and when I select one I'd like to only have the ID of the selected item sent over to Power Automate as a variable. Right now all the IDs are sent over which isn't what I want.

Was this reply helpful? Yes No
yashkamdar 1,044 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello Team,

Here is what you need to do. Go ahead and add a check box to your Gallery control.

For the OnCheck property of Checkbox use the formula -
Collect(selected,{ID:ThisItem.Column3})

For the OnUnCheck property of Checkbox use the formula-
Remove(selected,{ID:ThisItem.Column3})

Then go ahead and configure a button and configure it as follows so that PowerApps passed the values of selected field as concatenated string to Flow -

IDGenerate.Run(Concat(selected,ID))

If you run the Power Apps, select the different check boxes and hit the button you get the different values -

(In my case, column 3 holds names of different persons so that has come up)

Was this reply helpful? Yes No
cbernier12 248 on at

Like
a
(1)

Report
Copy link

Link copied!

@yashkamdar Thanks for the point, I figured it out a different way: Set(varID,Gallery3.Selected.id);('PowerApp->HTTP'.Run(varID)). Worked perfectly.

Was this reply helpful? Yes No