Canvas App Form - Cannot Retrieve Selected Values from ComboBox in OnSuccess To Send an Email

[Anonymous]

I am designing a canvas app in which I inserted a form and connected to my data located in a SharePoint list. By default, Power Apps created the appropriate controls (text, drop down, date picker, ComboBox). Once the form is successfully submitted, Power Apps DOES successfully save the data to my SharePoint list.

In the OnSuccess function I am sending an e-mail to the user who submitted the form.  I am able to retrieve all the values of the submitted form fields for this email (except the ComboBox) by using LastSubmit. Unfortunately, I cannot retrieve the value of the selected items in the combo box to include in the email.

Control	Code to Retrieve Values Post Form Submit (onSuccess)
Text	formNewDealRequest.LastSubmit.'Presenter(s)'
Dropdown	formNewDealRequest.LastSubmit.Sector.Value
DatePicker	formNewDealRequest.LastSubmit.'Close-Date'
ComboBox	formNewDealRequest.LastSubmit.'Resource-Types-Needed'.Value

The ComboBox is working great otherwise and it successfully saves the selected items in the respective SharePoint column and sends the email with submitted data (except comboBox field). 

When I use formNewDealRequest.LastSubmit.'Resource-Types-Needed'.Value (.Value the only available option) I see the following error:  "Invalid argument type. Expecting one of the following: Text, Number, Boolean, OptionSetValue, ViewValue."

Other than adjust font sizes and colors, I did not unlock the ComboBox data card.  Any recommendations are greatly appreciated.

[eka24]

If the combobox is 'Resource-Types-Needed' , Add selected to the formula as:

Resource-Types-Needed'.Selected.Value

You can also create a separate variable for the Combobox.
On the OnSelect of the SubmitButton: Set(MyCombo,Resource-Types-Needed'.Selected.Value)

Then use the variable MyCombo

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[Anonymous]

@eka24 - Thank you for your quick response.   I can't use Resource-Types-Needed'.Selected.Value as Power Apps will only accept .Value.  However, your idea to set a var on the OnSelect of the SubmitButton might be a solution.  

My Code - OnSelect of the SubmitButton:

Set( varComboBox, formNewDealRequest.LastSubmit.'Resource-Types-Needed'.Value );

SubmitForm( formNewDealRequest )

However, when I try to reference the global var varComboBox in the email using Office365Outlook.SendEmailV2() in the Form's OnSuccess Action, it throws the "Invalid argument type. Expecting one of the following: Text, Number, Boolean, OptionSetValue, ViewValue." error prohibiting the email from being sent.  

[Jeff_Thorpe]

Does your combo box allow for multi selections?

[Anonymous]

Yes @Jeff_Thorpe  my combo box allows and is set for multiple selections. 

[Jeff_Thorpe · Accepted solution]

The good news is that you can go back to your original formula and just tweak the 'Resource-Types-Needed' like this:

Concat(formNewDealRequest.LastSubmit.'Resource-Types-Needed', Value, ",")

[Anonymous]

@Jeff_Thorpe - Thanks so much!! That was the solution using:  Concat(formNewDealRequest.LastSubmit.'Resource-Types-Needed', Value, ",")