Answered

check boxes

(0) Share

Report

Posted on by JaredB

Hey All,

I am having some issues with check boxes, currently no matter how I manipulate the check box I can't seem to get to display anything other then true or false. Basically, I have it attached to a submit button, that when the app is submitted everything is gathered and placed into an email and sent. The check boxes are there to list out applications a user would need so for example I have a checkbox called Power apps, currently when submitting the form all of the apps listed in the form show up, but when I manipulate the check box I can only get it to say true or false. What am I doing wrong? In close I need to be able to check the box next to an app labled like outlook, power apps, avaya, and have those show up in the email when submitted and if they are not checked then they don't show up in the email. Code i'm using is below:

Office365Outlook.SendEmailV2(
HS_txtinp_Email.Text,
"IT Requirements Request",
HS_txtlbl_EmployeeInformation &
" " &
"Employee Name: " & HS_txtinp_EmployeeName.Text &
" Department: " & HS_txtinp_Department.Text &
" Job Title: " & HS_txtinp_JobTitle.Text &
" Start Date: " & HS_dp_StartDate &
" Cost Center: " & HS_dd_CostCenter.Selected.Value &
" Location: " & HS_dd_Location.Selected.Value &
" " &
HS_txtlbl_Equipment &
If(
!HS_cb_NoEquipmentNeeded.Value,
" Headset: " & HS_dd_Headset.Selected.Value &
" Desktop/Laptop: " & HS_dd_WorkstationSetup.Selected.Value &
" VPN Access: " & HS_dd_VPNAccess.Selected.Value &
" Phone: " & HS_dd_Phone.Selected.Value &
" Keys: " & HS_txtinp_Keys.Text &
" File Share Access: " & IFS_txtinp_FileShareAccess.Text &
" E-Mail Groups: " & IFS_txtinp_EmailGroups.Text &
" Printer Address Books: " & IFS_txtinp_PrinterAddressBooks.Text &
" Additional Requirements: " & IFS_txtinp_AdditonalRequirements.Text
) &
" " &
HS_txtlbl_ApplicationAccessLicenses &
If(
" " & HS_CB50.Text, " " & HS_CB49.Text, " " & HS_CB48.Text & " " & HS_CB47.Text
& " " & HS_CB46.Text & " " & HS_CB45.Text & " " & HS_CB44.Text & " " & HS_CB43.Text
& " " & HS_CB42.Text & " " & HS_CB41.Text & " " & HS_CB40.Text & " " & HS_CB39.Text
& " " & HS_CB38.Text & " " & HS_CB37.Text & " " & HS_CB36.Text & " " & HS_CB35.Text
& " " & HS_CB34.Text & " " & HS_CB33.Text & " " & HS_CB32.Text & " " & HS_CB31.Text
& " " & HS_CB30.Text & " " & HS_CB29.Text & " " & HS_CB28.Text & " " & HS_CB27.Text
& " " & HS_CB26.Text & " " & HS_CB25.Text & " " & HS_CB24.Text & " " & HS_CB23.Text
& " " & HS_CB22.Text & " " & HS_CB21.Text & " " & HS_CB20.Text & " " & HS_CB19.Text
& " " & HS_CB18.Text & " " & HS_CB17.Text & " " & HS_CB16.Text & " " & HS_CB15.Text
& " " & HS_CB14.Text & " " & HS_CB13.Text & " " & HS_CB12.Text & " " & HS_CB11.Text
& " " & HS_CB10.Text & " " & HS_CB9.Text & " " & HS_CB8.Text & " " & HS_CB7.Text
& " " & HS_CB6.Text & " " & HS_CB5.Text & " " & HS_CB4.Text & " " & HS_CB3.Text
& " " & HS_CB2.Text & " " & !HS_CB1.Text

))

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (2)

Sort by

Verified answer

BCBuizer 22,833 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @JaredB ,

For each line that should be included when checked, you can use:

If(CheckBox.Value, "The text that goes with the item ")

Vice versa the text in the If statement will be left out when the CheckBox in unchecked.

Was this reply helpful? Yes No
JaredB 71 on at

Like
a
(0)

Report
Copy link

Link copied!

