PowerShell Activity

Workflow Studio supports workflow activities that can execute PowerShell cmdlets and retrieve results inside the same Workflow. The capability to execute PowerShell cmdlets makes it easier to implement custom use cases/scenarios that cannot be handled via out-of-the-box connectors and workflows.

The AzXPowerShellActivity is the workflow activity that allows developers to execute the cmdlets found in the following PowerShell modules:

• AzureAD

• EXO V2

• MSOnline

• MSTeams

• SharePointOnline

The AzXPowerShellActivity Activity relies upon the microservices running in the Azure tenant where the cmdlets are to be executed. There are microservices for each type of cmdlets supported by the AzXPowerShellActivity.

• Developers can pass the commands and specify which microservice will handle the script execution in the AzXPowerShellActivity inside any workflow.

• The AzXPowerShellActivity calls the SCIM connector to authenticate the user executing the command. The AzXPowerShellActivity exposes a property that allows setting the account store,

• The SCIM microservice will then pass the commands to the microservice. The microservice will execute the commands in azure resources. The Workflow receives the results from the execution of the command. E.g., we can add an activity to execute the Add-TeamUser command and specify to run it in MS Teams PowerShell microservice. The specific microservice will execute the command and return the results to the Activity.

Properties

The Major properties of TheDotNetFactory.Framework.PowerShell class are

The major properties of the AzXPowerShellActivity class are

Azure AD PowerShell Workflow

In this tutorial, we will create and publish an Azure AD PowerShell Workflow using the WFS. We will cover the following.

• Create a workflow that uses AzXPowerShellActivity, which will run the command below in Azure AD Microservice. This command fetches DisplayName, Mail, and ObjectId attributes for the top 50 Azure Ad Users.
  

  Get-AzureADUser -Top 50 | Select DisplayName, Mail, ObjectId | ConvertTo-Json

• We will include DynamicPowershellResultsGrid Activity in the Workflow to view the results in a grid.

• Publish the Workflow

• Verify the Workflow is working by executing the Workflow in EmpowerID. We should be able to see a grid with DisplayName, Mail, and ObjectId attributes for the top 50 Azure Ad Users.

Create Workflow

Please follow the instructions below to create an Azure AD PowerShell Workflow that uses AzXPowerShellActivity & DynamicPowershellResultsGrid.

1. In the Workspace tree of Solution Explorer, right-click the Package node where you want to create the Workflow and select New Workflow > Flow Chart Workflow from the context menu.
   

   

2. The Workflow Designer will load a flowchart workflow with default shapes and names.

3. Save the Workflow with an appropriate name. Click on the Save icon, provide a File Name in the dialog, and click the Save button. Once you save the Workflow, the WFS will reload the Workflow. In the screenshot below, we are saving the Workflow with the Name AzureUsersWF.
   
   

   

4. Let’s add an activity. Click on the Activities Tab and Search for AzXPowerShellActivity. Drag and drop the Activity to the designer window.
   
   

   

   
   

5. Select the Activity, click on the Properties tab and change the Name to meaningful.
   
   

   

   
   

6. Right-click on the Activity and select Edit Get/Set Data logic in the context menu.
   
   

   

7. Add a using reference to the PowerShell library.
   
   

   using PS = TheDotNetFactory.Framework.PowerShell;

   
   

8. Paste the code for the SetDataCode method. Please ensure the following important property values are correctly set for the code to work.

   • PSServiceType : Set the value of PSServiceType to AzPowerShellType.AzureAD to make the AzXPowerShellActivity work with Azure AD.

   • AccountStoreID: Set the value to the right account store so that the current user executing the PowerShell commands can be authenticated.
     

     public virtual void SetDataCode(uni.WorkflowExecutor context, uni.IActivity activity)
             {
                 try
                 {
                  PS.PSCommand cmd = new PS.PSCommand();
                  cmd.IsScript = true;
                  cmd.CommandText = "Get-AzureADUser -Top 50 | Select DisplayName, Mail, ObjectId | ConvertTo-Json";
      
                  var commands = new List<PS.PSCommand>();
                  commands.Add(cmd);
      
                  this.CurrentWorkflow.GetADUsersCmdlet.PSServiceType = AzPowerShellType.AzureAD;
                  this.CurrentWorkflow.GetADUsersCmdlet.AccountStoreID = 2615;
                  this.CurrentWorkflow.GetADUsersCmdlet.Commands = commands;
                  this.CurrentWorkflow.GetADUsersCmdlet.RestrictDelayToSameServer = true;
                  this.CurrentWorkflow.GetADUsersCmdlet.EnablePassiveResultsHandling = false;
                  this.CurrentWorkflow.GetADUsersCmdlet.MaxWaitLoopCount = 10;
                  TdnfTrace.Current.TraceData(TraceEventType.Verbose, 411, "!!!!!######Starting to execute the command: " + cmd.CommandText);
                 }
                 catch(Exception ex)
                 {
                     TdnfTrace.Current.TraceData(TraceEventType.Verbose, 411, "!!!!!######Something blew up executing the command");
                 }
           }

     
     

9. Now, add another activity to receive the results from the PowerShell commands. Search for DynamicPowershellResultsGrid in the Activities tab and drag-drop the Activity to the designer.
   
   

   

   
   

10. Select the Activity, click on the Properties tab and change the Name to something meaningful. In this example, we renamed it to ShowUserResults.

11. Paste the code into the GetDataCode method.

     public virtual void GetDataCode(uni.WorkflowExecutor context, uni.IActivity activity)
             {
                this.CurrentWorkflow.ShowUserResults.Result = this.CurrentWorkflow.GetADUsersCmdlet.Results;
            }

12. Please ensure all the activities are connected, and the necessary codes are included in the methods as instructed above.
    
    

    

13. Click on the Compile icon to compile the activity code.
    

    

Publish Azure AD PowerShell Workflow

We are all set to publish the Workflow. Please follow the instruction, and information about publishing the workflow items can be found here.

Verify the Workflow is Working

1. Log in to your EmpowerID portal.

2. Navigate to Object Administration → Workflows.
   

   

3. Search the Workflow published earlier and click on the workflow name in the Run column to execute the Workflow.
   
   

   

   
   

4. You should be able to see the Grid that populates the users from the Azure AD.
   
   

   

   
   

MSOnline PowerShell Workflow

This tutorial will create and publish an MSOnline PowerShell Workflow using the WFS. We will cover the following.

• Create a workflow that uses AzXPowerShellActivity, which will run the command below in MS Online Microservice. This command “Gets contacts from Azure Active Directory. “

  Get-MsolContact | ConvertTo-Json

• We will include DynamicPowershellResultsGrid Activity in the Workflow to view the results in a grid.

• Publish the Workflow

• Verify the Workflow is working by executing the Workflow in EmpowerID. We should be able to see a grid with Contacts from MS Online.

Create Workflow

Please follow the instructions below to create an MSOnline PowerShell Workflow that uses AzXPowerShellActivity & DynamicPowershellResultsGrid.

1. In the Workspace tree of Solution Explorer, right-click the Package node where you want to create the Workflow and select New Workflow > Flow Chart Workflow from the context menu.
   

   

2. The Workflow Designer will load a flowchart workflow with default shapes and names.

3. Save the Workflow with an appropriate name. Click on the Save icon, provide a File Name in the dialog, and click the Save button. Once you save the Workflow, the WFS will reload the Workflow. In the screenshot below, we are saving the Workflow with the Name MsOnlinePowershellWF.
   
   

   

   
   

4. Let’s add an activity. Click on the Activities Tab and Search for AzXPowerShellActivity. Drag and drop the Activity to the designer window.
   
   

   

   
   

5. Select the Activity, click on the Properties tab and change the Name to reflect your activity purpose. In this example, we are naming the Activity GetCallMsOnlineCmdlet and using the same text for the description.
   
   

   

   
   

6. Right-click on the Activity and select Edit Get/Set Data logic in the context menu.
   
   

   

7. Add a using reference to the PowerShell library.
   

   using PS = TheDotNetFactory.Framework.PowerShell;

8. Paste the code for the SetDataCode method. Please ensure the following important property values are correctly set for the code to work.

   • PSServiceType : Set the value of PSServiceType to AzPowerShellType.MSOnline to make the AzXPowerShellActivity work with Azure AD.

   • AccountStoreID: Set the value to the right account store so that the current user executing the PowerShell commands can be authenticated from the account store.
     

      public virtual void SetDataCode(uni.WorkflowExecutor context, uni.IActivity activity)
             {
                PS.PSCommand cmd = new PS.PSCommand();
     			 cmd.IsScript = true;
     			 cmd.CommandText = "Get-MsolContact | ConvertTo-Json";
     
     			 var commands = new List<PS.PSCommand>();
     			 commands.Add(cmd);
     
     			 this.CurrentWorkflow.GetCallMsOnlineCmdlet.PSServiceType = AzPowerShellType.MSOnline;
     			 this.CurrentWorkflow.GetCallMsOnlineCmdlet.AccountStoreID = 2615;
     			 this.CurrentWorkflow.GetCallMsOnlineCmdlet.Commands = commands;
     			 this.CurrentWorkflow.GetCallMsOnlineCmdlet.RestrictDelayToSameServer = true;
     			 this.CurrentWorkflow.GetCallMsOnlineCmdlet.EnablePassiveResultsHandling = false;
     			 this.CurrentWorkflow.GetCallMsOnlineCmdlet.MaxWaitLoopCount = 10;
             }

9. Now, add another activity to receive the results from the PowerShell commands. Search for DynamicPowershellResultsGrid in the Activities tab and drag-drop the Activity to the designer.
   
   

   

   
   

10. Select the DynamicPowershellResultsGrid Activity, click on the Properties tab and change the Name to something meaningful. In this example, we renamed it to ShowResultsGrid and used the same text for the description.

11. Select the AzXPowerShellActivity in the workflow or GetCallMsOnlineCmdlet Activity in this example. Paste the code into the GetDataCode method.
    
    

    public virtual void GetDataCode(uni.WorkflowExecutor context, uni.IActivity activity)
        {
              this.CurrentWorkflow.ShowResultsGrid.Result = this.CurrentWorkflow.GetCallMsOnlineCmdlet.Results;
        }

    
    

12. Please ensure all the activities are connected, and the necessary codes are included in the methods as instructed above.
    
    

    

    
    

13. Click on the Compile icon to compile the Workflow code.
    
    

    

Publish Azure AD PowerShell Workflow

We are all set to publish the Workflow. Please follow the instruction, and information about publishing the workflow items can be found here.

Verify the Workflow is Working

1. Log in to your EmpowerID portal.

2. Navigate to Object Administration → Workflows.
   
   

   

3. Search the Workflow published earlier and click on the workflow name in the Run column to execute the Workflow.
   

   

4. You should be able to see the Grid that populates the users from the MSOnline.