Injecting address field data into SharePoint List with connected form.

[luizplanted]

Hello

I am working on an app that acts as a CMS for a map with many locations marked on it. All the necessary data is saved in a SharePoint List. To make it easy for users to add a new locations I want to implement the address field so that users won't have to find out the longitude and latitude somewhere else. Since my SharePoint List is connected to the form for editing/adding entries I am struggling to find a way to inject the data provided by the address field. Do I need to somehow get the data from the address field into the corresponding form fields or is there a more direct way? 

Thx for the help 🙂

[JR-BejeweledOne]

I can't help you with getting the information automatically, but I can help you with getting that information into SharePoint.

Do you already have columns in your list for the information?

[luizplanted]

Yes I do

[JR-BejeweledOne]

When you submit the form it 'should' add that information to the list.   I am not sure why it's not, unless you added those columns after you created the app.

[luizplanted · Accepted solution]

I have managed to make it work via the Patch() function. I have an address field, that gets the long, lat and other data from a given address. Then I just added a button that writes these values into the SharePoint-List. The only catch is that the entry needs to exist before hand. So you can't create a new entry and use the address lookup at the same time. Works fine if you first create the entry without the geo data and add it after.

[JR-BejeweledOne]

If you are able for the people using your app to have the Power Apps premium license, you can get the per app license for $120 per user per year ($10 per month), Microsoft has introduced some Premium map features that will do what you really wanted to do and get the lat and long for you.

This might give you some ideas on how to use it.

https://youtu.be/pqr28YCxvNs