Forum Discussion
How to handle multi-line field limits in SharePoint Lists
Emanuele94 I really don't understand the issue here. I built a similar IT support ticketing system with Forms, Power Automate, SharePoint lists and multiple lines of text columns. It's had over 30,000 tickets so far. A multiple lines of text column can have something like 64000 characters, but that's per item, not across all the items in the list! What is happening that makes you think you have reached "the threshold"?
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP UK (and classic 1967 Morris Traveller driver)
Emanuele94 I really don't understand the issue here. I built a similar IT support ticketing system with Forms, Power Automate, SharePoint lists and multiple lines of text columns. It's had over 30,000 tickets so far. A multiple lines of text column can have something like 64000 characters, but that's per item, not across all the items in the list! What is happening that makes you think you have reached "the threshold"?
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP UK (and classic 1967 Morris Traveller driver)
Rob_Elliott thank you so much for your response!
I have been noticing the last tickets collected by the Form were actually truncated in the multi-line field, the last part of the text is missing.
Consulting the documentation and finding out about the 64000 character limit, I panicked thinking the limit was meant across items, I'm relieved to know it applies to each item, thank you!
I will further investigate the truncated text problem, at least I know it does not depend on field limits.
Thank you Rob!
- Make sure you really have set it the column as multiple lines of text and single line of text.
