Replace multiple Text inputs to Lat/Long for each

[Anonymous]

When people are selecting a location (which is text), I want this selected text to translate to a given Lat/Long for that location. There are around 90 locations, each with an indivudal lat/long.

Location      Lat          Long

1A1            13.456     16.765

2C4            13.765     18.435

3B5            17.463     16.453

Etc.

So the input being received in the Location and each has a fixed Lat/Long, so how do i automatically convert that Location into the coordinates in the Lat/Long columns? 

Thanks!

[v-lili6-msft]

hi, @Anonymous 

Since you have the Location and Lat/Long table, when you select a Location, the corresponding Lat/Long will appear automatically.

What is your expected output?

Best Regards,

Lin

[Anonymous]

Hi Lin,

I don't think I explained it properly.  I've created a form in PowerApps with a Location choice drop down menu, taken from a list in SharePoint.  I want the associated lat/long for that location to be input automatically into two separate columns within Power BI. Am I able to directly link the lat/long with the associated location somehow? I can create separate tables for each if needed.