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

Community site session details

Session Id :
Power Platform Community / Forums / Power Pages / Error on Search
Power Pages
Unanswered

Error on Search

(0) ShareShare
ReportReport
Posted on by VV-28110858-0
I would like to integrate Dymanics 365 Business Central and Power Pages
I created several API Pages in Business Central and set them up as virtual tables in Power Apps
I created forms and views for these tables in Power Apps and add them to a Power Page site
The forms contain some lookup fields.
If the lookup view contains only one column, the build in search button works correctly,
but if it contains more than one column I get an error
POST 500 (The 'OR' operator is not supported on distinct fields on an OData filter.  CorrelationId:  e0c27e8d-ee6c-4c22-ad9c-97867caa1ec6.)
 
Do you know a way to avoid this error?
Many Thanks
Categories:
Design & build
pp-lookup.png
I have the same question (0)
  • Suggested answer
    SaiRT14 Profile Picture
    SaiRT14 1,990 Super User 2025 Season 2 on at
    Error on Search
    In virtual tables, lookup fields perform OData queries to fetch related records. When the lookup view includes multiple columns, the search query typically uses an OR operator to filter across those columns. Business Central’s OData implementation does not support the OR operator on distinct fields, leading to the POST 500 error.

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

News and Announcements

Welcome to the Power Platform Communities
Forum hierarchy changes are complete!
Season of Giving Solutions is Here!
Explore Copilot Studio Forums, Blogs & Galleries!

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Pages

#1
Jerry-IN Profile Picture

Jerry-IN 66

#2
Fubar Profile Picture

Fubar 47 Super User 2025 Season 2

#3
sannavajjala87 Profile Picture

sannavajjala87 31

Last 30 days Overall leaderboard

Featured topics

Solution to LinkedIn Authentication in Power Apps Portals
Welcome to the Power Pages forum!

Product updates

Microsoft Power Platform Community release plans