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)

itchel123 46 on at

Like (0)

Report
Copy link

Link copied!

Hi @AaronKnox
That worked. Thank you so much.

Was this reply helpful? Yes No
Verified answer

AaronKnox 514 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @itchel123 ,

For a multiple Choice column, this should work:

Concat(Form1.LastSubmit.'Interpretation service',Value,",")

Hope this does the trick!

Aaron

Was this reply helpful? Yes No
itchel123 46 on at

Like (0)

Report
Copy link

Link copied!

Hi @AaronKnox

This is what I see.

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
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 ,

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!

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 , 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
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
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