Casading dropdown with 2 SharePoint Lists

[Anonymous]

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.

Here is the Outcomes SharePoint List:

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:

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

Help!!!

[v-xida-msft · Accepted solution]

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:

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

[Anonymous]

@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]

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

[v-xida-msft]

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