Send checkbox values in email

[itchel123]

In form's OnSuccess propterty, I'm able to capture the values from textbox fields but not a checkbox field.  Below is my code. 

CheckBox: " &Form.LastSubmit.'CheckBox' & "<br/><br/> TextBox: " &Form.LastSubmit.'Last Name of Customer'

&Form.LastSubmit.'CheckBox' throws a formula error.  I've tried &Form.LastSubmit.'CheckBox'.Selected.Value. This fixes the formula error but when the email is sent, the field is blank.  

How should I capture check box values in an email  from the form's OnSuccess property?

[AaronKnox]

Hi @itchel123 ,

Form.LastSubmit needs to reference the columns in your data source, not the name of a control. 

For example, if the name of the data source column the 'CheckBox' control writes to is called projectComplete, then LastSubmit should be:

Form.LastSubmit.projectComplete

Hope this helps!

Aaron

[itchel123]

Hi @AaronKnox ,

My data source is a SharePoint List.  The name of the column for example is DataCardValue45.  I cannot use Form.LastSubmit.DataCardValue45  because the error states that DataCardValue45 is not a valid. 

When I try &DataCardValue45, it throws an error, "Invalid argument type. Expecting one of the following: Text, Number...."

[AaronKnox]

Hi @itchel123 , That is the name of the Power App data card control.  You want the name of the SharePoint column. 

Look at the SharePoint list settings to get the column name.  The column name will also be in the DataCardValue45.DataField property:

The LastSubmit() function is a copy of the record you just created in SharePoint. 

Hope this helps!

Aaron

[itchel123]

The column in SharePoint is called, "Interpretation service". This is what I see in Power Apps.

When I click "DataCardValue45", I do not see a DataField property

[LaurensM]

Hi @itchel123,

@AaronKnox's answer is correct. You will have to reference the column name (in your SP List), not the DataCardValue. Checkboxes are commonly used for Yes/No columns, in this case the following code will return true or false within your mail:

//Change ColumnName to the column storing the checkbox value
Form1.LastSubmit.ColumnName

Should it return an error, would it be possible to give additional info on the column type.

Should you want to showcase checkboxes within the mail instead of true / false you could use the following approach:

If(
    Form1.LastSubmit.ColumnName,
    "☑",
    "☐"
)

I hope this helps!

[AaronKnox]

Hi @itchel123 , That's the combo box control inside the data card.  You want the actual card, Interpretation service_DataCard4.DataField. 

LastSubmit.'Interpretation service' or similar should work if it's a Checkbox Yes/No SharePoint column type.

Hope this helps!

Aaron

[itchel123]

Hi @AaronKnox ,

The data type for the "Interpretation service" field is a choice.  It's not a Yes/No checkbox so I think that's the disconnect in my communication.  My apologies. So, what can work with a choice data type? 

Form.LastSubmit.'Interpretation service' doesn't work.

[AaronKnox]

Hi @itchel123 ,

Form.LastSubmit.'Interpretation service'.Value should work for a Choice column.

[itchel123]

I've tried &Form.LastSubmit.'Interpretation service'.Value and get error, "Invalid argument type. Expecting one of the following: Text, Number...."