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!
Solved! Go to Solution.
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.
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.
User | Count |
---|---|
161 | |
85 | |
71 | |
64 | |
62 |
User | Count |
---|---|
208 | |
147 | |
95 | |
84 | |
66 |