Answered

Configuring Condition to check if HTML table is empty before sending email

Like (0) Share

Report

Posted on 11 Aug 2020 21:43:30 by Community Power Pla...

Hi everyone!

I'm almost finished with a flow that will send an HTML table in the body of an email, but I'd like to check if the HTML table is empty before sending the table. I saw other solutions that recommended checking the length of one of the fields in the table to make sure it's not empty, but I'm running into a wall. Can you help me configure this Condition?

For clarification, there are two tables sources - one with data and one with email addresses. Both contain the field Branch Name.

Conditional - Check if table is empty.PNG

Here's the error message I receive:

Conditional - Error Message.PNG

I've also tried length(body('Select_Inventory_Table_Fields')?['Branch Name']), but that also doesn't seem to work.

Thank you!

All responses (9)

Answers (1)

Community Power Pla... on 13 Aug 2020 at 23:36:16

Like (0)

Report

Re: Configuring Condition to check if HTML table is empty before sending email

@v-alzhan-msft Thank you so much!! This one works!
Verified answer

v-alzhan-msft on 13 Aug 2020 at 02:00:47

Like (2)

Report
Re: Configuring Condition to check if HTML table is empty before sending email

Hi @Anonymous ,

The expression should work:

length(body('Select_Inventory_Table_Fields'))

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Jcook 7,779 Most Valuable Professional on 12 Aug 2020 at 17:50:11

Like (0)

Report
Re: Configuring Condition to check if HTML table is empty before sending email

@Anonymous

Try using:

empty(outputs('Select_Inventory_Table_Fields'))

is equal to false

**Use the expression false (see below)**

** Update -- Please note that you may want to move your send email action to the if no branch for my solution above. For context the empty expression will return true if the value being passed is empty. **
Community Power Pla... on 12 Aug 2020 at 16:00:26

Like (0)

Report

Re: Configuring Condition to check if HTML table is empty before sending email

Hi!

It looks like that expression is giving me a different type of error:
I feel like we're getting closer! Thank you for your help! Let me know if you think of anything else to try!
v-alzhan-msft on 12 Aug 2020 at 01:52:18

Like (0)

Report
Re: Configuring Condition to check if HTML table is empty before sending email

Hi @Anonymous ,

Take a try with expression:

length(outputs('Select_Inventory_Table_Fields'))

check if the expression is greater that 0.

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community Power Pla... on 11 Aug 2020 at 23:22:49

Like (0)

Report

Re: Configuring Condition to check if HTML table is empty before sending email

Thank you, I really appreciate you helping me! I tried it, but for some reason it evaluated as false.

Here's a screenshot of the result of Select Inventory Table Fields where Branch Name is not empty:

Here's the result of the conditional + email:

Just to check (for science!), I set the conditional to true, and it sent all the emails, even those with empty tables.
Jcook 7,779 Most Valuable Professional on 11 Aug 2020 at 23:00:29

Like (0)

Report
Re: Configuring Condition to check if HTML table is empty before sending email

Hi @Anonymous

Can you try using empty() expression instead?

Try:

empty(outputs('Select_Inventory_Table_Fields')?['Branch Name'])

is equal to

false
Community Power Pla... on 11 Aug 2020 at 22:18:54

Like (0)

Report

Re: Configuring Condition to check if HTML table is empty before sending email

Thanks so much for taking the time to reply! Here's the error message I received for the second expression.
Jcook 7,779 Most Valuable Professional on 11 Aug 2020 at 22:01:16

Like (0)

Report

Re: Configuring Condition to check if HTML table is empty before sending email

Hello @Anonymous

What is your error when you use the second expression you showed?