Use custom connector data in power apps

(1) Share

Report

Posted on by rapan062

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:

ClearCollect(populationCollection, PopulationDataConnector.GetPopulationData({drilldowns:"Nation",measures:"Population"}).data)

Following error is shown.

Why is this error coming?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

AndrewR1 1,572 Moderator on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
rapan062 on at

Like (1)

Report
Copy link

Link copied!

how to pass the body of the json into the collection?

Was this reply helpful? Yes No
AndrewR1 1,572 Moderator on at

Like (1)

Report
Copy link

Link copied!

@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

Was this reply helpful? Yes No