Hi All,
We are facing an issue while Submitting a record on PowerApps: Value must be at most 1 characters in length
Below the screenshot of SQL table, we are using Patch function to write data. But we are not using Sl_No (Primary Key, auto generated in table) in the patch command.
ForAll(
ResponseSQCache,
Patch(
'[dbo].[Survey_Response]',
Defaults('[dbo].[Survey_Response]'),
{ SR_Identifier: SR_Identifier,
Survey_Section: Survey_Section,
Survey_Questions:Survey_Questions,
Survey_Answer: Survey_Answer,
Survey: Survey,
SR_Lon: SR_Lon,
SR_Lat: SR_Lat,
Created_On: Created_On,
Created_By_Name: Created_By_Name,
Created_By_Email: Created_By_Email,
Created_By_Designation: Created_By_Designation,
Team: Team,
Role: Role,
Survey_Task_Name: Survey_Task_Name,
WRENCH_Task_ID:WRENCH_Task_ID,
Privacy_Acceptance:Privacy_Acceptance
}
)
)
Any thoughts on this would be very helpful.
Thanks in advance.
