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