Skip to main content

Notifications

Power Automate - Building Flows
Unanswered

Trigger - do not run flow if specific text is in the column

(2) ShareShare
ReportReport
Posted on by

Hi everyone. 
 
I have a problem with my flow where I established multiple (2 person) sequential approval flow. 
 
Step1 - when an item is created or modified - start first approval
 
Step 2 - if the approver 1 approves or rejects the document - update multiline custom column and write his coments in it (Custom column name: Komentar)
 
Step 3 - if 1st approval was possitive, send another opproval to another person - approver 2
 
Step 4 - add the comments of the 2nd approver to the multiline text custom column
 
PROBLEM:
 
When both of the approvers approve the document and write their comments, the comments are written in the custom multiline tect column, but when the 2nd approver approves the documents, the flow recognises the document as updated and sends again the approval request to the first approver. 
 
If I want to limit the trigger to - do not trigger if the custom column contains text "Dean" I receive a error. 
 
Can someone please help me how to solve it.
 
Many thanks.
A screenshot of a computer<br><br>Description automatically generated
 
A screenshot of a computer<br><br>Description automatically generatedA screenshot of a computer<br><br>Description automatically generated
 
 
A screenshot of a computer<br><br>Description automatically generated

Screenshot 2024-0...
Screenshot 2024-0...
Screenshot 2024-0...

Your file is currently under scan for potential threats. Please wait while we review it for any viruses or malicious content.

  • Joseph_Fadero Profile Picture
    Joseph_Fadero 666 on at
    Trigger - do not run flow if specific text is in the column
    Well-done jruniko, 

    Kindly note you can make your response as a solution, to aid others with similar issues, and also to change the status of the question you dropped.
  • Suggested answer
    jruniko Profile Picture
    jruniko on at
    Trigger - do not run flow if specific text is in the column
    I have successfully solved the problem by adding the condition in the flow as whosn below.
     
    Thanks.
     
  • Suggested answer
    David_MA Profile Picture
    David_MA 8,970 on at
    Trigger - do not run flow if specific text is in the column
    I would debug your expressions. All trigger conditions must evaluate to true for the flow to run. To do this:
    1. Remove all the trigger conditions.
    2. Add a compose action to your flow and write the first trigger condition as an expression that returns true/false.
    3. Run the flow and check that the expression returned true.
    4. If it did, add it as a trigger condition. You just need to take the expression and put @ in front.
    5. Then repeat for your other three conditions one-at-a-time until all four evaluate to true.
    6. From my understanding, trigger conditions are case sensitive when using contains. As part of your expression, you may want to convert the values to uppercase.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,508

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,839

Leaderboard