Ugh! Almost through my first PowerApps to Azure SQL connection!
Here is my table in SQL:
Here is my Patch command in PowerApps
Patch('[dbo].[QSelf]', Defaults('[dbo].[QSelf]'), {lat: status_lat.Text, long: status_long.Text, altitude: status_alt.Text, user: status_user.Text, notes: input_notes.Text, image: text_takenImage.Text, date: DateValue(Text(status_date.Text,"[$-en-US]yyyy-mm-dd")), time: status_time.Text });
Here is the error:
Value must be at most 1 characters in length.
Any clues as to where the error is occurring? This is my first time ever working with SQL, so pardon my ignorance.
Thank you
Solved! Go to Solution.
According to your table column definition, you have the following columns set to Not NULL:
date,
time,
lat,
long,
ID
All those fields need to be inputted with valid value when creating new records.
Which means:
Status_lat.text
status_long.Text
status_date.Text
status_time.Text
need to be filled with valid string within it, if you have the ID set as Auto Increment from the SQL Server side (if not, then the ID field is also required in the record syntax).
{lat: status_lat.Text, long: status_long.Text, altitude: status_alt.Text, user: status_user.Text, notes: input_notes.Text, image: text_takenImage.Text, date: DateValue(Text(status_date.Text,"[$-en-US]yyyy-mm-dd")), time: status_time.Text}
Regards,
Michael
According to your table column definition, you have the following columns set to Not NULL:
date,
time,
lat,
long,
ID
All those fields need to be inputted with valid value when creating new records.
Which means:
Status_lat.text
status_long.Text
status_date.Text
status_time.Text
need to be filled with valid string within it, if you have the ID set as Auto Increment from the SQL Server side (if not, then the ID field is also required in the record syntax).
{lat: status_lat.Text, long: status_long.Text, altitude: status_alt.Text, user: status_user.Text, notes: input_notes.Text, image: text_takenImage.Text, date: DateValue(Text(status_date.Text,"[$-en-US]yyyy-mm-dd")), time: status_time.Text}
Regards,
Michael