You’re offline. This is a read only version of the page.
Announcements
Has any one sync SQL server "Rowversion -timestamp" datatype into Dataverse column?
We are looking for a best way to store SQL Server datatype "Rowversion -timestamp" into dataverse column.
According to this article "Column data types in Microsoft Dataverse (contains video) - Power Apps | Microsoft Learn" , bigint - timestamp might be the way, but creation of this column is only awailable through API only. Has any one have example how it can be done?
If Any one have any recommendation, please let me know.
You have two options, either perform an odata webapi request with a payload to create a new attribute:
https://learn.microsoft.com/en-us/power-apps/developer/data-platform/customize-entity-metadata
https://learn.microsoft.com/en-us/power-apps/developer/data-platform/webapi/create-update-entity-definitions-using-web-api
Or you can write some code e.g. in a console app, that consumes the current CrmSdk Core assemblies to add new columns to a table:
https://learn.microsoft.com/en-us/dotnet/api/microsoft.xrm.sdk.messages.createattributerequest?view=dataverse-sdk-latest
https://learn.microsoft.com/en-us/dotnet/api/microsoft.xrm.sdk.metadata.bigintattributemetadata?view=dataverse-sdk-latest
Share
Report
All responses (
Answers (
232
