We are importing large number of records into Dynamics 365, and would like to figure out a way to update specific records upon import.
A more specific case being the following:
- import 100+ records at once.
- These records are all found in USA and have Phone Number and States assigned to them.
- Need to update a required field "Timezone" based on the above criteria
is there a way to automate this? if not, what's the best way to achieve this?
thank you in advance,
Avo