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

(0) Share

Report

Posted on by WebPortal

2,295

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.

Categories:

Building flows

I have the same question (1)

All responses (11)

Answers (1)

Pstork1 68,707 Most Valuable Professional on at

Like (1)

Report

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()

Was this reply helpful? Yes No
WebPortal 2,295 on at

Like (0)

Report

@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?

Was this reply helpful? Yes No
Pstork1 68,707 Most Valuable Professional on at

Like (1)

Report

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.

Was this reply helpful? Yes No
WebPortal 2,295 on at

Like (0)

Report

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-000d3a655712)",
"@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...

Was this reply helpful? Yes No
WebPortal 2,295 on at

Like (0)

Report

And these are the input parameter:

Was this reply helpful? Yes No
Pstork1 68,707 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No
WebPortal 2,295 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

Pstork1 68,707 Most Valuable Professional on at

Like (1)

Report

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.

Was this reply helpful? Yes No
WebPortal 2,295 on at

Like (0)

Report

LOL, that's exactly the case 🙂
Thank you!

Was this reply helpful? Yes No
grantjenkins 11,063 Moderator on at

Like (1)

Report
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"))

Was this reply helpful? Yes No