Lookup a postcode in an excel file and then place the county name in Dataverse

(0) Share

Report

Posted on by Mick_gibbons1

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?

Categories:

Microsoft Dataverse with Power Apps

All responses (3)

Answers (0)

Sort by

EricRegnier 8,720 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
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:

When a Youth Member Address record is created or updated, the flow triggers using the Dataverse connection, trigger Trigger flows when a row is added, modified, or deleted

Search the location with the fields/data present in the Youth Member Address record using the Bing Map connector and action Get Location By Address.

Update the Youth Member Address record with the results from step #2 using the Update a Row action. If something is returned, it's most likely a correct address containing a country. There's also a confidence level returned which you can chose to apply additional logic if you feel the confidence level is too low.

Hope this helps!
Mick_gibbons1 112 on at

Like
a
(0)

Report
Copy link

Link copied!

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?

Book1.xlsx
EricRegnier 8,720 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

You might have to have a play. It will work if Bing Map Response is in a similar format at your organisation’s address…