Forum Discussion
EricDeferm
Feb 21, 2019Steel Contributor
GeoLocations - Upload values to existing/new List
What are the possible options to upload geo coordinates into a GeoLocation field of a list. Can the values be uploaded from Excel? Can we convert & assign single text values to a GeoLocation column...
- Feb 24, 2019
Hi EricDeferm
unfortunately Geolocation fields are unsupported for user in MS Flow, you could use this template, but it's not supported :( I tried.
MS PowerApps too doesn't support GeoLocation fields..
You can create text column and populate your geolocation field with a Remote Event receiver https://docs.microsoft.com/en-us/sharepoint/dev/sp-add-ins/create-a-remote-event-receiver-in-sharepoint-add-ins or an Azure Function using webhooks https://docs.microsoft.com/en-us/sharepoint/dev/apis/webhooks/sharepoint-webhooks-using-azure-functions , in you want to use Web UI Experience (your text field).
A simply way could be powershell import from csv / Excel https://gallery.technet.microsoft.com/office/Add-SPOListItemsFromCSV-76077b14
Cheers,
Federico
ps: I just add a uservoice, you can vote for it if you want :) https://sharepoint.uservoice.com/forums/329214-sites-and-collaboration/suggestions/36941659-geolocation-field-compatibility-with-excel-flo
EricDeferm
Feb 28, 2019Steel Contributor
Hi FedericoPorceddu82 , didn't know one could also specify the Altitude & Measure. The programming interface supports 4 values, whereas the user interface only allows you to enter 2 fields (Long. & Lat.) or does your interface look different from mines? Tx.
Feb 28, 2019
Hi EricDeferm , try classic experience :)
- EricDefermMar 01, 2019Steel ContributorHi Federico, that's strange. The list from which I start is configured for Classic experience. Any idea what other configuration settings could have an impact?
- Mar 01, 2019
Hi,
there is no difference from classic or modern experience in creation / configuration.
I see difference only in editing.
What about your screenshot? Is it modern experience?
- EricDefermMar 01, 2019Steel ContributorHi, tx for your reply. The screenshot is classic experience.