web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Change Business Centra...
Power Apps
Unanswered

Change Business Central Query Property for PowerApps

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hi,
I am building an app using PowerApps which is connected to my Business Central (on cloud). However, when I want to do some simple query in the app, I get an error message saying that I need to change the 'AllowedLogicalOperators' from the EnableQueryAttribute or QueryValidationSettings. I am having trouble finding where can I change the setting.

 

2019-10-08_16-01-48.png

 

Categories:
I have the same question (0)
  • mdevaney Profile Picture
    29,991 Moderator on at

    @Anonymous 

    I would like to share a previous post about this issue with you.  The Business Central connector does not support the Filter function.  The workaround is to load the data into a Collection using the OnStart property of the app and then Filter the collection instead.

     

    Relevant Post:

    https://powerusers.microsoft.com/t5/Building-PowerApps-Formerly/Error-on-filtering-Business-Central-s-data-in-PowerApps/td-p/211364

     

    ---
    Please click "Accept as Solution" if my response helped to solve your issue so that others may find it more quickly. If your thought the post was helpful please give it a "Thumbs Up."

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Valantis Profile Picture

Valantis 404

#2
timl Profile Picture

timl 344 Super User 2026 Season 1

#3
WarrenBelz Profile Picture

WarrenBelz 320 Most Valuable Professional

Last 30 days Overall leaderboard