Dependent dropdowns in Powerapps Form

[SectorOMEGA]

I know there tons of materials about cascading dropdowns but honestly I cant make it work. So I have two SP columns that are Choices(DropDown menus) one is Building and the other is Floor. User are filling simple form for visits with this content. However I havent been able to limit Floors based on the selection of the building. SP columns listed in the Form are with Choices([@SP List].Column Name). Any good reading about how to do it without separate excell sheet with two columns 🙂

[VijayTailor]

Hi @SectorOMEGA ,

You can use the Direct Filter query based on Selected ComboBox.
See the Code Below for reference - 

RenameColumns(ShowColumns(Filter('Mapping',TeamName.Value=Concat(DataCardValue44.SelectedItems,Value),ProductStatus.Value="Active"),"ID","Title"),"ID","Id","Title","Value")