Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

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".


Community Support
Community Support

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




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.


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




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.




Helpful resources

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

Power Apps Community Call

Power Apps Community Call- January

Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST

PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.


Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

Top Solution Authors
Top Kudoed Authors
Users online (3,624)