web

You’re offline. This is a read only version of the page.

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

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

SaiRT14 1,988 Super User 2025 Season 2 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.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Coming soon: forum hierarchy changes

Explore Copilot Studio Forums, Blogs & Galleries!

Quick Links

Leaderboard > Power Pages

#1

#2

Michael E. Gernaey 39 Super User 2025 Season 2

#3

Fubar 35 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans