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:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

mahoneypat 1,720 on at

Like
a
(1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
v-albai-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
R Bakker 725 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No