web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Cascading dropdowns wh...
Power Apps
Unanswered

Cascading dropdowns when values under column A (List A) serve as headers in List B having values under

(0) ShareShare
ReportReport
Posted on by

Hello, I am building a Canvas app where 2 columns are linked to each other.

Both columns are part of 2 separate share point lists. In List A, values under Column P are present and in List B – values in Column P are headers having drop down values.

One column e.g. Column P contains drop downs and on basis of value in column P dependent column Q should reflect it’s dropdown values.

E.g. Column P contains ‘Engagement – Fun Events’ and respective values under ‘Engagement – Fun Events’ (in List B) should be available under drop downs.

 

AJ_vizMan_0-1638511822559.png

 

 

 

  Engagement - Fun Events  (List B)

Anniversary Celebration (Long Association Award)

Anniversary Celebration (of Process/ Account/ Program)

Birthday Celebration

Festive Celebration

Other Celebrations

Other Process/ Account/ Program Level Celebrations

Other Site/ Location/ Country Level Celebrations

Reward & Recognition

Weekly Fun Activity

 

The same is possible in Microsoft Excel using below formula à

OFFSET(Sheet1!$Z$1,1,MATCH(P2,Sheet1!$Z$1:$BB$1,0)-1,COUNTA(OFFSET(Sheet1!$Z$1,1,MATCH(P2,Sheet1!$Z$1:$BB$1,0)-1,50,1)),1)

 

One option to achieve above using cascading functionality but, then I need to transform column Q data  (have 40+ columns) and it will be hard to maintain in share Point List.

Appreciate your help to achieve the above functionality in PowerApps.

 

 

Categories:
  • Gerard Simpson Profile Picture
    2,987 Moderator on at

    Hi @AJ_vizMan 

     

    I am not aware of any way in which you can dynamically select the correct column to populate your drop down without writing a long expression to cover all the possibilities.

     

    If it were me, I would use cascading functionality with one column for all the potential primary selections and a column for all secondary selections - but rather than do a distinct on your primary column for your primary choices, keep your Column P in a separate list and use that for your first selection choices, also to ensure no chance of delegation issues from using distinct on the primary column of your larger list.

     

    Then just use a lookup in your cascading filter formula to link the primary value in the two lists and grab the correct secondary subset of items relating to your chosen primary value.

     

    Doing it this way would also avoid bringing in empty fields to the secondary choices as would be the case in your current arrangement if you have different nrs of values in each column (i.e. the column with the most values dictates the nr of rows in your list)

     

    With regards transforming the data, this could be easily achieved in Shaorepoint grid view using copy/paste - In terms of list maintenance, it would actually be easier to maintain a tall narrow list with just two fields to complete via a simple admin page in your app with gallery and form to allow mods to your choices. Having multiple columns would be difficult to maintain as you dont just add to the column, you add the value to a row, which might not be the last row in your list and which has loads of other fields you need to sift through.

     

    I hope my understanding of your query is correct and this is of some assistance. - Good Luck!

     

  • AJ_vizMan Profile Picture
    on at

    Sure @AmDev - have achieved above functionality using cascading. Thanks

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 243 Super User 2026 Season 2

#2
WarrenBelz Profile Picture

WarrenBelz 204 Most Valuable Professional

#3
Mohsin Ali Profile Picture

Mohsin Ali 122

Last 30 days Overall leaderboard