Answered

Reset numbering in Power Apps (gallery)

(0) Share

Report

Posted on by Gerard__

Hi All!

I'm creating a Control Plan app (Process-Checklist Overview). The data I'm using comes from a SharePoint List and Library.

Info about the SP List Columns:
• Process info (Title)
• Process Step
• Process sub step
• Lookup column to find the corresponding Checklist in a SharePoint library.

My question:

The numbering in the SharePoint list is not sequential. See screenshot image as example:

In my app I have a gallery where I want to show all items with step and sub step.

However, the smallest step number should appear as Step 1. The next one is Step 2, and so on.

And if a step number appears more than once, I want to include the sub step.

Same story then goes for my sub step, Lowest number should be 1. The next 2, and so on.

Result from the included image should thus be: 1 -> 2.1 -> 2.2 -> 3.

So far I used the following, but that results in sequential numbering:

ForAll( Sequence(CountRows(CollAllChecklists_NoRowNumber)), Patch( Last(FirstN(CollAllChecklists_NoRowNumber, Value)), {RowNumber: Value} ) )

Anybody how can help me out?! Any help would be greatly appreciated!

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Verified answer

DJ_Jamba 2,837 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi @Gerard__

I recreated your example in a SP list and added a few more rows for testing.

Then I created a collection to display the gallery items in the way you wanted to see them. You can use that collection to display the gallery and/or update the source table.

Clear(col_RenumberSteps); ForAll( Sort( Filter( CLOverview, StepNumber > 0 ), StepNumber ), If( CountRows(col_RenumberSteps) = 0, Collect( col_RenumberSteps, { Title: Title, OrigStep: StepNumber, NewStep: CountRows(col_RenumberSteps) + 1, OrigSubStep: SubStep, NewSubStep: If( !IsBlank(SubStep), 1 ) } ), If( StepNumber <> Last(col_RenumberSteps).OrigStep, Collect( col_RenumberSteps, { Title: Title, OrigStep: StepNumber, NewStep: Last(col_RenumberSteps).NewStep + 1, OrigSubStep: SubStep, NewSubStep: If( !IsBlank(SubStep), 1 ) } ), Collect( col_RenumberSteps, { Title: Title, OrigStep: StepNumber, NewStep: Last(col_RenumberSteps).NewStep, OrigSubStep: SubStep, NewSubStep: CountRows( Filter( col_RenumberSteps, OrigStep = StepNumber ) ) + 1 } ) ) ) )

The result is this:
The values in the brackets are the original source values so you can see the correct renumbering.
Can you do anything with this?

Was this reply helpful? Yes No
Gerard__ 25 on at

Like (0)

Report
Copy link

Link copied!

@DJ_Jamba,

Thanks for your reply. This looks very promising. I'll give it a try and recreate this in my app.

For now I have one question:

Why are you filtering the SP list on StepNumber > 0? Just to exclude those that haven't been filled out?

Was this reply helpful? Yes No
Gerard__ 25 on at

Like (0)

Report
Copy link

Link copied!

@DJ_Jamba, it works like a charm! Thank you so much!

Was this reply helpful? Yes No
DJ_Jamba 2,837 Moderator on at

Like (0)

Report
Copy link

Link copied!

@Gerard__
Simply because it's bad practice to connect to a datasource without attempting some kind of filter

Was this reply helpful? Yes No
DJ_Jamba 2,837 Moderator on at

Like (0)

Report
Copy link

Link copied!

Awesome and you're welcome!
d(-_-)b

Was this reply helpful? Yes No