Filter lookup on related rows not working when rendering lookup as a dropdown

(0) Share

Report

Posted on by AH-11112340-0

I have a lookup on an edit webform step that I need to filter based on a lookup populated in the previous step. I need the filtering to occur server-side so I cannot use JavaScript to dynamically filter the lookup.

The issue is I have set up the field to filter based on the related rows in power apps as bellow and the filtering works when the lookup is rendered as a lookup but if I apply the "Render lookup as dropdown" metadata it no longer filters the lookup. Why does it behave this way? The lookup should be filtered on the server so the options should only show those that are related. I don't see why changing the rendering changes the actual options that can be select. Seems like a bug to me.

It isn't anything more than a UX issues at the moment but would like a suggestion or help identifying if this is a bug.

Categories:

Power Apps portals

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Fubar 8,487 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Unfortunately this is a known limitation (and has been like this for quite a few years ).

The workaround is to either use the standard Lookup dialog or Use the Portals Web API to query the data (or old style ajax call another Web Page that uses a Web Template containing fetchxml to return JSON) on change of the other Lookup, and then process the results to populate the 2nd lookup values (in the 2nd lookup set its initial view to one that will never return values so it doesn't initially populate e.g. status reason does not contain data).

Was this reply helpful? Yes No