cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AJ_vizMan
Helper I
Helper I

Compare 2 Sharepoint list columns as trigger input for a flow

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

AJ_vizMan_2-1628076530800.png

 

 

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'])

AJ_vizMan_1-1628076459107.png

 

However, flow is not triggering yet.

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

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Expiscornovus
Super User
Super User

Hi @AJ_vizMan,

 

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

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

View solution in original post

4 REPLIES 4
Expiscornovus
Super User
Super User

Hi @AJ_vizMan,

 

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

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

View solution in original post

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
Super User
Super User

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
Helper I
Helper I

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.

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (1,011)