web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / How to fix the minimum...
Power Apps
Unanswered

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

(0) ShareShare
ReportReport
Posted on by Sakuraa 16

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:
Error handling
I have the same question (0)
  • Parvez Ghumra Profile Picture
    Parvez Ghumra 1,579 Moderator on at

    @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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Vish WR Profile Picture

Vish WR 936

#2
Valantis Profile Picture

Valantis 604

#3
11manish Profile Picture

11manish 518

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans