Unable to show data in power apps getting error

[dws]

Hello All,

I have create one of apps on powerapps using custom api(connection). But Its not working.

Error "the property expects table values, but rule produces incompatible record value".

I am using this method to get all data for gallery. Please check syntax is write?

CH1WPData0315.getalldata({status:"publish"})

getalldata-: Is swagger end point to get all data. My swagger working fine on swagger editor.

Thanks,

Dws

[dws]

Hello,

Please see the error in screen shot also sent  the swagger schema.

{
"swagger": "2.0",
"info": {
"version": "1.0.0",
"title": "CH1WPPosts0315",
"description": "",
"contact": {
"name": "dws",
"url": "https://devsite.co.in/"
}
},
"host": "devsite.co.in/swagger",
"basePath": "/data",
"schemes": [
"https",
"http"
],
"securityDefinitions": {
"basicAuth": {
"type": "basic",
"description": "HTTP Basic Authentication. Works over `HTTP` and `HTTPS`"
}
},
"produces": [
"application/json"
],
"paths": {
"/v2/posts": {
"get": {
"security": [
{
"basicAuth": []
}
],
"tags": [
"posts"
],
"summary": "Summary Get All Post",
"description": "Description Get All Post",
"operationId": "getdata",
"x-ms-trigger":"gettdata",
"consumes": [
"application/json"
],
"produces": [
"application/json"
],
"parameters": [
{
"name":"status",
"type":"string",
"in":"query"
},
{
"name": "filter",
"in": "query",
"type": "string"
}
],
"responses": {
"200": {
"description": "Post retrieved.",
"schema": {
"$ref": "#/definitions/post"
}
}
}
}
}
},
"definitions": {
"post": {
"type": "object",
"properties": {
"id": {
"type": "integer"
},
"title": {
"type": "string"
},
"content": {
"type": "string"

}
}
}
}
}

[v-micsh-msft · Accepted solution]

Hi @dws,

I think CH1WPData0315.getalldata() should be the function defined under your Custom API, and you are trying to use it under the Gallery Items property?

The error message means the data get from the function is a record, not a table.

To workaround this, take a try to add a table function:

Table(
CH1WPData0315.getalldata({status:"publish"})
        )

Function reference:

Table function in PowerApps

Please take a try and see if it would help.

If any further help needed, please feel free to post back.

Regards