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

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

Hi @AJ_vizMan,

 

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

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

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
Dual Super User
Dual 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 III
Helper III

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 Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

New Process Advisor Capabilities carousel.png

Read the blog for the latest news

Read the latest about new experiences and capabilities in the Power Automate product blog.

PA Survey Carousel Image.png

We want to hear from you!

If you are a small business ISV/Reseller, share your thoughts with our research team.

AI Builder AMA June 7th carousel (up on May 25th, take down June 8th) (1).png

'Ask Microsoft Anything' about AI Builder!

The AI Builder team invite you to ask questions and provide helpful answers at our next AMA.

Users online (1,591)