You’re offline. This is a read only version of the page.
112
Afternoon all,
I have a dataverse table that has youth project members addresses on from around the UK on it. Is there a way to get dataverse to check an excel sheet for the postcode and apply their county into a dataverse field/column?
You might have to have a play. It will work if Bing Map Response is in a similar format at your organisation’s address…
Eric,
thank you so much, I will try this 100% regardless that they have changed their mind.
My organisation have changed things slightly, they have categorised all postcode into a regions (column E). I have uploaded a the excel file, they now want it to check the postcode and then add regions (column e) to dataverse. So no need to use bing map connector but any suggestions?
Hi @Mick_gibbons1,
Yes this should be possible and fairly simple by leveraging Power Automate flows and the Bing Map connector. You can keep the data in Excel or my suggesting is to import the postcodes from the Excel file into another Dataverse table. This way in the flow you're just working with one data source (ie Dataverse). High-level logic:
Hope this helps!
#1
mmbr1606
22
Super User 2025 Season 1
#2
stampcoin
19
#3
Michael E. Gernaey
15
Super User 2025 Season 1
Share
Report
All responses (
Answers (
