custom connector as datasource

[StevenMoore]

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

[v-micsh-msft]

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

[StevenMoore]

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