The given code is a JSON definition, likely part of...

August 28, 2025 at 02:10 PM

{
  "type": "If",
  "expression": {
    "and": [
      {
        "not": {
          "equals": [
            "@triggerOutputs()?['body/Current_x002f_Departing_x0020_Po/Id']",
            "@null"
          ]
        }
      },
      {
        "not": {
          "equals": [
            "@triggerOutputs()?['body/DepartingPositionLookUp/Id']",
            601
          ]
        }
      },
      {
        "not": {
          "equals": [
            "@triggerOutputs()?['body/DepartingPositionLookUp/Id']",
            602
          ]
        }
      }
    ]
  },
  "actions": {
    "Get_item_Current_position": {
      "type": "OpenApiConnection",
      "inputs": {
        "parameters": {
          "dataset": "https://surreypoliceservices.sharepoint.com/sites/HRPostings",
          "table": "3b3b7a51-750f-4f52-865a-b359a0c7514d",
          "id": "@triggerOutputs()?['body/Current_x002f_Departing_x0020_Po/Id']"
        },
        "host": {
          "apiId": "/providers/Microsoft.PowerApps/apis/shared_sharepointonline",
          "connection": "shared_sharepointonline_1",
          "operationId": "GetItem"
        }
      },
      "metadata": {
        "operationMetadataId": "3910a18f-7b93-4ab0-a50f-2f2428e62004"
      }
    },
    "Update_Current_Position": {
      "type": "OpenApiConnection",
      "inputs": {
        "parameters": {
          "dataset": "https://surreypoliceservices.sharepoint.com/sites/HRPostings",
          "table": "3b3b7a51-750f-4f52-865a-b359a0c7514d",
          "id": "@outputs('Get_item_Current_position')?['body/ID']",
          "item/Section/Value": "@outputs('Get_item_Current_position')?['body/Section/Value']",
          "item/ReportsTo/Id": "@outputs('Get_item_Current_position')?['body/ReportsTo/Id']",
          "item/AwaitingTransferStatus/Value": "Awaiting Departure",
          "item/TransferType/Value": "@triggerOutputs()?['body/AssignmentType/Value']",
          "item/MemberAwaitingTransfer/Claims": "@triggerOutputs()?['body/Employee/Claims']",
          "item/Section_x0020_or_x0020_Unit/Value": "",
          "item/TransferOutDate": "@triggerOutputs()?['body/DepartDate']"
        },
        "host": {
          "apiId": "/providers/Microsoft.PowerApps/apis/shared_sharepointonline",
          "connection": "shared_sharepointonline_1",
          "operationId": "PatchItem"
        }
      },
      "runAfter": {
        "Get_item_Current_position": [
          "Succeeded"
        ]
      },
      "metadata": {
        "operationMetadataId": "2a285e77-8728-4ea1-a04a-7337a8004460"
      }
    }
  },
  "else": {
    "actions": {}
  },
  "runAfter": {
    "Initialize_Position_Status": [
      "Succeeded"
    ]
  },
  "metadata": {
    "operationMetadataId": "b7b4d5d5-d4b2-42e2-b499-bfd82fa13225"
  }
}

The given code is a JSON definition, likely part of a workflow designed in Microsoft Power Automate or a similar automation platform. Here's what the code does step-by-step:

Purpose

This logic updates a SharePoint list item based on certain conditions after evaluating some data from a SharePoint trigger. If the conditions are met, it fetches data for a specific SharePoint list item (representing a "Current Position") and updates that item with new values related to a transfer process.

Breaking it down

Conditional Logic ("type": "If") The If block evaluates the following conditions using an and logical operator, which means all conditions must be true for the actions inside the If block to execute:
- Condition 1: The item ID @triggerOutputs()?['body/Current_x002f_Departing_x0020_Po/Id'] (Current/Departing Position ID) is not null.
- Condition 2: The DepartingPositionLookUp/Id from the trigger output is not equal to 601.
- Condition 3: The DepartingPositionLookUp/Id from the trigger output is not equal to 602.
If all the above conditions are true, the code performs subsequent actions (actions block). Otherwise, the flow executes the else block (here, it does nothing because else.actions is empty).

Action (1): Get_item_Current_position If the conditions pass, the workflow retrieves a SharePoint list item. Specifically:
- The item is identified using the Current_x002f_Departing_x0020_Po/Id value from the trigger's output.
- The dataset parameter points to a specific SharePoint site (in this case, https://surreypoliceservices.sharepoint.com/sites/HRPostings).
- The table parameter (3b3b7a51-750f-4f52-865a-b359a0c7514d) specifies a SharePoint list ID.
This retrieves the details of the list item representing the current/departing position.

Action (2): Update_Current_Position After successfully retrieving the item in Get_item_Current_position, the workflow updates that item. Specifically:
- It updates fields in the same SharePoint list (HRPostings) using data from both the previously retrieved item and the original trigger.
- Key updates include:
  - Setting AwaitingTransferStatus/Value to "Awaiting Departure".
  - Modifying fields like item/TransferType/Value, item/MemberAwaitingTransfer/Claims, and others using data from the trigger output.
  - Setting the TransferOutDate to the value from the trigger field DepartDate.

Run Dependencies
- The Update_Current_Position step only executes if the previous step (Get_item_Current_position) succeeds.
- The entire If block runs only after the Initialize_Position_Status step has succeeded.

Fallback (else block) If the conditions in the primary If statement are not met, the flow takes the else path. However, the else block is empty here (i.e., no alternative actions will occur).

Conclusion

This code fetches and updates a SharePoint list item related to an employee's current/departing position if specific conditions about the triggering data are satisfied. It primarily handles data related to a transfer process, ensuring statuses are updated and relevant fields reflect new information for the associated SharePoint list item.

Generate your own explanations

Download our vscode extension

Read other generated explanations

Built by @thebuilderjr