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.
Check out the News & Announcements to learn more.
Check out the new Power Platform Community Connections gallery!
Congratulations, the new Super User Season 2 for 2021 has started!
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.