Unanswered

BC connector, Logical operator 'Equal' is not allowed.

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

I'm trying to use the Business Central connector via power apps canvas but I get this error :

Logical operator 'Equal' is not allowed. To allow it, set the 'AllowedLogicalOperators' property on EnableQueryAttribute or QueryValidationSettings.

I get this issue when I'm trying to do a simple filter to get the line quotes of a Quote by using filter

I saw on some other posts that delegation methods are not allowed with bc connector. How can i replace filter method by something similar?

Many thanks for help

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Priyae Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,

You can try to create a collection in the OnStart event of the PowerApp, load the data in the collection and then filter the collection. More info on collections can be found here: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-clear-collect-clearcollect

Thanks

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @pre
I've already tried this but it should be too long to load all products. Suppose that my customer have around 3000 products, i'll have to create 2 separate collections and merge it to a new one to contain 3000 products.

In terms of performance i think it should take a time in the onStart event of the app.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Currently, the best approach I've found is to do an http request via power automate to get the product lines and give the response to the app. But I have a lot of flow. Around 6! Because I need to get item picture, taxes, stocks. I did a power automate to delete, modify or add a line item because of this constrain

Was this reply helpful? Yes No