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.