I have a CDS Entity "Agency," of which the "State" field is a Lookup Field from an Entity "State." The "Agency" Entity populates a gallery which is then filtered in my app by a drop down list populated from the "State" Entity, like so:
Filter('Agency',State.Name = DropDown.SelectedText.Name)
I have created a blank record in that "State" Entity. My trouble is that when I set the default value of the drop down list to a null value, or "", or "-" or -, the filter fails to populate the gallery at all.
Is there a value I can use in the drop down list which will nullify my gallery filter, and allow the gallery to be populated by all its records?
Solved! Go to Solution.
Check out these cool Power Apps & vote on your favorite!
Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)
Check out whats happening in Power Apps
FIll out a quick form to claim your community user group member badge today!