Notifications
Announcements
No record found.
Hi experts,
After DB refresh from production to sandbox environment, all users are disabled except Admin. Is there any way we can run a job or Power Automate to enable users after refresh?
Thanks,
Hi Yes,
We have similar requirement in our project. we automated the whole process below are some high level steps :
1) Create Import project in DMF for User entity of D365 F&O.
2) Export the needed user list in file and save it in Azure devops repository.
3) Create Azure devops pipeline to execute import project and feed user list created in step 2 to it. please check this link for more information on how to run import project using Azure devops pipeline.
Thanks to Adrià for the great article which we can follow.
Regards,
Pawan
Hi Yuji,
You can follow the suggestion from Pawan or use one of the next options:
1) Open in Excel. You can use this option to edit the users in an Excel sheet and publish the changes; including the Enabled field.
2) Use a Power Automate flow.
For these two options, you need to think of a way to exclude users which are on purpose not enabled. Probably, you can first export the current state of users. Power Automate can read an Excel file and use this information to update selected users only. In the option provided by Pawan, this is a mandatory step.
Hi Pawan,
Do you know if I upload the file to Azure DevOps Repository, how can I access the file from the PowerShell?
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.
Martin Dráb 544 Most Valuable Professional
André Arnaud de Cal... 450 Super User 2025 Season 2
Sohaib Cheema 250 User Group Leader
