Showing results for 
Search instead for 
Did you mean: 
Not applicable

Cascading Dropdowns within a PowerApps EDIT form using SharePoint Lists and Lookups

I have 3 SharePoint Lists:

Outcomes - Contains just the Title Field

Courses -  Contains Course Name field and a lookup field that accepts multiple values (Outcomes, Title Field)

Assessment Form


My Assessment form contains an Outcome look up field and a Courses Lookup field. When you select an Outcome from the dropdown in InfoPath, any course that contains that Outcome is available for selection in the Course field (Outcomes can have many courses):




For my PowerApp EDIT form, I'm not sure what formula to use to replicate the cascading done in InfoPath. Help!! 🙂 



Memorable Member
Memorable Member



This is fairly straightforward to accomplish. This is off the top of my head, but its something to the degree of:


  1. Delete the dropdown in the original data card
  2. Add a new one
  3. Set its default value to something like:
            otherTableColumn = firstTable.Selected.Value),

You can also hack it with:

            otherTableColumn = firstTable.Selected.Value).otherTableColumn

Play around and let us know what you settle on!


Memorable Member
Memorable Member

And of course, when all else fails...ask Shane Young (!

Community Support
Community Support

Hi @Anonymous,

I found that you have post same thread within the forum, please check the following thread:

Please check and see my response to your issue within above thread, then check if the issue is solved.

Within your Edit form, set the Items property of the first Dropdown (OutcomeChoice) to following:

Outcomes.Title    /* Outcomes represents your Outcomes SP list*/

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

    CoursesList,    /* <-- The CoursesList represents the Courses SP list */
        Value: Dropdown1.Selected.Value   /* <-- The Dropdown1 represents the first Dropdown (OutcomeChoice) */
    in Outcome.Value

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,


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.

This doesn't appear to work for me because then I lose my dropdown list for some reason

New Member

Try this,


CountIf(DataCardValue.SelectedItems,Value="Selection Required")>0

Helpful resources

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Top Solution Authors
Top Kudoed Authors
Users online (1,565)