Create Cascading DropDown in SharePoint Online using PowerApps
Why SharePoint Stack Exchange recommends it
SharePoint Stack Exchange answerers point people to it when someone needs one dropdown to filter another in a modern list form without custom code.
Recommended by 2 people across 3 different months, 2020 to 2021.
What it is
A short tutorial from the Lernen Tech channel showing how to build a cascading dropdown in a SharePoint Online list form using PowerApps. It uses a separate source list for the parent and child values, and notes the same list could be used instead.
What people said
Recommends Jerry_MSFT · 2020-06 · SharePoint Stack Exchange · on “Category and Subcategory formula in Sharepoint list and no coding”
What you are talking about seems to be the cascading drop-down list. If you do not want to handle any code or scripts, it will not be a quite perfect one. Some workarounds are listed here [LINK] . If having access, using InfoPath [LINK] or PowerApps [this video] is also an option for you:
Recommends theChrisKent · 2021-03 · SharePoint Stack Exchange · on “Connecting Sharepoint lists via lookup/utilizing the lookup item in Sharepoint Online”
What you are looking for is a Cascading dropdown (where one dropdown filters the values of another). This is not supported using the out of the box customizations within the modern list form. You'll need to customize the list form with Power Apps. Here's a video that demonstrates how to do this: [this video]
Recommends Jerry_MSFT · 2021-04 · SharePoint Stack Exchange · on “Presave function”
What you are looking for seems to be a cascading dropdown list. You can refer to the below blogs for more help. For SharePoint On-Prem or SharePoint Online classic experience: [LINK] Multilevel Cascading Dropdowns for SharePoint 2013, 2016, and O365 Classic forms [LINK] For SharePoint Online modern experience, it may be better to use PowerApps [this video] .
Recommends Jerry_MSFT · 2021-04 · SharePoint Stack Exchange · on “Filtering lookup values based on another column powerapps”
For PowerApps, you can refer to this tutorial [this video] which may be an easy option for you. You will need to first set up a source list for the relationship between Document Category and Document type(just like the region and country in the video). And then in the actual list, single text column will be enough.
Cites kernel52 · 2021-04 · SharePoint Stack Exchange · on “Filtering lookup values based on another column powerapps”
I have found various solutions to this, [LINK] [LINK] Filtering lookup values based on another column in another list, sharepoint online and powerapps [LINK] [LINK] [this video] now, my only problem is that the form is not saving after the changes. will get there.