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 🙂



Happy to help out! 🙂

Interested in more #PowerAutomate #SharePointOnline or #PowerVirtualAgents content?
Visit my blog, Subscribe to my YouTube channel or Follow me on Twitter


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

 



Happy to help out! 🙂

Interested in more #PowerAutomate #SharePointOnline or #PowerVirtualAgents content?
Visit my blog, Subscribe to my YouTube channel or Follow me on Twitter


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 🙂



Happy to help out! 🙂

Interested in more #PowerAutomate #SharePointOnline or #PowerVirtualAgents content?
Visit my blog, Subscribe to my YouTube channel or Follow me on Twitter


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
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (3,302)