web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / How to use Power Autom...
Finance | Project Operations, Human Resources, ...
Answered

How to use Power Automate to set environment specific values after D365F&O database refresh

(1) ShareShare
ReportReport
Posted on by FO-07061525-0 6
 
Hi Team
 
Please I need some tips on how to efficiently set up Sandbox environment specific configurations/values after database refresh.
 
My organisation recently went live barely four months ago and there has been constant request to refresh database for issue investigation in non-production environment. I am still learning how to manage the cloud application leveraging on my AX 2012 experience.
 
Going through Microsoft material there some set up to be done in sandbox after every database refresh. 
 
I came across a contribution on the Dynamics forum suggesting using import package or Power automate to do the set up automatically but the contributor didn't state how to use any of the suggested options. 
 
Can someone please help which how to use these two options or provide pointers to material that can help me know how use Power automate flow to automatically do the set up.
I have the same question (0)
  • Verified answer
    Alireza Eshaghzadeh Profile Picture
    Alireza Eshaghzadeh 14,616 Super User 2025 Season 2 on at
    How to use Power Automate to set environment specific values after D365F&O database refresh
    Hi,
    Basically, you can define a script and run it in target environment (e.g. UAT) to delete the prod specific values and needs to be deleted and run a new one to replace it with UAT specific setup. In UAT there will be this possibility for environment owner to run such script. 
    For power automate you need to check if data entities that need already exists and can be used to truncate and update data.
    For more info please check D365 FO : Planning to automate tasks after database refresh
  • FO-07061525-0 Profile Picture
    FO-07061525-0 6 on at
    How to use Power Automate to set environment specific values after D365F&O database refresh
     
    Thank you for your contribution. 
     
    Some scripts have been put together while others are to be considered for the UAT specific set up tasks post database refresh.
     
    Regards
    Fade

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.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 2,004

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 865 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 582 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans