Announcements
Hello,
im trying to build an app right now were i have to fill in a form so it can be send to the dataverse. And after that the ID will be automaticly generated in the dataverse itself. Now here is my problem i need this id even before i send it to the Dataverse Table.
I hope i can get an answer fast
Best Regards
@TheFabonator First I believe you mean the ID of a newly created Record (row), not column. And the answer is No, the primary key of any data source including Dataverse cannot be found out before the record is created, as it does not exist at all yet. You must first create the record with the minimum info, retrieve it, then edit it further.The ID is also the name of the primary key in SharePoint List.
In Dataverse it is not called ID like in SharePoint List.
The primary key is of type GUID in Dataverse and it is usually the singular name of the Table in Dataverse.
If your Table is called Clients, the primary key column is usually named Client when trying to refer to that column in Power Fx.See if this helps @TheFabonator
Thx for the fast answer @poweractivate.As a follow up question is there a possibility to get the "ID" from a the most recently created row so i can just increase it by one?I know this isnt the optimal solution for my problem but it could help.
@TheFabonator
Dataverse creates GUID which is not sequential and is internal implementation.SharePoint Lists "ID" primary key automatically increment by 1 and are simple autogenerated numbers in sequence.
You cannot control the implementation of the primary key of either one, and in Dataverse it is not a sequential number.
If you want an autogenerated sequential number, Dataverse has an AutoNumber
It's a type of column you can use by adding it to the Table and it may suit your needs.
This is not going to be the "primary key" though, but it may be better than that and achieve what you want.
@TheFabonator After you create your AutoNumber column then you can Sort descending and then it should work, like this to get the highest autonumber:
First(SortByColumns(yourDataSource, "AutoNumberColumn", SortOrder.Descending))
See if it helps @TheFabonator
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 395 Super User 2026 Season 2
Mohsin Ali 328
WarrenBelz 260 Most Valuable Professional
