Data table create error, max char limit

(0) Share

Report

Posted on by Tejaskumar

Hi team,

I'm facing below error while importing Excel file as a data table using the Import Data option under the Table menu.

My table column is already multi line text, though it is throwing an error of max 4k characters limit.

Multi line text char limit is as below,

So can someone help me understand if I'm missing anything here and advice.

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (0)

Nived_Nambiar 18,136 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Tejaskumar

I think you have to set the max character count field while setting up the column, for me it was 2000 characters present in that field by default , so we may need to adjust it accordingly

try and let me know if that works 🙂

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No
Tejaskumar 69 on at

Like (0)

Report
Copy link

Link copied!

Yes, this option is available, but I do not see it when creating a new table before publishing it. The option only becomes visible once the table is already created. I have already imported the table, which removed the rows containing characters exceeding 4k. Now, if I republish it, all the data gets duplicated. How should I handle this?

Was this reply helpful? Yes No
Nived_Nambiar 18,136 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Tejaskumar

Could you try uploading the rows whose characters > 2000 and see ?

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No
Tejaskumar 69 on at

Like (0)

Report
Copy link

Link copied!

Yes but before that I need to delete all rows from the table. Could not find any option under Table menu to delete all rows from a table

Was this reply helpful? Yes No
Nived_Nambiar 18,136 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Tejaskumar

See whether this helps !

https://powerusers.microsoft.com/t5/Microsoft-Dataverse/Delete-Records-from-Dataverse-efficiently/td-p/1475558

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No