RowNumber in Dataverse

[Oskarkuus]

How can i create a rownumber column in a dataverse table?

[timl]

@Oskarkuus 

An autonumber column in Dataverse is one method you can use to generate row numbers.

https://learn.microsoft.com/en-us/power-apps/maker/data-platform/autonumber-fields

[Rajkumar_404]

Hi 

To create a row number column in a Dataverse table in PowerApps, you can add a new whole number column to the table and set its default value to 0. Then, you can use the ForAll and Patch functions to update the row number column for each record in the table. Here are the steps to create a row number column in a Dataverse table:

1. Open the table in the Dataverse designer.
2. Click on the "Add column" button to add a new column to the table.
3. Set the data type of the column to "Whole Number".
4. Set the default value of the column to 0.
5. Save the changes to the table.

Once you have added the row number column to the table, you can use the ForAll and Patch functions to update the row number column for each record in the table. Here's an example formula that you can use:

ForAll( 'Table Name', Patch( 'Table Name', ThisRecord, { 'Row Number': RowNumber } ) )

Thanks!

If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.

[Oskarkuus]

Well this forces me to update the rownumbers for the full table in powerapps.

Is it possible to just do it in dataverse, does dataverse have a autonumbering feature?

[timl]

@Oskarkuus -  As I mentioned in my post, Dataverse has an autonumbering feature.

[Oskarkuus]

Yes, i have tried that. But i dont get any data in that column.

Maybe that column only works for new rows, but what about rows that already exist?

Here i have that autonumber-column.

It generates number for "new rows".

But how can i force update all rows?

[Oskarkuus]

After allot of testing. It seems that a autonumber column only creates a number if a new row is created.

So i cant use that column for an existing table that already have values in it.

I then need to create a manual column and take the last record and do +1 to the rownumber.

i had hoped dataverse could handle this by itself instead of having to put in the extra code in every place that adds a record to the table.

i tried to generate a number in all existing rows in the table.

but when a new row was created, dataverse still started at 1 and not at the highest/latest value.