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

Unable to show data in power apps getting error

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

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Unable to show data in power apps getting error

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

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.

View solution in original post

2 REPLIES 2
dws
Level: Powered On

Re: Unable to show data in power apps getting error

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"

}
}
}
}
}skin.jpg

Community Support Team
Community Support Team

Re: Unable to show data in power apps getting error

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

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.

View solution in original post

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: 177 members 4,660 guests
Please welcome our newest community members: