You’re offline. This is a read only version of the page.
79
Hi,
I need some assistance with numbering items in a gallery.
I have 2 tables in Dataverse:
Table 1: Application Table - Unique Identifier is Ticket Number
Table 2: Comments Table - Unique Identifier is Comment Number
Whenever a comment is captured, its updated with its corresponding Ticket number in the comments table.
I have a gallery in the comments page that displays all the comments posted for a specific ticket however, the reference numbers are non-sequential as the comments are posted on different dates and times for different tickets.
Please see below image:
The goals is to display the comment number in a sequential order within the gallery. I have used the approach in the article here however it's not as responsive as I would like it be when posting a new comment. Further to the above, it poses a different problem as the users can download the file in excel and then the sequence will be off again.
Is it possible to create a column within the comments table that will automatically assign a sequential comment number for display within the gallery?
Example (Sequence Number):
| Comment Id | Date Posted | Time Posted | Corresponding Ticket | Sequence Number |
| Comment - 1 | 2024/03/01 | 11:57am | Ticket-1 | 1 |
| Comment - 2 | 2024/03/02 | 12:00pm | Ticket-7 | 1 |
| Comment - 3 | 2024/03/03 | 12:04pm | Ticket-1 | 2 |
| Comment - 4 | 2024/03/04 | 01:00pm | Ticket-5 | 1 |
| Comment - 5 | 2024/03/05 | 03:00pm | Ticket-7 | 2 |
| Comment - 6 | 2024/03/06 | 09:00am | Ticket-5 | 2 |
| Comment - 7 | 2024/03/07 | 05:00pm | Ticket-1 | 3 |
| Comment - 8 | 2024/03/08 | 06:15am | Ticket-7 | 3 |
Any help will be appreciated
Regards,
Hi @RG1601 ,
My understanding of DataVerse autonumbers is that you can't partition them by another column, they just don't allow that level of complexity.
The simplest way to do this is to patch the Sequence Number value at the time the comment is submitted.
Better than doing a row-by-row evaluation every time you retrieve the comments for a ticket, and the correct sequence is available in a download of the data. The only thing this doesn't account for is renumbering if comments are deleted, if that is even a function you are implementing.
Hi @Jmanriquerios ,
Thanks for the feedback, could you elaborate a bit more on how this could be achieved?
Regards,
Hi @RG1601
You can use the autonumeric column in the dataverse, which is sequential and forms the number where the dataverse is not processed.
Autonumber columns in Microsoft Dataverse - Power Apps | Microsoft Learn
#1
mmbr1606
22
Super User 2025 Season 1
#2
stampcoin
17
#3
ankit_singhal
11
Super User 2025 Season 1
Share
Report
All responses (
Answers (
