How to properly get and display data from an external API endpoint as a table?

(0) Share

Report

Posted on by fpowerpas

So I have this simple api endpoint: myurl.com/get_all_data

It returns an array of items:

[ { "id": 1, "name": "A23", "color": "red" }, { "id": 2, "name": "A235", "color": "blue" }, { "id": 3, "name": "A238", "color": "green" } ]

I need the simplest and easiest way to load this data into a PowerApps Canvas and display it as a table there (that can be refreshed automatically on every page load).

| id | name | color |
|-----|-------|-------|
| 1 | A23 | red |
| 2 | A235 | blue |
| 3 | A238 | green |

Can someone help with what steps should I use to load this data and make it accessible to powerapps canvas and display it as a table?

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

David_MA 13,429 Super User 2025 Season 2 on at

Like (1)

Report
Copy link

Link copied!
If your data comes in just like you show, do the following:

Run the data through a Parse JSON action

Then use the Select statement to set up the data in order you want

Finally, use the Create HTML table action to generate the table

Again, if the data is just how you show it, you can use the following for your schema in the parse JSON action:

{ "type": "array", "items": { "type": "object", "properties": { "id": { "type": "integer" }, "name": { "type": "string" }, "color": { "type": "string" } }, "required": [ "id", "name", "color" ] } }

Your flow will look like this:

It will output this:

Was this reply helpful? Yes No
sandeepstw 312 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi There,

To display the API data in a PowerApps Canvas, you will first need to create a custom connector in Power Automate that connects to your API endpoint. Here's how to do it:
1. Go to Power Automate and click on "Data" -> "Custom Connectors" -> "New custom connector" -> "Create from blank".
2. Fill in the necessary details and move on to the "Security" tab.
3. Depending on your API, you might need to specify an API key or other credentials. If not, you can skip this step.
4. Go to the "Definition" tab, click on "New action", and fill in the details.
5. In the "Request" section, click "Import from sample", enter the API method (GET) and the URL of your endpoint, then click "Import".
6. Save the connector and click "Test". If everything is set up correctly, you should be able to test the connection to your API.
Next, go to Power Apps and follow these steps:
1. In the left pane, click on "Data" -> "Connections" -> "New connection", and select the custom connector you just created.
2. Open the app where you want to display the data (or create a new one), and add a "Table" control.
3. To load the data into the app, you will need to call the API when the app loads. You can do this in the "OnStart" property of the app. Enter the following formula, replacing "YourConnector" with the name of your custom connector, and "YourAction" with the name of the action you created:

```
ClearCollect(MyCollection, YourConnector.YourAction())
```
This formula clears and then updates the collection "MyCollection" with the data from your API.
4. To display the data in the table, set the "Items" property of the table to "MyCollection".
Now, every time the app loads, it will fetch the latest data from your API and display it in the table.

Give me kudos and mark as solution if it helps.

Thanks,
Sandeep

Was this reply helpful? Yes No