Compare 2 Sharepoint list columns as trigger input for a flow

[AJ_vizMan]

Hi, i am working on a powerapps where Sharepoint list is data source.

Need to achieve the functionality : "When ticket is edited by user and ticket status is "Awaiting requester's input" then trigger should be there to change task status from "Awaiting requester's input" to "In Progress"

Condition : Task Status = Awaiting requester's input" And Ticket Created By = Ticket Modified By

Trigger condition used in "When an item is created or modified" step 

1. @equals(triggerOutputs()?['body/TaskStatus'], 'Awaiting Requester''s Input')

2. @equals(triggerOutputs()?['body/Author'], triggerOutputs()?['body/Editor'])

However, flow is not triggering yet.

Could you please help to identify if, need to update 2nd trigger condition. 

[Expiscornovus · Accepted solution]

Hi @AJ_vizMan,

Is your TaskStatus a choice column? If so, try:

@equals(triggerOutputs()?['body/TaskStatus/Value'], 'Awaiting Requester''s Input')

[AJ_vizMan]

Hi @Expiscornovus - Appreciate your quick response. Thank you for pointing out. yes, Task status is choice type column. i missed to pay attention.

Now, comes the second part --> Need to compare two person type columns in SP list : Created By and Modified By. Using . @equals(triggerOutputs()?['body/Author'], triggerOutputs()?['body/Editor']) to compare if both columns contain same value.

Is it okay or should i try with AND condition?

[Expiscornovus]

Hi @AJ_vizMan,

You can put it all together in one expression if both need to be true before your flow triggers:

@and(equals(triggerOutputs()?['body/TaskStatus/Value'], 'Awaiting Requester''s Input'), equals(triggerOutputs()?['body/Editor'], triggerOutputs()?['body/Author']))

[AJ_vizMan]

Hi @Expiscornovus -- Second trigger condition is perfectly fine. It was first trigger where choice type column was to be corrected.

Flow is working fine now. Many thanks.