Showing results for 
Search instead for 
Did you mean: 
Helper II
Helper II

Cascading Drop-Downs and SharePoint integration

Hi all


I have a robust PowerApps form that allows associates at my company to request projects, then others to assign them to a variety of associates. It's a SharePoint-integrated PowerApp.


I need to expand usage to more teams. What I need to do is create a list of teams (Team 1, Team 2, etc), then a secondary cascading drop-down of Project Types that populate depending on what Team was selected in the previous drop-down.

In my "sandbox" area, I've done just that using instructions from a video from Shane Young and an excel table uploaded to SharePoint & brought in as a data source.

Code for the second drop-down looks like this:

Distinct(Filter(TestProjectTypes,Title=DropDownRole.SelectedText.Value),'Project Type')

Works great.


But now, I'm trying to figure out how to integrate this all into my actual App. Can I use the Excel file to drive the selections then collect the answer to drop it in a field in SharePoint? Do I need to have the Teams and Project Types as a Lookup List in SharePoint and is that possible do the drop-downs in the same manor? A third option I'm not thinking of? 


In all this, I need to retain the ability to change the Team and/or Project list name upon occasion and not have it change the historical values. That however, could be more of a SharePoint question than a PowerApps one...




Accepted Solutions

The solution I found was via this video - a different way of thinking about the whole thing that actually gives me some unexpected flexibility.

View solution in original post

Super User
Super User

In my opinion, I would scrap the Excel file and create a SharePoint List that associates the Projects to the Teams i.e. a list for projects that have the columns ProjectID, ProjectName, ProjectTeamID, etc...

Then have a teams list with a team Id and a Team name. (unless you're referring to actual Microsoft Teams, which you can integrate via Flow with a GetTeam sort of function)


In PowerApps, you can now associate the teams and the Projects in the same manor you have above, just using your Lists instead of the Excel file.



I created a list with Team & Project Type, added those two fields as lookups to my primary list, and created a test app directly from the SharePoint "new/edit" window. I added the Team dropdown, edited items with the code below, and it's not working:


I added .value at the end, no dice.

Original Code, which gives duplicates:


 Is there a way to combine Distinct and Choices? Some other methodology or syntax?



Community Support
Community Support

Hi @JillH ,


It seems that WhatIsYourRole column is LookUp type, please try this:


Best regards,


The solution I found was via this video - a different way of thinking about the whole thing that actually gives me some unexpected flexibility.

View solution in original post

Helpful resources

PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (3,371)