Isblank, don't include in email

(0) Share

Report

Posted on by R Bakker

725

Hi everyone

In my app I have a function that I can send an email order that looks like the following, the sample is fake data but real formatting, I am currently not using a flow:

Hello Supplier
Can I please order
Qty: 5 Code: Fz382-5XL Description: Bib overall
Qty: 10 Code: PF49602 Description: Alcohol Large Wipes
Qty: 3 Code: MOHAYUNSX-11 Description: Safety Food Gumboot

What i would like is if the supplier has given us an account number, that it shows up in the email like the following.

Hello Supplier

Can I please order
Qty: 5 Code: Fz382-5XL Description: Bib overall
Qty: 10 Code: PF49602 Description: Alcohol Large Wipes
Qty: 3 Code: MOHAYUNSX-11 Description: Safety Food Gumboot

Our account number XXXXXXX

But some of our suppliers don't give us an account number, and in that case I don't want the words "Our account number" Is there a way I could make this happen automatically? Currently I am just using an email connector and concat the list.

Categories:

Using Apps Using Formulas

All responses (3)

Answers (1)

R Bakker 725 on at

Like (0)

Report

Re: Isblank, don't include in email

Hi Pat
This works good, I put your formula in a text input and then my email that I am sending references that text input to include it in the email. Having the text input with no text does not cause any problems with the email. Thank you
v-albai-msft on at

Like (1)

Report

Re: Isblank, don't include in email

Hi @Corissandageri ,
Are you using the Office365Outlook connector?
If yes, the solution provided by @mahoneypat is correct, but I want to add more detailed information about how to add this into your formula. You cannot directly paste this formula into your code.
I did a test, using Textinpyt2 to keep the account number, below is my formula(remember to replace to your Concat formula):

Email with account number and without account number:

Best Regards,
Allen
Verified answer

mahoneypat 1,720 on at

Like (1)

Report

Re: Isblank, don't include in email

Instead of having text and a dynamic expression for account number, you can check if there is an account number first with an If. Put your account number dynamic expression in place of <expression>.

If(Len(<expression>)>0, "Our account number - " & <expression>, "")

Regards,
Pat