Skip to main content

Notifications

Power Automate - General Discussion
Answered

Conditon not working (List rows present in a table)

(2) ShareShare
ReportReport
Posted on by 12
Hi all,
Why does the condition not work? 
 
I am attempting to create a flow that does the following:
Sends an email to all recipents in the Excel file.
- If there is a custom message listed in the column "custom message" in the Exce file, it should send an e-mail via the action "type 1".
- If there is no custom message listed in the column "custom message", it should send an email via the action "type 2".
 
Condition is:
Custom message = true
 
When I run the flow it says: the branching condition for this action is not satisfied.
And both John and Jane receive an email of type 2.
 
 
 
 
Categories:
  • LV-09091120-0 Profile Picture
    LV-09091120-0 12 on at
    Conditon not working (List rows present in a table)
    Thanks so much FLMike! That was perfect and easy to follow. I got it to work now :)
     
  • Verified answer
    FLMike Profile Picture
    FLMike 31,580 on at
    Conditon not working (List rows present in a table)
    Hi
     
    it doesn't work because you aren't checking if the thing is NULL or Blank or has a value, you are just comparing a value to true.
     
    Change it to this
     
    use the expression empty do not TYPE the word empty
     
    delete custom messgae on the left
    click in, when the pop up shows up go to the Expression tab
    type empty() and it should come up and you can select the expression
     
    Now with the window still open click on the Dynamic Property Tab
    click the mouse between the two ()
    now find the Custom Message Column and place that there
     
    Change the middle to be is not equal to
    and leave the right as the true expression.
     
    Now it will return true or false on the left if its Empty
     
    So you want
     
    IsEmpty is not equal to true
     
    So that in your Yes side, it means it was NOT empty and do your action 1
    And on the No side, it was empty so do your action 2
     
     
     
  • Suggested answer
    David_MA Profile Picture
    David_MA 9,039 on at
    Conditon not working (List rows present in a table)
    You need to add an expression to your Excel field in the condition. The way you have it configured, the custom message would need to be what is returned from the expression true. The expression on your field would be not(empty(your_dynamic_excel_field))

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,666

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,996

Leaderboard