API Response to Powerapps

(0) Share

Report

Posted on by christian12

204

Currently have a power-app that triggers a power automate flow that retrieves multiple tables via an API.

All tables/Values are embedded within the API response and it stores the values in a collection. Issue I'm facing is that only the first table values are populated in the collection. From the below example I will only have data for Table A the other tables will have collection heading names although no data.

TableData Table Name

Nested collection A

Nested collection B

Nested collection C

Any help is greatly appreciated.

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

scalca on at

Like (0)

Report
Copy link

Link copied!

pls share how you're getting the table values from power automate and how it is responding
do you have the expected result in power automate ?
how are you responding to power apps and how are you populating the collection ?

Was this reply helpful? Yes No
christian12 204 on at

Like (0)

Report
Copy link

Link copied!

ClearCollect(TempTypes,'Forms_Test'.Run(GUID,UserName,PW,DateSent,APIURL,APIUserName,APIPW).response.payload.LookupTables)

Sorry its actually not returning the correct collection headings. It's using the same headings from the first table.

Responding to Power Apps using the Response action

This is my API response

Was this reply helpful? Yes No
Verified answer

christian12 204 on at

Like (0)

Report
Copy link

Link copied!

Got it working. It was the schema in the response. Had to use a online JSON to schema tool as the power automate generate from sample was not working correctly.

Collection is returned to power-apps and in Power Apps I save these into separate collections.

Was this reply helpful? Yes No