Few JSON string and tables

(0) Share

Report

Posted on by CU09100753-0

170

Hi guys

I would like to get table from JSON String.

So there are my 3 strings and I run Power Automate Flow for each String,

ClearCollect(Expences; JSONParse.Run(DataCardValue73.Text;"Expences"));;
ClearCollect(Cars; JSONParseCars.Run(DataCardValue74.Text;"Cars"));;
ClearCollect(Employees; JSONParse.Run(DataCardValue75.Text;"Employees"))

Then parse JSON, Compose body and Response this table back.

And it works, but only for first string.

So what i got for Expences tab:

What I got for Cars:

this table should have only two fields: Number and Car, but somehow two fields from expences tab also here?! WTF?
And field Car is empty...

The same problem whit third tab

Power Automate returned right data, but PowerApps transform wrong fields

Do you know how fix it?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (2)

Verified answer

Pstork1 68,851 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

If you are using just one Parse Json action in the flow that is the problem. For Parse JSON to work properly you need to load a schema that matches the specific input. Since the schema is probably different for all three tables you can't use the same Parse JSON for all three. The same schema is required for the HTTP response to return the JSON to Power Apps. So you can't use a single flow for three different JSON strings. Each flow needs to be specific for the JSON being passed to it.

Was this reply helpful? Yes No
CU09100753-0 170 on at

Like (0)

Report
Copy link

Link copied!

Here also everithing ok.
For every string - another JSON schema and connectors
Also i create another flow for second string... and result the same.

Was this reply helpful? Yes No
Verified answer

Pstork1 68,851 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

You can't have 3 http responses in one flow. When you add it to Power Apps it uses the JSON schema from the HTTP response to know what it should be getting back. There is no way to accomplish what you want with one flow. You have to have three separate flows, one for each schema response.

Was this reply helpful? Yes No
CU09100753-0 170 on at

Like (0)

Report
Copy link

Link copied!

Ok, I see

I did it, but it didn't work,
Now just update schema and it works,
Thank U, Bruce Wayne

Was this reply helpful? Yes No