News and Announcements icon

Power Platform CommunityForums Power Pages - Design & Build Error on Search

Power Pages - Design & Build

Suggested answer

Error on Search

(0) Share

Report

Report

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:

pp-lookup.png

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

SaiRT14 1,474 on at

Like (0)

Report

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.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Give Back to the Community this Month

Announcing Category Subscriptions!

Quick Links

Leaderboard

#1

WarrenBelz 143,867

#2

RandyHayes 76,308

#3

Pstork1 64,174

Leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans