Can I convert a string (Autonumber column) to a whole number?

(0) Share

Report

Posted on by KingBrad

Hi,

I'm trying to get around a delegation issue by running a clear collect that brings data from the table in batches.

We have an autonumber ID column in the data, but this is stored as text/string, rather than a whole number.

If I try to, for example, find the max value of this column, it's not delegable because it's stored as text.

I want to create a second column that has the ID stored as a number. Is this possible?

Thanks,

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Ram Prakash Duraisamy 5,785 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hello @KingBrad,

Please find the screen shot below

For AutoNumber you can see the Text with Small image as ABC, so its confirmed that we can use only text field not a whole number

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.

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com

Was this reply helpful? Yes No
KingBrad 2 on at

Like (0)

Report
Copy link

Link copied!

Thanks for the help, but I still don't understand, how do I copy the number to the whole number field?

Was this reply helpful? Yes No
Verified answer

v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @KingBrad ,

You could try this formula to get the max number of your auto column.

First(SortByColumns(TestL15,"crba2_auto",Descending)).Auto

// crba2_auto is a autonumber column.

If you want to create a number column to copy the values .

You could try the formula :

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

In addition , if you don't want to use formulas in canvas , you could try the dataflow .

Best Regards,

Wearsky

Was this reply helpful? Yes No
AlexScharpé 35 on at

Like (0)

Report
Copy link

Link copied!

Hi,
Could you explain how you achieve the last part of your solution (Copy the Number to Whole Number field and Use it) ?
Thanks!

Was this reply helpful? Yes No
Bamwich 2 on at

Like (0)

Report
Copy link

Link copied!

I second this problem. Using the AutoNumber column to tack ID's is really difficult as it's borderline impossible to use in any If statements and other various functions because it cannot be compared to any other file type.

Was this reply helpful? Yes No