7
I have a data card that is patching to a sql data base column set to varcharmax. I keep getting a error stating that I can not patch more than 500 characters. Is there a work around for this limitation?
Power Apps supports the update of nvarcharmax fields greater than 500 characters without the need for any workaround.
There are two causes of this problem that I can think of here:
1. The target column was originally (for example) an nvarchar(512) column that was subsequently changed to nvarcharmax. In this case, you'll need to refresh the connection to your SQL table through the data panel.
2. The error "value must be at most 500 characters in length" refers to a field other than your nvarcharmax field. Therefore, I would double check your form settings/Patch function to verify that you're referencing the correct field.
Share
Report
All responses (
Answers (
