Multi-Table Lookup, Form control only displaying one of the tables.

(1) Share

Report

Posted on by ML-19052248-0

Hi All,

We've tried implementing a multi-table lookup using the API/instructions in the Learn article here for our model-driven app:

Use multi-table lookup columns - Power Apps | Microsoft Learn

We've implemented one of them with no problems however the second one seems has an issue with a particular combination of tables. The lookup and relationships are created just fine with the API and mostly work as expected however when we place a the multi-table lookup field on a form, it only allows the user to select rows from one of the tables that the lookup references.

We have a support ticket underway and have undertaken a bunch of troubleshooting steps but so far have been far less than helpful.

I was just wondering if anyone else has experienced this or if there are any known constraints on multi-table lookups that might help explain our situation.

Categories:

Entities

Tables

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

SaiRT14 1,988 Super User 2025 Season 2 on at

Like (0)

Report

Multi-Table Lookup, Form control only displaying one of the tables.

It sounds like you're encountering an issue where the multi-table lookup field is not allowing selections from all intended tables on the form, which can be a frustrating limitation.

only work around - try creating a separate single-table lookup field for each table as a temporary workaround. Although this is not ideal for long-term use, it may help identify whether specific tables or table relationships are causing the problem.

Was this reply helpful? Yes No