I used this API: https://datausa.io/api/data?drilldowns=Nation&measures=Population
I made a custom connector 'PopulationDataConnector' with action 'GetPopulationData'.
and the response is also imported from sample response in the custom connector. I tested the custom connector and the result is as follows:
Now in the power apps, I connected the custom connector in the data section of the power app. Then, I inserted a button label. In the button's onSelect Property i wrote the following formula:
@rapan062 try removing the .data form your formula and see if this passes the body of the JSON into the collection you could also maybe try using Power automate instead of the custom connector to pass in the data on load rather than using this directly in the app you can then do some data compose and config beforehand.
This wouldn’t be something I can guid you on as this is a custom connector, and I don’t have an example of this to show you unfortunately but the idea is that you would need to pass the body of the JSON in to the collection.
Please click Accept as solution if my post helped you solve your issue. ✔️ This will help others find the solution to this problem. It also closes the item. Remember, you can accept more than one post as a solution.
If the content was useful in other ways, please consider giving it Thumbs Up. 👍
Thanks
Andrew
how to pass the body of the json into the collection?
Hi @rapan062 try just passing the Boday of the JSON in to the collection as this should parse this in to a table for you.
Please click Accept as solution if my post helped you solve your issue. ✔️ This will help others find the solution to this problem. It also closes the item. Remember, you can accept more than one post as a solution.
If the content was useful in other ways, please consider giving it Thumbs Up. 👍
Thanks
Andrew
WarrenBelz
791
Most Valuable Professional
MS.Ragavendar
410
Super User 2025 Season 2
mmbr1606
275
Super User 2025 Season 2