cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
WimvanDelft
Level: Powered On

Cascading Dropdowns based on Lookup columns in a SharePoint Form

Hello,

 

Since recently it is possible to edit SharePoint forms with PowerApps. Seems to me that with these kind of forms it would be possible to create cascading dropdowns, however the methods explained in other posts (regarding apps) do not work. 

 

I have 2 lists: "Projects" and "Time Registration". When adding an item to "Time Registration" you select a project and then the dropdown of subprojects should be filtered based on the selected project.

 

Does anyone know how to create cascading dropdowns?

1 ACCEPTED SOLUTION

Accepted Solutions
Meneghino
Level 10

Re: Cascading Dropdowns based on Lookup columns in a SharePoint Form

Assume that you have a TableProj with a column Project and a TableSubs with two columns, Project and Subproject.

Then the Items property of the first dropdown (DropDown1) should simply be:

TableProj

Then the Items property of the second dropdown should be:

Filter(TableSubs, Project=DropDown1.Selected.Project)

That is the basic mechanism.

View solution in original post

8 REPLIES 8
Meneghino
Level 10

Re: Cascading Dropdowns based on Lookup columns in a SharePoint Form

Assume that you have a TableProj with a column Project and a TableSubs with two columns, Project and Subproject.

Then the Items property of the first dropdown (DropDown1) should simply be:

TableProj

Then the Items property of the second dropdown should be:

Filter(TableSubs, Project=DropDown1.Selected.Project)

That is the basic mechanism.

View solution in original post

WimvanDelft
Level: Powered On

Re: Cascading Dropdowns based on Lookup columns in a SharePoint Form

Thanks for sending me in the right direction!

Project is a lookup value in the project, so i changed your solution a bit:

 

Filter(TableSubs; Project.Id=Dropdown1.Selected.ID)

 

 

Meneghino
Level 10

Re: Cascading Dropdowns based on Lookup columns in a SharePoint Form

Perfect, well done.

Check out my blog for more PowerApps and related info:

https://baizini-it.com/blog/

WimvanDelft
Level: Powered On

Re: Cascading Dropdowns based on Lookup columns in a SharePoint Form

Now I got the from working with cascading dropdowns, however the values don't end up in my SharePoint list (this is a third list "Registration") So on the newitems form in registration list one enters his hours and selects project and subproject. Any idea what I'm missing here?

Meneghino
Level 10

Re: Cascading Dropdowns based on Lookup columns in a SharePoint Form

Apologies, but I don't use forms.  There should be a setting/property in the form as to what SharePoint fileds the drop downs are connected to.

Otherwise just create your own forms.

pohlipit
Level: Power Up

Re: Cascading Dropdowns based on Lookup columns in a SharePoint Form

I have the same issu. Cascading drop-downs work fine based on the values in the lookup list. However on saving the form the values aren't populated into the respective columns of the list that is being edited.

Meneghino
Level 10

Re: Cascading Dropdowns based on Lookup columns in a SharePoint Form

If you are using SharePoint, I think this is what you may be looking for:

https://powerusers.microsoft.com/t5/General-Discussion/Solved-patching-to-SharePoint-choice-and-look...

hysquare
Level: Power Up

Re: Cascading Dropdowns based on Lookup columns in a SharePoint Form

Please where is the correct answer to this.

 

I am having similar challenge.

 

I have three list

 

Divisions - Title

Groups - Title (Text), Division (Lookup column)

Units - Title (Text), Group (Look column)

 

I have not been able to implement the cascading dropdown, please assist

 

Helpful resources

Announcements
Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Join THE global Microsoft Power Platform event series

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Microsoft Business Applications Virtual Launch

Join us for the Microsoft Business Applications Virtual Launch Event on Thursday, April 2, 2020, at 8:00 AM PST.

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (9,659)