How to Check If SharePoint List Column Equals in Power Automate?

While working with Power Automate, you often need to check if a column in a SharePoint list equals a specific value before taking further actions. For example, you might want to send an email notification when the Status column in a SharePoint list equals Approved.

In this tutorial, I will explain different ways to check if SharePoint list column equals in Power Automate using conditions, expressions, and trigger filters.

Check If the Column Equals to a Specific Value in Power Automate

Let’s say you have a SharePoint list called Support Tickets, and you want to check if the Status column equals Resolved. If the status is Resolved, you want to send a confirmation email to the client.

Now follow the below steps:

1. Open Power Automate and create an Automated Cloud Flow using the SharePoint connector’s ‘When an item is created or modified‘ trigger. Select the SharePoint site where your ‘Support Tickets‘ list is present, and choose the ‘Support Tickets‘ list.

2. Add a Condition action to check if the Status column equals Resolved. Provide the below:

@{triggerBody()?['Status/Value']} is equal to Resolved

3. In the Ture section, use the Send an email action to notify the client that their ticket has been resolved. Then Provide below parameters:

• To: Provide the recipient to the Client Email field from the SharePoint list.
• Subject: Provide the below Subject

Your Support Ticket @{triggerBody()?['TicketID']} Has Been Resolved

• Body:

Dear @{triggerBody()?['ClientName']},

We are pleased to inform you that your support ticket (Ticket ID: @{triggerBody()?['TicketID']}) regarding @{triggerBody()?['IssueDescription']} has been successfully resolved.

Thank you for your patience and for choosing our support team.

Best regards,
TSINFO TECHNOLOGIES PVT. LTD.

Now save the flow and run the flow manually. Then go to the SharePoint list and check the status column to Resolved.

After the flow runs successfully. you can see the client will receive like below email.

Check If the SharePoint List Column Equals to Another SharePoint List Column in Power Automate

Suppose you have two SharePoint lists:

• Employee Details
  • Employee Code (Single line of text)
  • Name (Person or Group)
  • Department (Choice)

• Employee Transfers
  • Employee ID (Single line of text)
  • New Department (Choice)

I want to check if an employee’s New Department in the Employee Transfers list is the same as their existing Department in the Employee Details list. If they are the same, do nothing; if not, update the value.

To do this, follow the below steps:

1. Create an Automated Cloud Flow using the SharePoint connector’s ‘When an item is created or modified‘ trigger. Select the SharePoint site where your Employee Transfers list is present, and choose the Employee Transfers list.

2. Add the Get items action to fetch the matching employee from the Employee Details list where Employee ID equals the one in Employee Transfers. Then provide the below parameters:

• Site Address: Select the SharePoint site address.
• List Name: Select the Employee Details SharePoint list.

Expand the Advanced parameters by clicking the dropdown menu.

• Filter Query:

EmployeeCode eq '@{triggerBody()?['EmployeeID']}'

3. Add a Condition action to Compare Departments. Provide the below:

@{items('For_each')?['Department/Value']} is equals to @{triggerBody()?['NewDepartment/Value']}

It will automatically add a for each loop.

4. In the False section, add the Update item action and provide the below expression:

• Site Address: Your SharePoint site
• List Name: Employee Details
• ID: Select dynamic content ID
• Department Value: Select the New Department from the dynamic content of the When an item is created or modified.

Now save the flow and run it manually. Then, add the item below to SharePoint’s Employee Transfers list.

After the flow runs successfully, go to the sharepoint list Employee Details. You can see the department has changed from Information Technology to Sales.

Conclusion

In this tutorial, we explored different ways to check if a column in a SharePoint list equals a specific value in Power Automate. First, we looked at how to check if the Status column in a Support Tickets list is Resolved and send an email notification to the client.

Then, we covered how to compare a column in one SharePoint list with a column in another list, specifically checking if an employee’s New Department in the Employee Transfers list matches their current Department in the Employee Details list.

Moreover, you may like some more Power Apps tutorials:

• Power Automate IF Length
• Power Automate Condition If String
• Send Birthday Wishes Using Power Automate
• Check If the Body is Empty in Power Automate
• Check If the Column is Changed in Power Automate
• dayOfWeek Function in Power Automate