Hi Everyone,
I have my Microsoft Entra identity table with all users from my organization. I created a view on that table with a filter and wanted to use it in my power app. I have my view filtered based on the extension on every user full name. For example, Sam Adama-IT. I applied filter to find all the IT employees, I applied it it contains "-IT". It's working fine no issues with it. I named the view as MyDept. Reason I wanted to use this view is I do not want other dept user name appear in the dropdown from Microsoft entra identity.
I selected the Entra identity table and chose the view and its not letting me use on the combox I had from a table that is a lookupcolumn with the entra identity.
Also, tried to add a custom combox and not allowing me to select the view.
Can anyone please help me with the best way to handle this kind of requirements.
Thank you so much in advance!
