Answered

Is there a way to find the ID of a new created column before it is created?

(1) Share

Report

Posted on by TheFabonator

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

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

poweractivate 11,078 Most Valuable Professional on at

Like (1)

Report

@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

Was this reply helpful? Yes No
TheFabonator 68 on at

Like (1)

Report

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.
Best Regards

Was this reply helpful? Yes No
poweractivate 11,078 Most Valuable Professional on at

Like (1)

Report

@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.

Was this reply helpful? Yes No
Verified answer

poweractivate 11,078 Most Valuable Professional on at

Like (1)

Report
@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

Was this reply helpful? Yes No