cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Carmen15
Helper IV
Helper IV

"When an item or a file is modified" trigger not working

Hi , 

 

I need you support to understand why the flow I have created is not working . 

Please see below the flow steps : 

 

Carmen15_0-1612356887828.png

 

For "When an item or a file is modified" trigger I put the formula : 

Carmen15_1-1612356959927.png

 

For "Apply to each" : 

Carmen15_2-1612357010736.png

For Condition : 

 

Carmen15_3-1612357044829.png

With "Update Item" I am updating "SentGPE" to YES. 

 

What I am doing wrong ? The flow as I created is not running at all , even if It is not showing any error or warning. 

 

Thank you 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Expiscornovus
Super User
Super User

Hi @Carmen15,

 

If that is the case you could use this expression instead:

@and(equals(triggerOutputs()?['body/RequestStatus/Value'], 'Awaiting GPE Approval'), equals(triggerOutputs()?['body/SentToGPE'], 'NO'))

 

Let me know if that works for you 🙂

View solution in original post

4 REPLIES 4
Expiscornovus
Super User
Super User

Hi @Carmen15,

 

What type of fields are RequestStatus and SentToGP? Choice and Yes/No?

 

If so, try this expression in your trigger condition action instead:

 

@and(equals(triggerOutputs()?['body/RequestStatus/Value'], 'Awaiting GPE Approval'), equals(triggerOutputs()?['body/SentToGPE'], false))

 

Carmen15
Helper IV
Helper IV

Hi @Expiscornovus 

 

The RequestStatus is choice but SentToGPE is Text Line.

 

Should I use the same formula ?

 

Thanks 

Expiscornovus
Super User
Super User

Hi @Carmen15,

 

If that is the case you could use this expression instead:

@and(equals(triggerOutputs()?['body/RequestStatus/Value'], 'Awaiting GPE Approval'), equals(triggerOutputs()?['body/SentToGPE'], 'NO'))

 

Let me know if that works for you 🙂

Carmen15
Helper IV
Helper IV

@Expiscornovus  thank you ! This specific flow is working now 🙂 

 

So just for me to understand how the things are working in reality : 

- if the column in SP list is Choice I should use always '/Value"

- if the column in SP list is Text I should not use '/Value' 

Correct ? 

 

I do have a last question : The details I put into the "When an item or a file is modified" formula should match with the details I am putting into the Condition trigger for If Yes ? 

 

I am asking because I do have another flow for which I put details related to one of the columns in SP list in the formula to the trigger condition at the beginning and into the "If yes" condition I use another column details and it is not running. Should be this the point for the reason of not running ? 

 

Thank you 

Helpful resources

Announcements
 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

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

Users online (3,124)