cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ethathaw Frequent Visitor
Frequent Visitor

Replace multiple Text inputs to Lat/Long for each

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!

2 REPLIES 2
Community Support Team
Community Support Team

Re: Replace multiple Text inputs to Lat/Long for each

hi, @ethathaw 

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

 

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
ethathaw Frequent Visitor
Frequent Visitor

Re: Replace multiple Text inputs to Lat/Long for each

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.