cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

Using one Sharepoint list to populate dropdown on another

Hi

 

We have a sharepoint list which contains a list of offices such as:

 

OFFICE| COUNTRY| CITY

Office1 | France | Paris (note there can be multiple offices in one city)

Office2 | France | Paris

Office3 | France | Toulon

Office4 | US | New York

Office5 | US | Miami

 

We'd now like to have a second sharepoint list which contains:

CITY | SOMEDATA

 

But when they create a new item in this list, we'd like users to be able to select their city from a dropdown which is populated from the entries in the first list (after having removed the duplicates there) - eg.  Paris, Toulon, New York, Miami

 

Please can someone please point me in the right direction? I'm not set on technology, so it could be PowerApps, Flow or a combination if needed.

 

Many thanks

 

 

Helpful resources

Announcements
Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (7,125)