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.
Solved! Go to Solution.
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?
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']))
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.
Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.
Check out the new Power Platform Community Connections gallery!
Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.