cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ExCessna
Level 8

Re: The property expects Table values, but this rule produces incompatible Boolean values

This might be what you need:

000-Request and Response Header on Swagger Event.png

 

Highlighted
ExCessna
Level 8

Re: The property expects Table values, but this rule produces incompatible Boolean values

Created a Swagger file for the WorldCat ISBN search and made a connection with it in PA. I have now tried with two different APIs and the corresponding files I created, both of which respond successfully in the Swagger Editor but result in PA errors that are similar, but different. This second file leads to an "Internal Server Error" in PowerApps (see below). Any ideas on how to fix this will be most appreciated!

 

[FYI- I have made connections in App Studio using these APIs with the Custom API connector in App Studio and they work well, but of course there is no way to pass a value (ISBN) to the query and now way to use the data once returned.] So I'd really like to get this working in PowerApps.

 

I realized after preparing the screen shots two ISBNs are shown in the screen prints below. This does not make a difference in the resulting error, however. One is a 10-digit ISBN, the other a 13-digit ISBN. Sorry about that.

 

Here is the second Swagger file used in PowerApps:

001-WorldCatISBNAa.pngSwagger Part A001-WorldCatISBNAb.pngSwagger Part B

The Swagger editor response is shown below:

001-WorldCatISBNAResponse1.pngSwagger Editor Response Part A001-WorldCatISBNAResponse2.pngSwagger Editor Response Part B001-WorldCatISBNAResponse3.pngSwagger Editor Response Part C

The PowerApps Error Message is shown below:

001-WorldCatISBNAPAError.png

ExCessna
Level 8

Re: The property expects Table values, but this rule produces incompatible Boolean values

...And the Fiddler Trace...

001-WorldCatISBNAFiddlerGet&Response.png

Power Apps Staff joem
Power Apps Staff

Re: The property expects Table values, but this rule produces incompatible Boolean values

Unfortunately, Swagger 2.0 does not allow query strings in paths.

See the following on reasons why this is the case: Proposal: Querystring in Path Specification

 

You can see this by the fact that the '?' char in your path is being escaped (per url escaping protocol). Also, there is likely a weird thing going on with connectors which is possibly masking the actual problem. But this is definately the cause of the problem. In all likelyhood, the connector is passing to your service a url which is further messed up.

 

You should fix your paths to be Swagger compliant.

I have filed a task on our plate to detect this scenario and to reject any Swaggers that contain the '?' char in the path string.

 

One thing that you'll hit though is that you'll have to actually specify the parameters with no values. This is unfortunate as you'll have to specify the parameters in the rules. But first thing is to be explicit. I'd recommend specifying the parameter as type:"string" for now and just specifying "json" in the function call to unblock you.

View solution in original post

DipenShha
Level: Powered On

Re: The property expects Table values, but this rule produces incompatible Boolean values

Hello Team,

 

I have created a custom connector which read the multiple items bases on business logic from sharepoint lists.

 

No i have call connector from the power app and it gives me error that "The property expects the table values but this rules produces in compatiable values."

But when i ran the connector from test page it will generate json records as below.

 

[{\"odata.type\":\"SP.Data.InvoiceapprovaltasksListItem\",\"odata.id\":\"4d5eb3aa-f285-48f6-90e0-32514b5177f6\",\"odata.etag\":\"\\\"3\\\"\",\"odata.editLink\":\"Web/Lists(guid'6d41d1bb-b5a0-42e6-a723-2b0ea2ccf7fe')/Items(334)\",\"TestInvoiceUniqueRefID@odata.navigationLinkUrl\":\"Web/Lists(guid'6d41d1bb-b5a0-42e6-a723-2b0ea2ccf7fe')/Items(334)/TestInvoiceUniqueRefID\",\"TestInvoiceUniqueRefID\":{\"odata.type\":\"SP.Data.InvoicetrackerListItem\",\"odata.id\":\"3b82e4a6-c9b2-4480-970e-6f7d6795cfed\",\"TestInvoiceUniqueID\":\"Invoice000326\",\"TestInvoiceNumber\":\"1\",\"TestTotalGrossValue\":500000.0,\"TestVendorName\":\"GHD PTY LTD\",\"TestGeneratedPrNo\":null,\"TestInvoiceDate\":\"2017-11-30T18:30:00Z\"},\"Id\":334,\"ID\":334}]""

 

How can i convert it in table format as power App read only table records and function also work on table records?

How can i generate table values from Custom API?

 

As i have observed that when we connect sharepoint as data soure it returns the table value from lists.

 

Can anyone help me out ?

 

Thanks

Dipen 

Meneghino
Level 10

Re: The property expects Table values, but this rule produces incompatible Boolean values

I think @jneyses has found a solution in this post.

He should be publishing more details in the next few days to that post.

Helpful resources

Announcements
New Ranks and Rank Icons in April

'New Ranks and Rank Icons in April

Read the announcement for more information!

Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (4,990)