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:

Mobile App

All responses (2)

Answers (1)

AR-03090625-0 28 on at

Like (0)

Report

How to add dynamic row numbers to a gallery?

Hi WarrenBelz,

Thank you very much! It perfectly work.
Verified answer

WarrenBelz 146,645 Most Valuable Professional on at

Like (1)

Report
How to add dynamic row numbers to a gallery?

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