How to get data from Power automate

[PierreCA]

Hello, 

I've build a query in Power automate that sends back a filtered array with a very limited number of rows. The list return the right values.

The output of the flow is the following: 

[
    {
        "ID": "7",
        "nomClient": "Ricker, Bertrand",
        "actif": "1"
    },
    {
        "ID": "8",
        "nomClient": "Thurina Minor, Octavie",
        "actif": "1"
    },
    {
        "ID": "9",
        "nomClient": "Pool, Dead",
        "actif": "1"
    }
]

I try to see the result in a combobox in Power Apps but I cannot select the columns. Value is the only option. 

Content of the combobox. 

Content of the collection: 

Something is missing in either Power Automate or Power Apps but I can find what? Any idea?
 

Code of the collection

 ClearCollect(
    collListeClientsActifsUneEntite;
    LienClientActif_Entite.Run(varId.id_en).liens_trouves

);;

[FLMike]

@PierreCA 

Can you please share what the output back to PA/CA looks like from PA/Flow.

Also, if you assigned the Items property of the ComboBox to the Collection, make sure you click Edit and pick which field value it should show otherwise many times its blank

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

[FLMike]

@PierreCA 

Please show the "respond to Power Apps" Action, then show the values of the outgoing outputs. Do so in a run please, not just the code view.

Then in PA, please show at run time the value that appeared in your collection.

We can narrow it down from there.

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

[PierreCA]

Hello @FLMike , 

Tnaks for your help. 
I add contextual information and results to the first post. 

[FLMike · Accepted solution]

@PierreCA 

Thank you kindly for adding and I didn't remember posting twice sorry about that lol.

Ok here is what you can do.

First I created Flow as such

It will return the JSON what we need for the collection.. Except unfortunately its a string.

So in the App we need to convert it into a collection.

So the first line runs my Flow and gets the object it passed back as a string

The second line uses Regular expressions to pull back the stuff into a collection.

Set(getObject, '[Sample]ConvertingobjectstoCollectionsfromPA'.Run().output);

ClearCollect(resultItems,
 MatchAll(getObject,
"(""ID"":""(?<ID>[^""]*)"",""nomClient"":""(?<nomClient>[^""]*)"",""actif"":""(?<actif>[^""]*)"")")
            );

Now I have a collection

And can bind that to the ComboBox. It gives more info than you need, but it does provide you the data points you need

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

[PierreCA]

Thanks @FLMike , 

It helped me a lot. I would'nt have guess in any way the last part.

For it I compact the code a little more as follow. 

ClearCollect(
    collListeClientsActifsUneEntite;
    MatchAll(
    LienClientActif_Entite.Run(varId.id_entite_fantome).liens_trouves;
    "(""ID"":""(?<ID>[^""]*)"",""nomClient"":""(?<nomClient>[^""]*)"",""actif"":""(?<actif>[^""]*)"")")

);;