RowNumber in Collection per Category

Like (0) Share

Report

Posted on 3 Feb 2024 10:38:19 by Matt8

Hello,

first of all I want to thank all the people writing in this place. I have learned so much since I started with PowerApps one year ago.

There is one problem I have, I did not found a solution in the internet.

I have a simple Collection with 3 columns, in the example I use Company and Model, plus an added RowNumber column.

I would like to use a RowNumber starting with 1 for each Company.

Company	Model	RowNumber ByCompany
Ford	F150	1
Ford	Edge	2
Ford	Ranger	3
Ford	P100	4
BMW	Z1	1
BMW	321	2
Honda	Accord	1
Honda	Civic	2
Honda	S2000	3

It is no problem for me to add a RowNumber of all records (1, 2, 3, 4, 5, 6, 7, 8, 9) in the Collection.

But this rank by Company gives me headache for 2 days now.

Can someone please help me?

Thank you

Matt

Categories:

General Questions

I have the same question (0)

All responses (4)

Answers (1)

Matt8 11 on 03 Feb 2024 at 14:34:45

Like (0)

Report

Re: RowNumber in Collection per Category

@gabibalaban

Thanks a lot!
It works like a charm.

Was this reply helpful? Yes No
Verified answer

CU-18081211-6 9,266 Moderator on 03 Feb 2024 at 13:15:47

Like (0)

Report
Re: RowNumber in Collection per Category

@Matt35 ,

Using your logic, the adapted formula should be:

With( {_records: CollectionName}, ForAll( _records, UpdateIf( CollectionName As baseTable, RowNumber = 0, { RowNumber: Max( Filter( CollectionName, Company = baseTable.Company ), RowNumber ) + 1 } ) ) )

Was this reply helpful? Yes No
Matt8 11 on 03 Feb 2024 at 12:14:05

Like (0)

Report
Re: RowNumber in Collection per Category

Hi Warren,

thanks for your quick response.

Guess I expressed myself wrong.

The data I collect are only two columns:

Company Model
Ford F150
Ford Edge
Ford Ranger
Ford P100
BMW Z1
BMW 321
Honda Accord
Honda Civic
Honda S2000

While collecting, I am adding a "RowNumber"-column with value 0

ClearCollect(CollectionName, AddColumns(ListName, "RowNumber", 0))

The current situation after collecting is as below:

Company Model RowNumber
Ford F150 0
Ford Edge 0
Ford Ranger 0
Ford P100 0
BMW Z1 0
BMW 321 0
Honda Accord 0
Honda Civic 0
Honda S2000 0

Now my wish is to fill the RowNumber column as marked in my first post in blue.
I would need the RowNumber for later use.

I can use below code to get RowNumbers +1 for each record (1 to 9 in this example):

With( { _records: CollectionName }, ForAll( _records, UpdateIf(CollectionName, RowNumber = 0, {RowNumber: Max(CollectionName, RowNumber)+1}) ) )

But I did not found a way to achieve the goal I have, generating a RowNumber by "Company".

It would be great if there will be a possibility.

Kind regards
Matt

Was this reply helpful? Yes No
WarrenBelz 150,917 Most Valuable Professional on 03 Feb 2024 at 11:08:28

Like (1)

Report
Re: RowNumber in Collection per Category

Hi @Matt35 ,

Do you simply want each company in RowNumber Order ?

SortByColumns( ListName, "Company", SortOrder.Ascending, "RowNumber", SortOrder.Ascending, )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No