Notifications
Announcements
No record found.
Hi,
Is there a way to do bulk update of business unit lookup value under system user entity? I need to update new BU value to all the active users.
Hi Jayaa,
Have you tried exporting the user records to excel and import back after changing the Business Unit column?
Hi Charan,
Yes, I did. But I am getting error "duplicate lookup reference was found", even though there is no identical values.
While editing Business Unit for the users in exported excel sheet, try setting Business Unit Id instead of Business Unit Name.
You can use Bulk Security Patcher tool availble on XrmToolBox to assign users to a Business Unit in Bulk. Please refer to this blog: https://dynamicmano.com/2019/07/27/xrmtoolbox-bulk-security-patcher-to-assign-users-to-teams-or-business-units-in-bulk/
Thank you Mehdi. This is really helpful. Just one more question, after editing the BU, will the existing security roles get vanish? Do I need to assign the roles again to the users?
Yes, you need to assign the roles again.
Please don't forget to verify my answers by clicking YES above. It will close this thread and help others find the answer, thank you!
I have just tried this. Security roles got vanished. Is there a way to retain the same security roles for the users after changing BU?
I don't know if there is a way to keep the same roles when changing a BU. Maybe someone else can give an answer to this question.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Tom_Gioielli 137 Super User 2025 Season 2
#ManoVerse 57
Jimmy Passeti 50 Most Valuable Professional
