Skip to main content
Community site session details

Community site session details

Session Id : HWOAddBk7uzjBRYxrpP1Nn
Power Apps - Building Power Apps
Unanswered

Use custom connector data in power apps

Like (1) ShareShare
ReportReport
Posted on 8 Jul 2024 05:19:29 by

I used this API: https://datausa.io/api/data?drilldowns=Nation&measures=Population

I made a custom connector 'PopulationDataConnector' with action 'GetPopulationData'.

rapan062_0-1720414370790.pngrapan062_1-1720414404890.png

and the response is also imported from sample response in the custom connector. I tested the custom connector and the result is as follows:

rapan062_2-1720414454941.png

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(populationCollectionPopulationDataConnector.GetPopulationData({drilldowns:"Nation",measures:"Population"}).data)
 
Following error is shown.
 
Screenshot 2024-07-05 at 1.16.37 PM.png
 
 Why is this error coming?
 
  • AndrewR1 Profile Picture
    1,572 Moderator on 08 Jul 2024 at 08:19:25
    Re: Use custom connector data in power apps

    @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

  • rapan062 Profile Picture
    on 08 Jul 2024 at 08:07:23
    Re: Use custom connector data in power apps

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

  • AndrewR1 Profile Picture
    1,572 Moderator on 08 Jul 2024 at 07:27:13
    Re: Use custom connector data in power apps

    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

     

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

Announcing our 2025 Season 2 Super Users!

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410 Super User 2025 Season 2

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 2

Loading complete