Hi @accorti ,
Do you want to use multiple controls to update rather then using a form?
Well, if so, you just need to use Patch function.
Could you tell me the fields' data type that you want to update?
I assume that all of them are char type.
I've made a similar test for your reference:
1)insert a drop down, two textinputs
set the drop down's Items:
["Active", "Closed", "Inprogress"]
set the textinput1's Default:
"AB-"
2)set the update button's OnSelect:
If(StartsWith(Textinput1.Text,"AB-"),
Patch(table,Defaults(table),
{Job Status:drop down1.Selected.Value,Job Number :Textinput1.Text,Client Name :Textinput2.Text}
),
Notify("Job Number should starts with "AB-"",NotificationType.Warning)
)
Please note that your sql table should have primary key, or else you can not update it in PowerApps.
Best regards,
