Hi All,
I have about 50,000+ accounts here however, over the years the naming conventions for the accounts are all over the place.
Does anyone have any suggestions on how I can make them all the same type?
right now they range from BOBSBURGERS to BobsBurgers to bob burgers.
Anyone have any suggestions on how I could make them all the same without editing each individual accounts?
Any suggestions would be much appreciated!
Hi,
Try creating power automate to achieve your requirement.
List rows actions can be used to fetch account records.
learn.microsoft.com/.../list-rows
Various string functions can be used to format name
Then use update A Row to update account with correct format
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,522 Super User 2024 Season 2
Martin Dráb 228,441 Most Valuable Professional
nmaenpaa 101,148