cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Casading dropdown with 2 SharePoint Lists

I am creating a power app that has two dropdowns. The top dropdown contains a list of Outcomes. The second dropdown should contain all courses that have that same outcome.


Dropdowns_PA.jpg

Here is the Outcomes SharePoint List:

 

Outcomes.jpg

 

Here is the Courses SharePoint List; it contains an Outcome column that is a lookup to the Outcome SP List; each course can have multiple outcomes:

 

Courses.jpg

 

For example, when the first dropdown of outcomes is selected, the second dropdown should populate all courses that contain that particular outcome.

 

Help!!!

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Casading dropdown with 2 SharePoint Lists

Hi @Anonymous,

Is the Outcome column in your Courses list a LookUp column which enables multiple selections?

I have made a test on my side, please take a try with the following workaround:8.JPG

 

9.JPG

Set the Items property of the first Dropdown (Dropdown1) to following (Value property set to Title):

'20181019_case9_OutComes'   /* <-- On your side, it is Outcomes list */

Set the Items property of the second Dropdown (Dropdown2) to following formula:

Filter(
    '20181019_case9_Courses',
    {
        Value:Dropdown1.Selected.Value
    } 
    in Outcome.Value
).Title

On your side, you should type the following:

Filter(
    'YourCoursesList',
    {
        Value: Dropdown1.Selected.Value
    } 
    in Outcome.Value
).Course_x0020_Name

Note: The Course_x0020_Name represents the Course Name column in your Courses list.

Above formula I provided may cause a Delegation warning issue, in order to get rid of this issue, please take a try with the following workaround:

Set the OnVisible property of the first screen of your app to following:

ClearCollect(CoursesCollection,'YourCoursesList')

Set the Items property of the second Drop down control (Dropdown2) to follownig:

Filter(
    CoursesCollection,
    {
        Value: Dropdown1.Selected.Value
    } 
    in Outcome.Value
).Course_x0020_Name

Best regards,

Kris

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
Community Support Team
Community Support Team

Re: Casading dropdown with 2 SharePoint Lists

Hi @Anonymous,

Is the Outcome column in your Courses list a LookUp column which enables multiple selections?

I have made a test on my side, please take a try with the following workaround:8.JPG

 

9.JPG

Set the Items property of the first Dropdown (Dropdown1) to following (Value property set to Title):

'20181019_case9_OutComes'   /* <-- On your side, it is Outcomes list */

Set the Items property of the second Dropdown (Dropdown2) to following formula:

Filter(
    '20181019_case9_Courses',
    {
        Value:Dropdown1.Selected.Value
    } 
    in Outcome.Value
).Title

On your side, you should type the following:

Filter(
    'YourCoursesList',
    {
        Value: Dropdown1.Selected.Value
    } 
    in Outcome.Value
).Course_x0020_Name

Note: The Course_x0020_Name represents the Course Name column in your Courses list.

Above formula I provided may cause a Delegation warning issue, in order to get rid of this issue, please take a try with the following workaround:

Set the OnVisible property of the first screen of your app to following:

ClearCollect(CoursesCollection,'YourCoursesList')

Set the Items property of the second Drop down control (Dropdown2) to follownig:

Filter(
    CoursesCollection,
    {
        Value: Dropdown1.Selected.Value
    } 
    in Outcome.Value
).Course_x0020_Name

Best regards,

Kris

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Anonymous
Not applicable

Re: Casading dropdown with 2 SharePoint Lists

@v-xida-msft Thank you! So far so Good! 

 

These dropdowns were added to my App not being placed within a Form control. If I want to create a form with these two dropdowns in it, what would the correct filter formula for the Course dropdown?

 

 

Anonymous
Not applicable

Re: Casading dropdown with 2 SharePoint Lists

OR, how would it be possible to Patch the dropdowns without having them in a form? Whatever is easier @v-xida-msft !

Community Support Team
Community Support Team

Re: Casading dropdown with 2 SharePoint Lists

Hi @Anonymous.

Which SP list does your Edit form connect to? The Outcomes list or the Courses list?

If you want to achieve same functionality within the Edit form, you must firstly add the two SP lists (Outcomes list and Courses list) as data sources within your app.

In addition, I think the solution I provided above could also achieve your needs within the Edit form. I assume that your first Dropdown connects to Outcomes list, and display the Title column value within the it. On your side, you should set the Items property of the second Dropdown control to following:

Filter(
    'YourCoursesList',
    {
        Value: Dropdown1.Selected.Value   /* The Dropdown1 represens the first Dropdown within your Edit form */
    } 
    in Outcome.Value
).Course_x0020_Name

If you have solved your problem, please go ahead and click “Accept as Solution” so that this thread will be marked for other users to easily identify.

 

Best regards,

Kris

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

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

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 206 members 5,051 guests
Please welcome our newest community members: