cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
GNSGnanasekar
Level: Powered On

To show one lakh city names in PowerApps drop-down

Hi All,

 

I need to show country, state, city names in PowerApps drop-downs. But It is nearly one lakh records (Rows). 

Please help me to fix below issues.

1. Where to store this one lakh records (Datasource)?

2. How to connect with PowerApps this records. (Which connection help for it)

 

As of now, country/state/city names are in JSON file format (26MB), CSV file format(7MB).

Note : City names will be sort out based on Country and state Selection.

 

By

Gnanasekar

 

1 REPLY 1
shailendra74
Level 8

Re: To show one lakh city names in PowerApps drop-down

You can consider using Azure SQL DB to store the information.  Based on the selection, you need to filter the selection.  However, it is not good idea to get all data and populate in the dropdown/combo.

 

You can use SQL connector to connect to sql db

 

Thanks.

 

 

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

SecondImage

Power Platform Summit North America

Register by September 5 to save $200

Users Online
Currently online: 47 members 4,968 guests
Please welcome our newest community members: