Answered

If Statement in body of email

(0) Share

Report

Posted on by Dave-ITMan

Hi Experts!

I have an app that is logging the assigned hardware to staff and when the IT department issues out some equipment, it emails people to say what has been issued. I have text input boxes for things like Make, Model, Serial Number, Computer Name and in the body of the email it sends out, I only want it to show the information that has been entered and if nothing has been entered in the text input then it doesn't display it in the body of the email.

Below is my current code, on the line under Employee Name, i'm wanting to create some if statements, for example, if textinput1 is blank then don't display anything but if textinput1 is not blank then display the line in the body of the email like Laptop Make:"&Form3.LastSubmit.LaptopMake&"

SubmitForm(Form3);

Office365Outlook.SendEmailV2(NewEmployeeGlobalAddressList.Text , "Equipment Assigned For Employee "& Form3.LastSubmit.Title&"" , "Hi,<br><br>

Equipment has now been assigned for an employee<br><br>

<b>Originally Requested By:</b>"&Form3.LastSubmit.'Created By'.DisplayName&"<br>
<b>Original Request Date:</b>"&Form3.LastSubmit.Created&"<br>
<b>Employee Name:</b>"&Form3.LastSubmit.Title&"<br>

Regards<br><br>"
);

Navigate(Success)

Please help, Thanks in Advance!

Categories:

General Questions

Connecting to Data

Using Apps Using Formulas

All responses (6)

Answers (1)

Dave-ITMan on at

Like (0)

Report

Re: If Statement in body of email

Hi @WarrenBelz ,
All sorted, thank you so much, you are "the man"!
Regards
Dave
Verified answer

WarrenBelz 146,700 Most Valuable Professional on at

Like (1)

Report
Re: If Statement in body of email

Hi @Dave-ITMan ,

You need all the HTML "chunks" to be enclosed on quotes '' and the rest not. Apart from the start of the body (3 lines all in one set of quotes), I have made each line either HTML quote enclosed or code which is not enclosed.

Office365Outlook.SendEmailV2( NewEmployeeGlobalAddressList.Text, "Equipment Assigned For Employee " & Form3.LastSubmit.Title, "Hi, Equipment has now been assigned for an employee Originally Requested By:" & Form3.LastSubmit.'Created By'.DisplayName & " Original Request Date:" & Form3.LastSubmit.Created & " Employee Name:" & Form3.LastSubmit.Title & " " & If( Len(LaptopMakeTxt.Text) > 0, "Laptop Make: " & Form3.LastSubmit.LaptopMake & " " ) & If( Len(LaptopModelTxt.Text) > 0, "Laptop Model: " & Form3.LastSubmit.LaptopModel & " " ) & If( Len(DesktopMakeTxt.Text) > 0, "Desktop Make: " & Form3.LastSubmit.DesktopMake & " " ) & "Regards " ); Navigate(Success)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps
Dave-ITMan on at

Like (0)

Report
Re: If Statement in body of email

Hi @WarrenBelz ,

Thank you for the options, i've gone for your second option to begin with as it looks like I can understand that much easier 🙂 , i've just done as you've said but I had to remove the quotes at the end of as it was erroring on the button.

My code so far to test it is
SubmitForm(Form3); Office365Outlook.SendEmailV2(NewEmployeeGlobalAddressList.Text , "Equipment Assigned For Employee "& Form3.LastSubmit.Title&"" , "Hi, Equipment has now been assigned for an employee Originally Requested By:"&Form3.LastSubmit.'Created By'.DisplayName&" Original Request Date:"&Form3.LastSubmit.Created&" Employee Name:"&Form3.LastSubmit.Title&" & If( Len(LaptopMakeTxt.Text) > 0, Laptop Make: "&Form3.LastSubmit.LaptopMake&" ) & If( Len(LaptopModelTxt.Text) > 0, Laptop Model: "&Form3.LastSubmit.LaptopModel&" ) & If( Len(DesktopMakeTxt.Text) > 0, Desktop Make: "&Form3.LastSubmit.DesktopMake&" ) & Regards " ); Navigate(Success)

When I click the submit button, the body of the email is coming through like the below?
Hi,

Equipment has now been assigned for an employee

Originally Requested By:Flow
Original Request Date:18/04/2024 15:02
Employee Name:Staff 1
If( Len(LaptopMakeTxt.Text) > 0, Laptop Make:
) & If( Len(LaptopModelTxt.Text) > 0, Laptop Model:
) & If( Len(DesktopMakeTxt.Text) > 0, Desktop Make:
) & Regards

Thanks
WarrenBelz 146,700 Most Valuable Professional on at

Like (0)

Report
Re: If Statement in body of email

Hi @Dave-ITMan ,

Putting it as the last line ion the email

SubmitForm(Form3); Office365Outlook.SendEmailV2( NewEmployeeGlobalAddressList.Text , "Equipment Assigned For Employee " & Form3.LastSubmit.Title & "" , "Hi, Equipment has now been assigned for an employee Originally Requested By:" & Form3.LastSubmit.'Created By'.DisplayName& " Original Request Date:" & Form3.LastSubmit.Created & " Employee Name:" & Form3.LastSubmit.Title & " " & If( Len(TextInput1.Text) > 0, "Laptop Make:" & Form3.LastSubmit.LaptopMake & " " ) & "Regards " ); Navigate(Success)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps
mmbr1606 12,121 Super User 2025 Season 1 on at

Like (0)

Report
Re: If Statement in body of email

hey @Dave-ITMan

can u try this:

// Start by creating a base for the email content Set(varEmailBody, "Hi, " & "Equipment has now been assigned for an employee " & "Originally Requested By: " & Form3.LastSubmit.'Created By'.DisplayName & " " & "Original Request Date: " & Text(Form3.LastSubmit.Created, DateTimeFormat.ShortDate) & " " & "Employee Name: " & Form3.LastSubmit.Title & " "); // Conditionally add information about the laptop make if it's not blank If(!IsBlank(Form3.LastSubmit.LaptopMake), Set(varEmailBody, varEmailBody & "Laptop Make: " & Form3.LastSubmit.LaptopMake & " ") ); // Add other conditional fields similarly If(!IsBlank(Form3.LastSubmit.LaptopModel), Set(varEmailBody, varEmailBody & "Laptop Model: " & Form3.LastSubmit.LaptopModel & " ") ); If(!IsBlank(Form3.LastSubmit.SerialNumber), Set(varEmailBody, varEmailBody & "Serial Number: " & Form3.LastSubmit.SerialNumber & " ") ); // Finish off the email Set(varEmailBody, varEmailBody & "Regards, "); // Now, send the email using the variable 'varEmailBody' SubmitForm(Form3); Office365Outlook.SendEmailV2(NewEmployeeGlobalAddressList.Text, "Equipment Assigned For Employee " & Form3.LastSubmit.Title, varEmailBody); Navigate(Success);

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings
KRider 577 Super User 2024 Season 1 on at

Like (0)

Report
Re: If Statement in body of email

You can definitely use If's in email bodies.

Office365Outlook.SendEmailV2(NewEmployeeGlobalAddressList.Text , "Equipment Assigned For Employee "& Form3.LastSubmit.Title&"" , "Hi, Equipment has now been assigned for an employee "& If( IsBlank(Form3.LastSubmit.'Created By'.DisplayName), "", "Originally Requested By:"&Form3.LastSubmit.'Created By'.DisplayName&" " )&" Original Request Date:"&Form3.LastSubmit.Created&" Employee Name:"&Form3.LastSubmit.Title&" Regards " );

I only did the first one as an example. Happy coding! 😄