PowerApps Cascading Dropdown - See comments for 2021 version
Why SharePoint Stack Exchange recommends it
SharePoint Stack Exchange answerers point people to it when they need cascading or dependent dropdowns in a PowerApps form on top of SharePoint lists.
Recommended by 1 people across 1 different months, 2020 to 2021.
What it is
A 2018 PowerApps tutorial by Shane Young that shows how to build cascading dropdown menus, where the choices in one dropdown depend on the selection in another. It walks through the If, Reset, Sort, Distinct and Disabled functions. The description notes a newer 2021 version exists.
What people said
Strong rec AIMEN BOULAHIA · 2020-01 · SharePoint Stack Exchange · on “Using Power Apps to hide and show fields inside Create and Edit forms”
I just have the perfect solution for you, it's called "Cascading Dropdown" ! Please refer to Mr Shane Young which i find him very professional guy, and here the link: PowerApps Cascading Dropdown [this video] , here you will find exactly what you want and more ! Good luck.
Recommends AIMEN BOULAHIA · 2020-01 · SharePoint Stack Exchange · on “Show/Hide field in SharePoint O365 based on cascadeing dropdown value selection”
I don't know how to achieve that using JS scripts, but I would like to share with you how to do it with PowerApps (which is really cool and even non-developers can achieve that) Please refer to Mr Shane Young which i find him very professional guy, and here the link: PowerApps Cascading Dropdown [this video] , here you will find exactly what you want and more ! Good luck.
Cites asdofjkasdcoij · 2020-09 · SharePoint Stack Exchange · on “How can I specify other columns of a selected SharePoint list row in PowerApp?”
I'm making a Power App form that pulls options from a SharePoint list. The list has three columns: Category Subcategory Abbreviation Users select a category and subcategory using a cascading dropdown [this video] . Each category may have multiple subcategories and each subcategory has a unique abbreviation. Now I want to make a label that says: "You have selected [abbreviation]." In order to test something simpler, I tried setting the Text value of the label to: "You have selected" & SubcategoryDropdown.SelectedText & "." This returns "Invalid argument type. Expecting one of the following: Text, Number, Boolean, OptionSetValue, ViewValue." How is Selected Text not "Text"?! I also tried this: "You
Cites kernel52 · 2021-04 · SharePoint Stack Exchange · on “Filtering lookup values based on another column powerapps”
I have found various solutions to this, [this video] [LINK] Filtering lookup values based on another column in another list, sharepoint online and powerapps [LINK] [LINK] [LINK] now, my only problem is that the form is not saving after the changes. will get there.