How to get a table in Power Apps from Power Automate?

[WebPortal]

Hi,

I'm sending two values from Power Apps to Power Automate. These are being used to filter a Dataverse table I want to get back into Power Apps as a collection.

So this is my flow:

I'm afraid I can't go back to the old designer, but these are the details:

Back in Power Apps, I have button wiht the OnSelect property:

Set(myVar, MyFlow.Run(5, 6).resposta

So, upon clicking the button, I see the result of the variable is:

"Text Error: ConstraintViolated"

I simply want to get the JSON back into Power Apps.

[Pstork1]

There are two issues with the way you are doing it. 

1) Respond to Power Apps action can't send back an array.  It can only send back a string.  To send back an array you need to use the HTTP Response action and provide an appropriate Schema in the advanced settings.

2) If you are sending back an array then you want to capture the array as a collection using ClearCollect() instead of Set()

[WebPortal]

@Pstork1 

As always, I value your insight!

I've tried the HTTP Response, before the "Respond to Power Apps" action, but I struggle with the schema.

This is a dataverse table, what kind of schema should be passed?

[Pstork1]

Use the HTTP response in place of the respond to Power apps.  For the Schema, just grab the output you are returning from the table from a previous run and paste it into the Generate from Sample button under advanced Settings. Its the same process as using a Parse JSON.

[WebPortal]

I have been pulling the (rest of) my hair in order to get the schema right....

I've tried copying everything within the "value", like this:

[

      {

        "@odata.type": "#Microsoft.Dynamics.CRM.cre05_results_joa_api",

        "@odata.id": "https://xxx.crm4.dynamics.com/api/data/v9.1/cre05_results_ja_apis(1e3989da-9d85-ee11-8179-000d3a6557...)",

        "@odata.etag": "W/\"11809741\"",

        "@odata.editLink": "cre05_results_ja_apis(1e3989da-9d85-ee11-8179-000d3a655712)",

        "statecode@OData.Community.Display.V1.FormattedValue": "Ativo",

        "statecode": 0,

        "statuscode@OData.Community.Display.V1.FormattedValue": "Ativo",

        "statuscode": 1,

....

}

]

But I get the error:

The input parameter(s) of operation 'Response' contains invalid expression(s). Fix invalid expression(s) for the input parameter(s) of operation 'Response'.

Then what am I supposed to enter here????

I never get it...

[WebPortal]

And these are the input parameter:

[Pstork1]

Are you pasting that into the panel that opens when you click on the generate Sample Schema link?

First click on Show all

Then click on the Use Sample Payload to generate schema link.  That will open a panel. Paste the sample in the panel and click Done. That will generate the schema for you.

[WebPortal]

Yes, that's exactly what I'm doing:

[Pstork1 · Accepted solution]

It looks like you are pasting it directly into the schema rather than the dialog that opens up when you click on the Generate Sample link.  Take a closer look at my second screenshot. I highlighted the link you have to click on to get the dialog to open. That is where you paste the sample to generate the schema.

[WebPortal]

LOL, that's exactly the case 🙂

Thank you!

[grantjenkins]

Just curious - is there a reason you are running Power Automate to filter a Dataverse table and return the data? Why not just add a connection to the Dataverse table in your Power App and use a Filter on the table to show the results you're after. This would return the results quicker, and overall more efficient (will run the Filter delegated) and no need for a Power Automate.

As an example, when I select an item in my Gallery it resets my collection including a filtered set of results and certain columns that I want in my collection. 'Product Catalog' is my data source.

ClearCollect(colItems, ShowColumns(Filter('Product Catalog', 'Product Type' = Gallery2.Selected.Value), "crcb7_title", "crcb7_codename", "crcb7_productcategory"))

[WebPortal]

@grantjenkins 

Sure, that would be a lot more efficient.

I need to pivot a table that contains a variable number of columns, and I explored a possible solution with Power Automate.

It does work until the last step: since the schema is variable, I have no way to respond to Power Apps.