![\"\"](\"http:\/\/4us2use.at\/wp-content\/uploads\/2019\/10\/casc_lists-1.png\")
<\/figure>\n\n\n\n- In the mapping lists make the Title not required, add 2 lookup columns that are required and 2 additional columns for the text value<\/li><\/ul>\n\n\n\n
![\"\"](\"http:\/\/4us2use.at\/wp-content\/uploads\/2019\/10\/casc_maplist.png\")
<\/figure>\n\n\n\n- Create a simple Flow for each of the two mapping lists, that updates the text columns, that we’ll use later for our dropdown values<\/li><\/ul>\n\n\n\n
![\"\"](\"http:\/\/4us2use.at\/wp-content\/uploads\/2019\/10\/casc_flow.png\")
<\/figure>\n\n\n\n- Then create a target list (also text only fields for these three “dropdown” columns!) Of course all other columns can be treated as standard.<\/li><\/ul>\n\n\n\n
![\"\"](\"http:\/\/4us2use.at\/wp-content\/uploads\/2019\/10\/casc_maincol.png\")
<\/figure>\n\n\n\n- In the main list click on “Customize Form” under PowerApps menu<\/li>
- Unlock the 3 Data Cards under “Advanced”, replace the text input controls with dropdown controls and rename them to something meaningful like
“ddScope”, “ddCategory” and “ddSubCategory” <\/li> - set the “UPDATE” property of the data cards to the name of the SP field to be updated with the value <\/li><\/ul>\n\n\n\n
- Now modify the “Items” property of the new dropdown fields. <\/li>
- <\/li><\/ul>\n\n\n\n
ddScope:
Distinct(cascMap_ScopeCat, LUScopeText) <\/em>
ddCategory:
Filter(cascMap_ScopeCat, LUScopeText = ddScope.Selected.Result)<\/em>
ddSubCategory:
Filter(cascMap_CatSub, LUCategoryText = ddCategory.SelectedText.Value)<\/em> <\/p>\n\n\n\n(if you want to sort the values, you can put a SortByColumns() function around the filter formula)<\/p>\n\n\n\n
- Now the lookups are already working, but if you click on Save, the values are not written to SharePoint. To fix this, we have to re-add the original columns to the form. When added again, unlock them under Advanced and set the “Default” property to the value of the dropdowns. <\/li><\/ul>\n\n\n\n
Scope:
ddScope.Selected.Result<\/em>
Category:
ddCategory.SelectedText.Value<\/em>
SubCategory:
ddSubCategory.SelectedText.Value<\/em> <\/p>\n\n\n\n- Last but not least, hide those fields from the form by setting the “Visible” property to false<\/li><\/ul>\n\n\n\n
- Save, publish and enjoy \ud83d\ude09<\/li><\/ul>\n\n\n\n
![\"1](\"http:\/\/4us2use.at\/wp-content\/plugins\/wp-postratings\/images\/stars\/rating_off.gif\" "\\"1")
(No Ratings Yet)
<\/span><\/span>![](\"http:\/\/4us2use.at\/wp-content\/plugins\/wp-postratings\/images\/loading.gif\")
Loading...<\/span>
<\/p>\n\n\n\n
<\/p>\n","protected":false},"excerpt":{"rendered":"My Scenario: I had the requirement to have a list input form in SharePoint online, that contains “Scope”, “Category” and a “Subcategory”. Of course – to have it end user friendly – these dropdowns had to be cascading. First of all: as of today, cascading dropdowns in PowerApps only works smooth with TEXT only values!! … <\/p>\n
- Save, publish and enjoy \ud83d\ude09<\/li><\/ul>\n\n\n\n
- Last but not least, hide those fields from the form by setting the “Visible” property to false<\/li><\/ul>\n\n\n\n
- Now the lookups are already working, but if you click on Save, the values are not written to SharePoint. To fix this, we have to re-add the original columns to the form. When added again, unlock them under Advanced and set the “Default” property to the value of the dropdowns. <\/li><\/ul>\n\n\n\n
- Then create a target list (also text only fields for these three “dropdown” columns!) Of course all other columns can be treated as standard.<\/li><\/ul>\n\n\n\n
- Create a simple Flow for each of the two mapping lists, that updates the text columns, that we’ll use later for our dropdown values<\/li><\/ul>\n\n\n\n