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.