Too much chars in powerapps form? Can't submit a form

Question

I have a problem after Submitting a form in PowerApps All connectors are all right. Function also normally works, but I suppose maybe I have too much chars in my fields, so database can't save it. I changed limits in DB for all records, but still something is wrong. Some of fields are a HtmlText form, so I assumed that maybe there is a problem, but as you can see, I've managed to save it inside Azure DB

Thanks !

DB

PowerApps

Hi @M33HoW, If my answer is helpful for you, hope you can accept it as answer. This can be beneficial to other community members. If you have any other concerns, please feel free to tell me. Thank you! — Leon Yue, Nov 11 '20 at 01:52

score 0 · Answer 1 · answered Nov 10 '20 at 08:28

In previous, we can use text or ntext data type.

But Text amd ntext data types will be removed in a future version of SQL Server. Avoid using these data types in new development work, and plan to modify applications that currently use them. Use nvarchar(max), varchar(max), and varbinary(max) instead.

In Azure SQL database, column length has the length limit 255 .

Please try to modify your SQL table column schema to nvarchar(max), varchar(max), or varbinary(max) instead.

If the length of your data is exceeded the limit, there isn't a good solution for now.

Too much chars in powerapps form? Can't submit a form

1 Answers1