cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Concrete
Helper I
Helper I

Dropdown connection to another sharepoint list

Hi,

 

I've created a powerapp from a sharepoint list A with these columns: Code (dropdown, 6 digit numbers), Factory (dropdown with two options A and B) and Date (today's date).

 

After some time I've created another sharepoint list B, where I have two columns: Code (6 digit number), Factory (dropdown with two options A and B).

 

My question, is it possible that Code field dropdown in the powerapp would show results from sharepoint B based on selection in Factory field?

 

Thanks in advance.

1 REPLY 1
JR-BejeweledOne
Super User
Super User

Yes, you can do that.  Your items property on Code dropdown would be something like this,  you might have to play with it some:

 

Filter(DataSourceB, Factory = FactoryDropdown.Selected.Value)



If you like this post, give it a Thumbs up. If it answered your question, Mark it as a Solution to enable other users find it.

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

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 (1,009)