I have multiple Combo Boxes. Each Combo Box has the table, “AB_Company”, as its Datasource. The first Combo Box has the distinct names for the companies in the drop down for the Combo Box with “Company” as the datatables sourced column. The formula in items property for the first combo box reads as follows: Distinct(Filter(AB_Companies.Company,Company),Company).
AB_Company has one column, “Approver”, with LookUp, the “User” Data table, as its datatype. I want the second Combo Box to filter and only display names from the Approver column. I’ve tried several methods. “Filter([@Users].'Full Name', Value in Filter(AB_Companies, Company = Dropdown3.SelectedText.Value).Approver)” doesn’t work (There’s an error in Value). I’ve tried Distinct(Filter(AB_Companies, Company=ComboBox1.Selected.Result), Approver), but the filtered results in the ComboBox are all blank. I also would ideally like to not use Sharepoints or galleries and just rely on the Dataverse tables.
These are what the AB_Company and User Datatables and their relevant columns look like.
Solved! Go to Solution.
@v-xiaochen-msft . Thank-you! This delivered my necessary/expected results. My only issue is that it's also returning the blank and/or empty values from the rows in the field. This can (likely) be resolved once I input the data. You wouldn't happen to know of any methods for removing blank/empty values from the drop downs, would you?
Your chance to join an engaging competition of Power Platform enthusiasts.
The Super User program for 2022 - Season 2 has kicked off!
Attend in person or online, there are incredible conferences and events happening all throughout the month of September.
In response to the unique and evolving requirements of the United States public sector, Microsoft has created Power Apps US Government.