web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Send checkbox values i...
Power Apps
Answered

Send checkbox values in email

(0) ShareShare
ReportReport
Posted on by 46

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:
I have the same question (0)
  • AaronKnox Profile Picture
    514 Super User 2024 Season 1 on at

    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 Profile Picture
    46 on at

    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 Profile Picture
    514 Super User 2024 Season 1 on at

    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:

    datacard.datafield-property.jpg

     

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

     

    Hope this helps!

    Aaron

  • itchel123 Profile Picture
    46 on at

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

     

    itchel123_0-1715801431823.png

     

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

     

    itchel123_1-1715801499327.png

     

     

  • LaurensM Profile Picture
    12,516 Moderator on at

    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,
     "&#9745;",
     "&#9744;"
    )

     

    I hope this helps!

  • AaronKnox Profile Picture
    514 Super User 2024 Season 1 on at

    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 Profile Picture
    46 on at

    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 Profile Picture
    514 Super User 2024 Season 1 on at

    Hi @itchel123 ,

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

     

  • itchel123 Profile Picture
    46 on at

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

  • AaronKnox Profile Picture
    514 Super User 2024 Season 1 on at

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
wolenberg_ Profile Picture

wolenberg_ 119 Super User 2026 Season 1

#2
WarrenBelz Profile Picture

WarrenBelz 107 Most Valuable Professional

#3
Haque Profile Picture

Haque 103

Last 30 days Overall leaderboard