- Power Platform environment with System Administrator access.
- Microsoft Sustainability Manager license.
- Microsoft Sustainability Manager already deployed in the Power Platform environment from Step 1 (if MSM has not been deployed, please refer to the section below for step by step instructions on how to deploy MSM).
- Download TaskMgmtSolution.zip file from the
Deployment
folder.
- Go to Solution Center https://solutions.microsoft.com/.
- Click on
Sustainability
from the left navigation menu. - Check
Add
on the Microsoft Sustainability Manager Premium Tile. - Click
Deploy
. - Add
ESG Value Chain solution
component in MSM. We recommend also adding the sample data. - Select the Power Platform environment that was created for this deployment.
- Give a name to the deployment and acknowledge terms.
- Finish Deployment.
- Please note it takes around 2-4 hours for MSM to get deployed.
This solution will include the below components -
- Custom table for MSM Tasks
- Power Automate flows for sending notifications in MS Teams and Outlook.
- 2 security roles: Sustainability- Full Access- Task Analyst and Sustainability- Full Access- Task Manager.
- N:1 relationship between MSM tasks and various MSM tables.
- Update to forms by having a subgrid for MSM Tasks in MSM Tables.
Before setting up any components of the solution, we will need to import the solution in the Power Platform environment.
-
In the PowerApps maker portal (make.powerapps.com), go to solutions > Import Solution > Browse > Choose Task Mgmt SA zip > Next
-
This will import the Power Platform solution in your environment. To validate everything got deployed, go to the imported solution and the number of components should be the same as below.
- After the solution import, click 'Publish all customizations' from the navigation bar at the top.
This solution leverages 2 Power Automate workflows. Please make sure all of them are turned on. If any of them are turned off, click on the 3 ellipsis.
The Power Automate workflows have 1 URL component that will need to be updated so the flows can send a dynamic link of the task created to the user who got the assigned task.
-
To update the URL in both the flows, we will need to navigate to MSM.
-
In the PowerApps maker portal (make.powerapps.com), go to Apps> Click on Sustainability Manager > Click on 'MSM tasks'.
-
Create a new MSM task as a test by filling in the required fields and click 'Save'. You can delete this task afterwards if needed.
-
Copy the browser URL. It will look something like: https://xyz.crm.dynamics.com/main.aspx?appid=&pagetype=entityrecord&etn=cra63_elastictask&id=
-
Copy this browser URL TILL the task GUID value.Your copied value should end at the "=" before the task GUID value. Copied value should be "https://xyz.crm.dynamics.com/main.aspx?appid=&pagetype=entityrecord&etn=cra63_elastictask&id=" from the example above.
-
Save the value from step 4.
-
Go to PowerApps Maker portal and click on Flows. Open the MSM Tasks Teams Notification flow.
-
In the compose action, replace the value saved from step 5 BEFORE the dynamic value of 'elastic task'.
-
Click
Save
. -
Repeat steps 6-8 for the MSM Tasks Email Notification flow.