Answered

RowNumber in Collection per Category

(0) Share

Report

Posted on 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:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

WarrenBelz 154,945 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
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
Matt8 11 on at

Like (0)

Report
Copy link

Link copied!
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
Verified answer

CU-18081211-6 9,270 Moderator on at

Like (0)

Report
Copy link

Link copied!
@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 at

Like (0)

Report
Copy link

Link copied!

@gabibalaban

Thanks a lot!
It works like a charm.

Was this reply helpful? Yes No