Update SQL field with Sharepoint list

[Danny_L]

I have a dropdown that is using a SharePoint list as it's data source. My form's data source is using an SQL Table. How would I go about updating SQL with the information from the dropdown selection?

Dropdown1

Failure Codes - taken from share point list

SQL Table

InProcess

SQL Column - FailureCodes

Thanks!

[RandyHayes · Accepted solution]

@Danny_L 

A variety of ways.  I'll take the UpdateIf function for the moment to provide an example:

UpdateIf(InProcess, uniqueIDcolumn=someValue, {FailureCodes: Dropdown1.Selected.Value})

Please note that .Value will be highly dependent on the Items property of the Dropdown and may be something completely different based on that. 

I hope this is helpful for you.