Hi @cdwhite , @WarrenBelz , All
Below is the piece of code for implementing page numbers in gallery. Currently the page number goes haywire when filter is selected as per screenshot below
Once i click on the first page icon (i.e. less than symbol), it resets back to normal as per below. May i know how to avoid Page 12 of 3 page(s)?
Main Gallery code
If(
icoNext_user.DisplayMode = DisplayMode.Disabled,
// Handling last set of records
LastN(
FirstN(
galHidden_user.AllItems,
drpPaginationSize_user.Selected.Value * varPageNumber_user
),
drpPaginationSize_user.Selected.Value - (drpPaginationSize_user.Selected.Value * varPageNumber_user - CountRows(galHidden_user.AllItems))
),
LastN(
FirstN(
galHidden_user.AllItems,
drpPaginationSize_user.Selected.Value * varPageNumber_user
),
drpPaginationSize_user.Selected.Value
)
)
Hidden Gallery Code
With(
{
_Data: Filter(
'Data Source',
(Len(ComboBox1_6.Selected.Value) = 0 || Er_Type.Value = ComboBox1_6.Selected.Value) && (Len(ComboBox1_7.Selected.Value) = 0 || Status = ComboBox1_7.Selected.Value)
)
},
SortByColumns(
Filter(
_Data,
(User().Email in Team_Members.Email || 'Created By'.Email = User().Email) && (Len(TextInput2_3.Text) = 0 || TextInput2_3.Text in Er_Type.Value || TextInput2_3.Text in Submission_Id || TextInput2_3.Text in 'Er Title' || TextInput2_3.Text in Team_Members.DisplayName || TextInput2_3.Text in Status||TextInput2_3.Text in Submission_Date)
),
varsortcolumn,
varsortdirection
)
)
Page Number Label Text Property
"Page " & varPageNumber_user & " of " & If(
Mod(
CountRows(galHidden_user.AllItems),
100
) = 0,
RoundUp( CountRows(galHidden_user.AllItems) / drpPaginationSize_user.SelectedText.Value ,0) & "+ pages",
RoundUp( CountRows(galHidden_user.AllItems) / drpPaginationSize_user.SelectedText.Value,0) & " page(s)"
)
Arrow Left OnSelect
Set(varPageNumber_user,varPageNumber_user-1)
Arrow Right OnSelect
Set(varPageNumber_user,varPageNumber_user+1)
Left icon (less than symbol) OnSelect
Set(varPageNumber_user,1)
Right icon (Greater than symbol) OnSelect
Set(varPageNumber_user, RoundUp( CountRows(galHidden_user.AllItems) / drpPaginationSize_user.SelectedText.Value ,0) )
