Build a collection of items returned from ms FLOW

(0) Share

Report

Posted on by notepadapp

143

Hi,

I have a flow which should return a list of devices to powerapps. I want to organize them within a collection.

My powerapps button does the following, could somebody please advise how I could get this working?

ClearCollect(
 DeviceCollection,
 Table('DeviceRequest'.Run("Param1").result.value
 {
 Device: Device
 }
 )
)

Here is the flow for reference.

Output of "Output" is similar to the below:

{
 "statusCode": "200",
 "schema": {
 "type": "object",
 "properties": {
 "result": {
 "title": "Result",
 "x-ms-dynamically-added": true,
 "type": "string"
 }
 }
 },
 "body": {
 "result": "[{\"Device\":[\"MacBook Pro - HOSTNAME\",\"Latitude 7410 - HOSTNAME\"

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

v-yueyun-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi , @notepadapp

You can try to use this code in Power Apps:

ClearCollect(DeviceCollection,ForAll( Table( ParseJSON( 'DeviceRequest'.Run("Param1").result )) , {Device : Text(ThisRecord.Value.Device )} ) )

For more information, you can refer to :
ParseJSON function - Power Platform | Microsoft Learn

If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance!

Best Regards,

Yueyun Zhang

Was this reply helpful? Yes No
notepadapp 143 on at

Like
a
(0)

Report
Copy link

Link copied!

That worked, though I believe the values aren't being presented correctly or are the correct type.
When I do a dropdown/combobox of the collection I get this:

Was this reply helpful? Yes No
Verified answer

v-yueyun-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi , @notepadapp

Thanks for your quick response! Sorry , your Device is an array in your flow..

I test it in my side , if it is an array , you can try to use this code :

ClearCollect(datatest, Ungroup( ForAll( Table( ParseJSON('DeviceRequest'.Run("Param1").result )) , {Device : ForAll( Table(ThisRecord.Value.Device ) , {Device : Text(ThisRecord.Value)}) } ) ,"Device") )

And if you want to get the Distinct Device , you can use this code :

ClearCollect(datatest, Distinct( Ungroup( ForAll( Table( ParseJSON('DeviceRequest'.Run("Param1").result )) , {Device : ForAll( Table(ThisRecord.Value.Device ) , {Device : Text(ThisRecord.Value)}) } ) ,"Device") ,Device) )

If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance!

Best Regards,

Yueyun Zhang

Was this reply helpful? Yes No
notepadapp 143 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you Distinct Device worked 🙂

Was this reply helpful? Yes No