Dataverse Row ID

Like (1) Share

Report

Posted on 21 Oct 2021 11:00:38 by Saadssk94

Hello,

Ive been using PowerApps with SharePoint for 2 years now but now I'm building my first app using Dataverse.

the problem I'm facing while building this app is to get a Unique Identifier for each row to do my filters.

in SharePoint we had ID columns autogenerated for each row but in Dataverse I'm not finding any unique ID with i can filter my projects not by name but with a unique ID in canvas apps. I'm sure there's a very simple solution to this but I'm unable to find it on the forums or YouTube. maybe its because they have already changed the name of dataverse 3 times now 😄

if anyone understands this issue and is able to help out i will appreciate.

Thanks

Categories:

Connecting to Data

General Questions

Untitled.png

All responses (3)

Answers (1)

Verified answer

poweractivate 11,078 Most Valuable Professional on 21 Oct 2021 at 11:11:42

Like (1)

Report
Re: Dataverse Row ID

@Saadssk94 With filter you usually do not want to use GUID at all. Instead you want to use a field of your own to filter by,

For your use case I wonder if you want to add your own Autonumber Column to Dataverse Table if you wanted the auto incrementing number kind of field to use for some reason. See more info here:

https://docs.microsoft.com/en-us/powerapps/maker/data-platform/autonumber-fields
Autonumber columns are columns that automatically generate alphanumeric strings whenever they are created. Makers can customize the format of these columns to their liking, and then rely on the system to generate matching values that automatically fill them in at runtime.
While autonumber columns are formally just text columns with additional functionality built on top of them, Power Apps simplifies this concept by simply exposing Autonumber as a distinct data type under the Text category. It is important to note that the classic solution explorer doesn't support creating or managing autonumber columns.
To create an autonumber column, follow the same steps to create a column and simply select Autonumber from the Data type drop-down list box.
You may also activate autonumber functionality on an existing text column by opening the column and selecting Autonumber from the Data type drop-down list box. Similarly, autonumber functionality can also be disabled at any time by opening the column and selecting a different option in the Data type drop-down list box.

....
Create an autonumber column
Sign in to the Power Apps portal.
On the left pane expand Data and select Tables.
Select the table that you would like to add an autonumber column to and then select the Columns tab.
On the toolbar, select Add column.
On the right pane, enter a Display name and select Autonumber for the Data type.

Set optional columns as needed. More information: Create and edit columns
Select an autonumber type or keep the default String prefixed number option.
Customize a seed value or keep the default value of 1000.
Select Done.

Check if above might help @Saadssk94 .
Saadssk94 39 on 21 Oct 2021 at 11:08:57

Like (1)

Report

Re: Dataverse Row ID

Hi Thanks for such quick response @poweractivate

few questions

how do i use your solution within a filter?

is this the only way to get unique identifiers for a row? i dont understand why is it so difficult to use simple lookups and filters in dataverse.
poweractivate 11,078 Most Valuable Professional on 21 Oct 2021 at 11:03:28

Like (1)

Report
Re: Dataverse Row ID

@Saadssk94

Yes take the GUID like this check example below:

Text(First(Accounts.Account).Account)

This is the definitely unique identifier for the record of table generated by Dataverse if you really want it.
Check if it helps @Saadssk94