Does that go in the ONcheck, or in the Text part of each check box, I have tried different combos of this statement and it doesn't seem to work.

Was this reply helpful? Yes No
BCBuizer 22,833 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

HI @JaredB ,

This should be included in the body parameter of the sendEmailV2 function.

Was this reply helpful? Yes No
JaredB 71 on at

Like
a
(1)

Report
Copy link

Link copied!

After looking at it for a min I figured thats what you meant, thank you again it looks like that worked.

HS_txtlbl_ApplicationAccessLicenses
&
" " & If(HS_CB50.Value, "Option")
& " " & If(HS_CB49.Value, "Option")
& " " & If(HS_CB48.Value, "Option")
& " " & If(HS_CB47.Value, "Option")
& " " & If(HS_CB46.Value, "Option")
& " " & If(HS_CB45.Value, "Option")
& " " & If(HS_CB44.Value, "Option")
& " " & If(HS_CB43.Value, "Option")
& " " & If(HS_CB42.Value, "TrainTrack (Access)")
& " " & If(HS_CB41.Value, "SQL Server Standard Core Edition")
& " " & If(HS_CB40.Value, "Sky Kick")
& " " & If(HS_CB39.Value, "Revitt")
& " " & If(HS_CB38.Value, "Procal")
& " " & If(HS_CB37.Value, "Power Bi")
& " " & If(HS_CB36.Value, "PI")
& " " & If(HS_CB35.Value, "Oanda API Basic")
& " " & If(HS_CB34.Value, "Navisworks")
& " " & If(HS_CB33.Value, "MiniTab")
& " " & If(HS_CB32.Value, "Microsoft Visio")
& " " & If(HS_CB31.Value, "Microsoft Sharepoint")
& " " & If(HS_CB30.Value, "Microsoft Project")
& " " & If(HS_CB29.Value, "Manager Plus")
& " " & If(HS_CB28.Value, "Intranet")
& " " & If(HS_CB27.Value, "ETQ")
& " " & If(HS_CB26.Value, "Empower")
& " " & If(HS_CB25.Value, "DWG Trueview")
& " " & If(HS_CB24.Value, "Docuware")
& " " & If(HS_CB23.Value, "D365")
& " " & If(HS_CB22.Value, "Clarity")
& " " & If(HS_CB21.Value, "Chemstation")
& " " & If(HS_CB20.Value, "Chemdoodle")
& " " & If(HS_CB19.Value, "BloomBerg Fixed Assets")
& " " & If(HS_CB18.Value, "AutoCAD")
& " " & If(HS_CB17.Value, "Atlas")
& " " & If(HS_CB16.Value, "Adobe Pro")
& " " & If(HS_CB15.Value, "Option")
& " " & If(HS_CB14.Value, "Option")
& " " & If(HS_CB13.Value, "Option")
& " " & If(HS_CB12.Value, "LinkedIn")
& " " & If(HS_CB11.Value, "Galaxy")
& " " & If(HS_CB10.Value, "Network Servers")
& " " & If(HS_CB9.Value, "Galaxy")
& " " & If(HS_CB8.Value, "VM Ware")
& " " & If(HS_CB7.Value, "Duo-Access")
& " " & If(HS_CB6.Value, "Ipswitch Whatsup Gold/Netmon")
& " " & If(HS_CB5.Value, "Cisco FirePOWER")
& " " & If(HS_CB4.Value, "Treesize Pro")
& " " & If(HS_CB3.Value, "Checkpoint")
& " " & If(HS_CB2.Value, "Microsoft Visual Studio")
& " " & If(HS_CB1.Value, "Avaya")

Was this reply helpful? Yes No
JaredB 71 on at

Like
a
(1)

Report
Copy link

Link copied!

@BCBuizer I sent you a PM about this topic as well having some spacing issues.

Was this reply helpful? Yes No
Verified answer

BCBuizer 22,833 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @JaredB ,

you need to include the " " tag in the If statement, otherwise an empty row will be included, for instance:

HS_txtlbl_ApplicationAccessLicenses & If(HS_CB50.Value, " Option") & If(HS_CB49.Value, " Option") & If(HS_CB48.Value, " Option") ...

Was this reply helpful? Yes No