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.

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.