
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