Answered

Row number in Dataverse table.

(0) Share

Report

Posted on by mdrapala

Hi everyone,

I have model-driven application where users fill data's in main form (Table A) and in subrid form (Table B). There is a relation One to Many between these tables. Table A store documents and Table B stores lines of my documents. When users is adding lines in subrid I would like to have a row number of each lines in the document context. For example :

Table A ( Number, Description, Value ) -> Table B (Number - related field, Row number, Description lines, Value)

Table A (01/01/2022, "test", 1000) -> Table B (01/01/2022, 1, "test line 1", 500), Table B (01/01/2022, 2, "test line 2", 500 ).

In next new document the counter in Table B should start from 1.

Is it possible to do it in dataverse or in model-driven form ?

Will be greatfull for any informations.

Regards,

Maciej

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Drew Poggemann 9,287 Most Valuable Professional on at

Like (1)

Report
Hi @mdrapala ,

The autonumber field will not be able to accomplish this approach because it is a global number across the entity so in your table B it would not reset each row which is not want you want. Just wanted to identify why this would be out of consideration as an approach.

The method I have used in the past here is the following. This is not perfect because if you allow delete you will have gaps in your numbers and you might have to create a flow that will loop through the values and reset if needed when you delete a row.

Approach:

Table A - Add new whole number column that is called something like "Max Line". When you create the record, default this value to 0.

Table B - Add new whole number column that would be called "Line Number" or something like that.

Create a real-time workflow on creation of record in Table B that will do the following:

Set Line Number to Table A Max Line + 1

Increment Table A Max Line column

Again this will provide the functionality you need but it will have an edge case where if you delete a line in Table B you will have a gap and then maybe you could write a flow on the delete of the record from that table that would loop through all the lines and re-number which should be pretty easy to do. Just make sure you run this with a max of 1 at a time so you don't have two running stepping on each other (i.e. if you delete multiple lines).

Was this reply helpful? Yes No
mdrapala 35 on at

Like (0)

Report

Hi @dpoggemann,
thank you for showing me a workaround for this case 🙂 I regret that in model-driven we don't have ootb function to count rows, but maybe in future Microsoft will improve it.

Kindest Regards,
Maciej

Was this reply helpful? Yes No