Availability of BigInt as an API only data type

Important

This content is archived and is not being updated. For the latest documentation, go to What is Microsoft Dataverse?. For the latest release plans, go to Dynamics 365 and Microsoft Power Platform release plans.

Enabled for Public preview General availability
Users, automatically - Mar 11, 2022

Business value

BigInt, also known as big integers, is a data type that is used to express very large numbers. Until now, BigInt was a system-only data type that was used to track the version number of table rows. Now BigInt is available to makers for use through API solutions.

Feature details

Many users of Microsoft Dataverse have the need to use the BigInt data type to:

  • Express DateTime with sub-second values
  • Use ID fields which contain long number values
  • Store and use very large numbers

The above mentioned use cases are now possible by creation of BigInt fields in the Power Apps maker portal to store those numbers and then use API calls to retrieve the data from the BigInt field. Canvas and model-driven app support will be available at a future date. This data type can be used with the existing Dataverse APIs, which are now open to the public.

See also

Using the right type of number (docs)