165
Hi all,
I have my zipcode and city swapped with data bu mistake in lots of records.
Zipcode got text, and city got zipcode.
We need to find out how many of the records are mismatched.
Is there a way to find from ms dynamics or any best approach to find it?
*This post is locked for comments
Hi
If you can find these records via Advance Find, you can try the following to fix this issue
01. Create an on-demand workflow on the entity and use the Update step to swap the values.
02. Perform advance find, find the records that need value swapping
03. Select records and run the on-demand workflow on them to swap.
Note : if you have loads of records, and if you cant do manually, you can use the following XrmToolBox plugin to bulk execute workflows on these records
You can build the query in advance find, download the Fetch and paste in this plugin to run workflow against the records that need swapping
its online
Hi,
You can export data in excel and use Vlookup to find mismatch data.
Thanks
Nitin
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (