Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

API Response to Powerapps

(0) ShareShare
ReportReport
Posted on by 178

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

 

 

  • Verified answer
    christian12 Profile Picture
    christian12 178 on at
    Re: API Response to Powerapps

    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.

     

  • christian12 Profile Picture
    christian12 178 on at
    Re: API Response to Powerapps

    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.

     

    christian12_0-1717667156612.png

    Responding to Power Apps using the Response action

     

    christian12_1-1717667254822.png

     

    This is my API response

    christian12_0-1717672971452.png

     

     

  • scalca Profile Picture
    scalca on at
    Re: API Response to Powerapps

    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 ?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,343

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,703

Leaderboard