How to fix the minimum and maximum range of a column in Dataverse table

(0) Share

Report

Posted on by Sakuraa

Hi,

A column whose datatype is whole number and its minimum and maximum values are -2147483648 and 2147483647, after entering a number greater than this range it shows the following error:

Internal error in the Add Columns function: Core. Application Error: Connected Data Query String Builder Error Kind:8 Severity:3 Network error when using Patch function: Value must be between -2147483648 and 2147483647.

How can I solve this?

Categories:

Issue

All responses (1)

Answers (0)

Parvez Ghumra 1,579 Super User 2025 Season 1 on at

Like (1)

Report

Re: How to fix the minimum and maximum range of a column in Dataverse table

@Sakuraa You can't. This is a technical limitation on columns of Whole Number type. These are the minimum and maximum values you can set in Whole Number columns

One ugly workaround would be to use a Single Line of Text column instead and then apply some validation to it to only allow entry of numeric values and to format values correctly. You may run into problem when sorting records based on this column though. So I wouldn't recommend it