cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Tldp1
Frequent Visitor

Do not send email if table is empty

Having an issue where it keeps sending the email with the empty table. I want it to stop the flow when it checks that the table is empty. currently using a condition where I set it equal to Table is equal to null, but still sends...

 

 

228.JPG

1 ACCEPTED SOLUTION

Accepted Solutions
abm
Super User
Super User

Hi @Tldp1 

 

Check the length of the TableValue (Append String) is greater than 0 (Zero) using the below expression.

 

length(variables('TableValue'))
 
Thanks


Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials

View solution in original post

3 REPLIES 3
abm
Super User
Super User

Hi @Tldp1 

 

Check the length of the TableValue (Append String) is greater than 0 (Zero) using the below expression.

 

length(variables('TableValue'))
 
Thanks


Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials

View solution in original post

Jcook
Super User
Super User

Hello @Tldp1

You can also use the empty() expression inside your IF condition.
Try:
Use the empty() expression, and put the dynamic content of what you want to check inside the ()
And use is equal to true

Note: use the expression true

—Josh
If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others

Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips,
tricks, and guides
FlowAltDelete





Chris-J
Community Support
Community Support

@Tldp1  Suggest using length() expression to verify whether the length of TableValue or Output is 0, then determine whether to send an email.

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (2,609)