Answered

Autonumbering - Only rows with this value?

(0) Share

Report

Posted on by mrstian89

315

I have a table in Dataverse with all my equipment, for different locations. I also use it as a log for keeping track of the equipment.

I have these columns to identify what type of row it is:

Location (Location 1 / 2 / ..)

DataType (Equipment / Log / ..)

I use a 12 digit autonumbering column to generate barcodes/QR-codes. But out of the box the autonumber column also gives a number to the "Log-rows".
I really just want DataType: Equipment to get a value in the AutoNumber column. Is this possible to achieve?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Drew Poggemann 9,287 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @mrstian89 ,

The Autonumber column is going to apply a number for every row, no ability to autonumber by a specific type of row. You could do the following as an approach:

1. Create a calculated column that is text based on the table

2. Set the value of this field based on whatever logic you have, example, set only if "Equipment" as the data type and set to empty string otherwise. I did with this type of calculation on the field, see below

3. With this approach it set the values for the ones that I had only as "Time and Material" and kept others blank. Note, it does keep incrementing so the numbers will be spaced vs. sequential. In the screen shot below the Name field is setup as AutoNumber...

Hope this helps. Please accept if answers your question or Like if helps in any way.

Thanks,

Drew

Was this reply helpful? Yes No
mrstian89 315 on at

Like (0)

Report
Copy link

Link copied!

Didn't know about this option, but it doesn't quite do what I want to.
Is there any way to have a solution which will give me sequential numbering?

Was this reply helpful? Yes No
Drew Poggemann 9,287 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

HI @mrstian89 ,

I don't know of a solution that would keep the numbers sequential unless you separated the tables and Kept Equipment isolated from Log...

Thanks,

Drew

Was this reply helpful? Yes No