Answered

Send checkbox values in email

(0) Share

Report

Posted on by 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?

Categories:

Building Power Apps

I have the same question (0)

All responses (13)

Answers (1)

AaronKnox 514 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
itchel123 46 on at

Like (0)

Report
Copy link

Link copied!

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...."

Was this reply helpful? Yes No
AaronKnox 514 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
itchel123 46 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
LaurensM 12,516 Moderator on at

Like (1)

Report
Copy link

Link copied!
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!

Was this reply helpful? Yes No
AaronKnox 514 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
itchel123 46 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
AaronKnox 514 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @itchel123 ,

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

Was this reply helpful? Yes No
itchel123 46 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
AaronKnox 514 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @itchel123 , What formula is in the property: Interpretation service_DataCard4.Update? This should give us a clue as what to reference in LastSubmit()

Was this reply helpful? Yes No