All,
I have an app where I am trying to write to my companies MYSQL Database from a galleryThe goal is to update an existing column in an existing table not add a record
The Toggle control will write to the SQL database but the text input control with the code below will not. I can write to the SQL Table in the text box by using a literal, but I cannot write to the table when referencing a Text Input or Dropdown in the Patch command
Toggle Control On check/Uncheck -
Patch('[SDC].[ShobFabTracking]',First(Filter('[SDC].[ShobFabTracking]',Barcode=ThisItem.Barcode)),{FloorTrackingStatus:true})
TextInput Control (On Select) -
Patch('[SDC].[ShobFabTracking]',First(Filter('[SDC].[ShobFabTracking]',Barcode = ThisItem.Barcode)),{BurnTableShelf: TextInput1.Text))})

Report
All responses (
Answers (