
Hi,
I have a combobox dropdown linked to Office365Users. I am using the SearchUser function to filter items in the dropdown. I am also wanting to firstly filter by CompanyName = "X" and AccountEnabled=true. So if no search text is entered, the dropdown only includes names from a specific company (rather than the global organization) and accounts that are enabled. Is this possible? If this is not possible, I am happy just to utilize the searchUser function below which is working fine.
Current formula -
Office365Users.SearchUser({searchTerm:DBF1_DTname.SearchText}).DisplayName
Thanks!
Hi @cathrose ,
Please try the below as your Items property for your combo box
Filter(Office365Users.SearchUser(),
AccountEnabled,
CompanyName = "X"
)