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.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
User | Count |
---|---|
194 | |
69 | |
50 | |
39 | |
30 |
User | Count |
---|---|
248 | |
112 | |
95 | |
91 | |
72 |