Answered

Compare 2 Sharepoint list columns as trigger input for a flow

(0) Share

Report

Posted on by 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.

Categories:

Building flows

All responses (4)

Answers (1)

Sort by

Verified answer

Expiscornovus 33,997 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @AJ_vizMan,

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

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

Like
a
(0)

Report
Copy link

Link copied!

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 33,997 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
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 on at

Like
a
(0)

Report
Copy link

Link copied!

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.