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.