Power Automate - General Discussion

Answered

Conditon not working (List rows present in a table)

Like (3) Share

Report

Posted on 9 Sep 2024 11:41:46 by LV-09091120-0

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:

Process Advisor

All responses (3)

Answers (1)

LV-09091120-0 12 on 11 Sep 2024 at 12:06:35

Like (0)

Report

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

Michael E. Gernaey 45,345 Super User 2025 Season 2 on 09 Sep 2024 at 20:56:09

Like (2)

Report

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 11,841 Super User 2025 Season 2 on 09 Sep 2024 at 19:44:06

Like (2)

Report

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

Community site session details

Conditon not working (List rows present in a table)

Helpful resources

News and Announcements

Quick Links

Announcing our 2025 Season 2 Super Users!

Paul Stork – Community Spotlight

Congratulations to the June Top 10 Community Leaders!

Leaderboard > Power Automate

Featured topics

Product updates

Community site session details

Conditon not working (List rows present in a table)

Helpful resources

News and Announcements

Quick Links

Announcing our 2025 Season 2 Super Users!

Paul Stork – Community Spotlight

Congratulations to the June Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Power Automate

Featured topics

Product updates