web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Best way to store ID i...

Power Apps

Answered

Best way to store ID in dataverse

(0) Share

Report

Report

Posted on by PowerUser666

7

Hello.

What is the best way to store ID in dataverse?

For example, usually I am using INT in SQL, or autonumber ID usual field in Sharepoint.

But in dataverse we have Autonumber and why it is text field? How I can change it to number?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

a33ik 3,306 Most Valuable Professional on at

Like (1)

Report

Hello,

Autonumber is of the type of string because it's possible to add letters to it as a prefix and postfix and/or trailing zeros that won't be possible to add as a number so the string is the only type.

If you want to have it as a number you can add some kind of automation (plugin or power automate flow) that will take the generated number and copy it to the whole number field.

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com on at

Like (1)

Report
Hi @PowerUser666,

It is by desin, autonumber columns are formally just text columns.

If you want to use an Whole Number field for AutoNumber you can Create a new Field with Text (AutoNumber) and Copy the Number to Whole Number field and Use it.

Try the following formula to copy automate column value to whole number column:

ForAll(AddColumns(Sequence(Value(First(SortByColumns(Table,"crba2_auto",Descending)).Auto)),"CC",Text(Value)) As A,Patch(Table,LookUp(Table,Auto=A.CC),{Number:A.Value}))

crba2_auto is a autonumber column.

Was this reply helpful? Yes No

Join the conversation