Advanced Power Automate Expressions for SharePoint Automation

Power Automate is a powerful tool that lets you automate workflows between different apps and services, like SharePoint, Microsoft Teams, and more. One of the features that makes Power Automate so flexible is expressions. These are like mini-formulas that let you perform advanced actions and calculations in your workflows.

This article will explain Power Automate expressions in simple terms, show how they work with SharePoint, and give examples of how you can use them to unlock advanced automation.

What Are Power Automate Expressions?

Expressions are small bits of logic or calculations written in Power Automate's own language, called Workflow Definition Language (WDL). They help you,

• Manipulate data (e.g., format dates, convert strings to numbers).
• Perform conditional logic (e.g., "if this, then that").
• Access specific parts of data (e.g., get the first item in a list).
• Combine text, numbers, or other data.

Let's take some examples

• Formatting dates for SharePoint fields.
• Extracting specific parts of data, like email domains, from user names.
• Creating dynamic file names for SharePoint document libraries.
• Calculating values before storing them in SharePoint lists.

Examples of Power Automate Expressions with SharePoint.

1. Format a Date for SharePoint

If SharePoint expects a specific date format, you can use the format DateTime expression to convert your date.

• Takes the date when a file was last modified.
• Converts it to the format "YYYY-MM-DD" (e.g., 2025-01-18).

  formatDateTime(
      triggerOutputs()?['headers']['x-ms-file-last-modified'], 
      'yyyy-MM-dd'
  )

2. Extract Usernames from Email Addresses

You might want to extract the username part of an email address (e.g., from [email protected], get john.doe).

• Splits the email address at the "@" symbol.
• Returns the first part (before the "@").

  split(
      triggerOutputs()?['body/Email'], 
      '@'
  )[0]
  

3. Calculate Due Dates

Add a specific number of days to a date to calculate a due date.

• Gets the current date and time (utcNow()).
• Adds 7 days to it.
• Formats it as "YYYY-MM-DD."

  addDays(
      utcNow(), 
      7, 
      'yyyy-MM-dd'
  )

4. Combine Text for Dynamic File Names

Create unique names for files uploaded to SharePoint.

• Combines a static text (Invoice-), the current date and time, and a file ID.
• Adds the .pdf extension.

  concat(
      'Invoice-',
      utcNow(),
      '-',
      triggerOutputs()?['body/ID'],
      '.pdf'
  )

5. Check for Empty Fields in SharePoint

Ensure that a SharePoint field has a value before performing an action.

Check if the "Title" field in a SharePoint list item is empty.

empty(
    triggerOutputs()?['body/Title']
)

Conclusion

Power Automate expressions are like magic tools that let you unlock advanced automation in your SharePoint workflows. They help you manipulate data, handle complex logic, and ensure everything runs smoothly.