Answered

Best practice for storing address using BingMaps?

(0) Share

Report

Posted on by Cooper01

664

I would like to use the BingMaps connector so users can resolve an address rather than type it in themselves in a canvas app. Selected address would then be stored in a Dataverse table.

I am seeing that the GetLocation response does not include a city but does include a full address.

Does anyone have any thoughts on if it would be better to just store the entire address (address.formattedAddress) in a single column or attempt to parse the city from the full address to store address, city, country, and zip in separate columns? Seems I can return the address and the country so I would need to get the city and state.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Drew Poggemann 9,287 Most Valuable Professional on at

Like (0)

Report

Hi @Cooper01,

From a data model perspective, I would suggest to store each field independently in the Dataverse and not as a single field. You will be able to do much better with sorting, filtering, charts, etc. with these fields independent.

You might want to look at the following https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/geospatial-component-input-address to help with your situation.

Hope this helps. Please mark accepted if answers your question or Like if it helped in some way.

Thanks,

Drew

Was this reply helpful? Yes No
Cooper01 664 on at

Like (0)

Report

Thank you @dpoggemann, the input address component is exactly what I need.

Was this reply helpful? Yes No