cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
StevenMoore
Level: Powered On

custom connector as datasource

I have a custom connector to an API that works fine in test. It returns multiple records containing Employee data. What I can't get to work is connecting this as a datasource to a gallery so that I can scroll through my Employees.

 

I have tried CustomAPI.GetAllEmployees(1,'MY API KEY') this returns an error "The property expects table values...this rule provides text values".

 

2 REPLIES 2
Community Support Team
Community Support Team

Re: custom connector as datasource

Hi @StevenMoore,

 

Please take a try with the table function.

If the API returns Multiple records, then we could take use of the table fucntion to convert it into a table.

Table function in PowerApps

 

Further, take a try to use clearcollect to hold the data into a collection:

Collect, Clear, and ClearCollect functions in PowerApps

 

Regards,

Michael

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
StevenMoore
Level: Powered On

Re: custom connector as datasource

Michael

In the items property I have tried this already in the form:

 

Table(MyAPI.GetAllEmployees(1,"My_API_KEY_pqjqxbFAt-ls_rgkiE"))

 

this returns the error:

"Cannot use a non-record value in this context"

 

Trying to collect the data into another variable throws the same error.

 

Regards

Steve

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 325 members 5,894 guests
Please welcome our newest community members: