Hi @jess . This is such an interesting use case.
So, the choice source “repeating group’s list of things” will always show all the results. It doesn’t filter the said results according to page number. So we will limit the results.
I assume since you have the repeating group as a fixed number of cells you have two icons/buttons: “Previous, Next” to go to the previous/next page of repeating group. [We will need them in a bit]
Now, we make a state for the repeating group : start (type: number, default value: 1).
Dropdown will have the choice source : Repeating group’s list of things: item from #repeating group’s start: items until #6
Explanation: We will start the list from the repeating group’s state till 6. If you have 5 as the fixed number of cells shown at a time, you can write here 5.
Now, we will add the workflow to update the state each time someone goes to next/previous page.
For previous button workflow:
show previous of repeating group > set state “start” of repeating group: value = repeating group’s start - 6
similarly for next button workflow:
show next of repeating group > set state “start” of repeating group: value = repeating group’s start + 6
At last, we will hide the previous button when repeating group is on first page, and hide the next button when repeating group is on last page.
Hope this helps!