Skip to main content

Notifications

Power Pages - Design & Build
Suggested answer

Error on Search

(0) ShareShare
ReportReport
Posted on by
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:
  • Suggested answer
    SaiRT14 Profile Picture
    SaiRT14 1,474 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

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #9 Get Recognized…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,867

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 64,174

Leaderboard

Featured topics