question

AykutKaraca-8169 avatar image
0 Votes"
AykutKaraca-8169 asked JoyZ commented

Character or size limit of multi-line text column with append changes in a Sharepoint List

Hi Everyone,

I really couldnt find any answer on the web regarding the limit of a multi-line text column with append changes turned on. I have for example 10 version limit. Does that mean that after 10 entries/updates on that column, the oldest append will be deleted for this column? I test it but it does actually store more than 10 entries so what is the actual limit?

On internet people only answer on multi-line text but without append changes feature. They say around 65k characters or optionally unlimited if that option is turned on.

office-sharepoint-online
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AykutKaraca-8169 avatar image
0 Votes"
AykutKaraca-8169 answered JoyZ commented

I created a new list and I was able to enter 53 updates. I can still see the first update "1". I didnt enabled rich text to enter fast but that shouldnt make difference. So I wonder if my company sharepoint has set the version limit to higher number or set it to unlimited from higher permission level. Can this be possible?

73736-image.png

73741-image.png
73658-image.png
73628-image.png



image.png (33.4 KiB)
image.png (45.4 KiB)
image.png (45.0 KiB)
image.png (32.1 KiB)
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @AykutKaraca-8169,

Per my test, I have the same behavior with LiZhang.

If the "Keep the following version number" is set to 2, only 3 versions will be saved.

Whether other users occur the same issue? Per my knowledge, there is no additional option to set version limit.

You could also switch to another site to compare the result.

0 Votes 0 ·

Hi @AykutKaraca-8169,

I am looking forward to your feedback if there is any update.

0 Votes 0 ·
AykutKaraca-8169 avatar image
0 Votes"
AykutKaraca-8169 answered LiZhang-MSFT commented

Hi there,

No those are turned off.

73733-image.png



image.png (43.3 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @AykutKaraca-8169,

Please try to create a new list with Multiple lines of text column and set version limit to 1, then test.

Here is my column settings:

73693-column-settings.png

0 Votes 0 ·
column-settings.png (31.0 KiB)
AykutKaraca-8169 avatar image
0 Votes"
AykutKaraca-8169 answered LiZhang-MSFT commented

I have rich text enabled. Can that make any difference?

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @AykutKaraca-8169,

When I enable rich text, result is the same as my previous answer.

Whether you enable content approval and set appproved version limit?

73646-content-approval.png

If I enable it, I could add more than version limit+1 entries which aren't be approved.

0 Votes 0 ·
AykutKaraca-8169 avatar image
0 Votes"
AykutKaraca-8169 answered

Hello LiZhang,

If you look at my example, my version limit is 10 but I have 13 updates in my multi-line text column with append changes. So not sure why it isnt like yours.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AykutKaraca-8169 avatar image
0 Votes"
AykutKaraca-8169 answered LiZhang-MSFT edited

Aykut Karaca (2/17/2021 8:14 AM):
​new updates a
Aykut Karaca (2/15/2021 5:48 AM):
​test 5555
Aykut Karaca (2/15/2021 5:37 AM):
​test update 4444
Aykut Karaca (2/15/2021 5:12 AM):
​test update3333
Aykut Karaca (2/15/2021 5:06 AM):
​test update 222
Aykut Karaca (2/15/2021 5:00 AM):
​test update111
Aykut Karaca (2/15/2021 2:35 AM):
​test update...
Aykut Karaca (2/15/2021 1:51 AM):
​Test Update
Aykut Karaca (2/12/2021 8:27 AM):
​newest update
Aykut Karaca (2/12/2021 8:23 AM):
​yet another new update
Aykut Karaca (2/12/2021 8:17 AM):
​another update
Aykut Karaca (2/12/2021 8:04 AM):
​Test Update
Aykut Karaca (2/12/2021 3:29 AM):

As you can see above, I have 10 versions in list settings but I have stored more than 10 edits in this multi-line column with append changes. So unfortunately your answer isnt right. Also Microsoft's own agent sent this message below. So their test also showed that you can store more than the version limit:

Gloria Li MSFT has replied to your question Character or size limit of multi-line text column with append changes in a Sharepoint List in Microsoft Community.
Hi Karaca,
Thanks for sharing your experience in our community.
Per your description, you would like to know the character or size limit of multi-line text column with append changes in a SharePoint List, given this case, we are trying to test it on our side, however, based on our test, we quite agree with you if set the limit number of versions as 10, we are able to enter more than 10 entries/updates. (If my test has any differences with yours, please let us know.)
<image>
Regarding to your concern, I also have searched a lot while there seems has no Official article mentioned such limit of multi-line text column with append changes, to further help you, if you are willing, we highly recommend go to Microsoft Q & A Community and this forum has more resources on SharePoint online issues which might help you get more information. And we also welcome any community members who have some new ideas share here.
Really appreciate your effort to share this with us and your cooperation and understanding are highly appreciated.😊
Have a nice day and please take care!
Best regards,
Gloria


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @AykutKaraca-8169,

When I set version limit to 1, there are 2 entries in that column.

73387-list-version-limit-1.png

Result:

"1" will be deleted after adding "3".

73423-2-entries.png

When I set version limit to 4, there are 5 entries in that column.

73338-list-version-limit-4.png

Result:

"1" will be deleted after adding "6".

73337-5-entries.png


0 Votes 0 ·
LiZhang-MSFT avatar image
0 Votes"
LiZhang-MSFT answered LiZhang-MSFT edited

Hi @AykutKaraca-8169,

Per my test, when we update Multiple lines of text column multiple times, it will show version limit+1 entries.

After that, every time the column is updated, the oldest entry will be deleted in turn.


If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.