Answered

How to add dynamic row numbers to a gallery?

(1) Share

Report

Posted on by AR-03090625-0

Hello,

I have a gallery (Gallery4_1) filtered from another gallery (BrowseGallery1_3) and I need to add row numbers to the last filtered gallery (Gallery4_1) which is dynamic depending on what the user select from the options given. Below is the code which I need to add extra code for a dynamic serial number (Label3_5).

First Gallery Name is BrowseGallery1_3

Last Gallery Name is Gallery4_1

Sort(Distinct(Filter(StaffMain, ActiveStat=false, Status2="Cadre",Section=Dropdown1_8.SelectedText.Value || Dropdown1_8.SelectedText.Value=Blank(), Nationality.Value=Dropdown1_12.SelectedText.Value || Dropdown1_12.SelectedText.Value=Blank()), Nationality.Value),ThisRecord.Value, SortOrder.Ascending)

Row Number needed for Label3_5

Can anyone help me?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

WarrenBelz 153,073 Most Valuable Professional on at

Like (1)

Report
Hi AR-03090625-0

Try this - ThisItem.RowNo will be the Label Text
With( { _Data: Sort( Distinct( Filter( StaffMain, !ActiveStat, Status2 = "Cadre", Section = Dropdown1_8.Selected.Value || Len(Dropdown1_8.Selected.Value) = 0, Nationality.Value = Dropdown1_12.Selected.Value || Len(Dropdown1_12.Selected.Value) = 0 ), Nationality.Value ), ThisRecord.Value, SortOrder.Ascending ) }, ForAll( Sequence(CountRows(_Data)), Patch( Index( _Data, Value ), {RowNo: Value} ) ) )

Please click Does this answer your question 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 a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee

Was this reply helpful? Yes No
AR-03090625-0 28 on at

Like (0)

Report

Hi WarrenBelz,

Thank you very much! It perfectly work.

Was this reply helpful? Yes No