How To Add Days To Expiry Date By Using Power Automate

Power Automate:

Microsoft Power Automate is a cloud-based service that allows users to create automated workflows to simplify and streamline business processes

When a row is added, modified, or deleted:

This is the starting point of the flow, which triggers the process when a row is added, modified, or deleted in a specific data source.

Pass GUID:

A step for processing or passing a GUID (Globally Unique Identifier), possibly to identify a specific record or row.

Duration:

This action calculates or handles the duration, which could be related to the row data, such as time taken or time remaining.

Option set:

A step that likely interacts with or processes an option set, which is a set of predefined choices or options.

Total Days:

This action calculates or determines the total number of days, potentially based on the duration or date data from the row.

Duration and Option set is not empty:

A condition checks whether both the ‘Duration’ and ‘Option set’ fields are not empty to proceed further. If this condition is true, the next action is executed.

length(variables(‘optionset’))

DAY Condition Check (Top of the Flow)

Condition: Checks if the variable optionset is equal to 240110000.
Outcome: This condition branches into two paths:
- If Yes: Continues with the subsequent actions.
- If No: Shows an empty branch with an “Add an action” option (no further actions specified here).

If Yes Branch (Continuing from DAY Condition)
- Set Variable Action:
  - Name: Sets a variable called Totalday.
  - Value: Sets the value of Totalday to the value of another variable called duration.

Compose Action:

- Inputs: Uses the variable optionset and assigns it the value 240110000.
- This action likely prepares data for further processing based on the optionset value.
  WEEK Condition Check (Following the Compose Action):
  - Condition: Checks if the variable optionset is equal to 240110001.
  - No branches or further actions are visible under this condition in the image.

“If yes” Path:
- Action: “Set variable 2”
  - The variable being set is named Totalday.
  - The value being assigned to Totalday is calculated using an expression (shown as
    mul(variables(‘duration’),7)
    . This likely indicates a multiplication function to calculate the value, but the full expression isn’t shown in the image.
- Add an action (optional):
  - There is an option to add additional actions after setting Totalday, though none are currently present in the image.
“If no” Path:
- This path currently does not contain any actions.
- There is an option to add an action if the condition is not met, but it is not utilized in the image.

Compose 2 Action

- Inputs: The variable optionset is set to 240110001.
- This action likely prepares data using the optionset variable with the value 240110001.
  MONTH Condition Check
  - Condition: Checks if the variable optionset is equal to 240110002.
  - Outcome: This condition branches into two paths:
    - If Yes: Continues to the next action.
    - If No: Shows an empty branch with an “Add an action” option (no further actions specified here).
      If Yes Branch (Following the MONTH Condition)
      Set Variable Action (Set variable 3)
      - Name: Sets a variable called Totalday.
      - Value: Uses a formula, indicated by mul(variables(‘duration’),30)
        , which likely multiplies duration by a certain factor to calculate the value for Totalday.

Compose Action: “Compose 3”

- This action has an input that checks if optionset is equal to 240110002.
  Condition Block: “YEAR”
  - This block checks if the optionset variable is equal to 240110003.
  - If this condition is met, the process follows the “If yes” path. Otherwise, it follows the “If no” path.
    “If yes” Path:
    Action: “Set variable 4”
    - The variable being set is named Totalday.
    - The value being assigned is calculated using an expression (shown as
      mul(variables(‘duration’),365)
      , indicating a multiplication operation. The complete expression is not shown in the image.
    - Add an action (optional):
      - There is an option to add additional actions after setting Totalday, but none are currently present in the image.
        “If no” Path:
        This path does not contain any actions.
        There is an option to add an action if the condition is not met, but it is not used in this image.

“Compose” action in a workflow or automation tool (possibly Microsoft Power Automate or Logic Apps). The box labeled “Compose 4” contains an input field with the following details:

Label: optionset
Value: 240110003