Hi @Hritikpatel317 !
I have 2 methods or ways to do this.
Method 1 (initialize a variable inside and then check condition):
You can follow this flow. I have used a trigger "When an item is created" so that this flow will get automatically triggered whenever someone enters the
Expressions used:
In Compose action (here known as Concatenate all emails)
concat(outputs('Get_item')?['body/approver1'],';',outputs('Get_item')?['body/approver2'],';',outputs('Get_item')?['body/approver3'])
Here I have specified the department in which it will get triggered only then send email.
In the condition, it will check if that SharePoint Department value matches the Department variable initialized in the flow. Use the output from your compose and put it in the To section of email.
Input:
Output:
Method 2 (use the trigger settings to only trigger this flow whenever an item is created to check the department column if it is equal to 'HR'):
Flow:
In the trigger I have done this so simulate this:
Trigger Expression:
@equals(triggerOutputs()?['body/Title'],'HR')
Expressions used:
In Compose action (here known as Concatenate all emails)
concat(outputs('Get_item')?['body/approver1'],';',outputs('Get_item')?['body/approver2'],';',outputs('Get_item')?['body/approver3'])
Use the output from your compose and put it in the To section of email.
Input:
Output:
I hope this helps.
