How to rest to page 1 if we search some text in the component?

[sspk]

Hello Team,

I have a pagination and i traversed to page 4 and entered a keyword AI and clicked search button. Now page 4 shows empty result in table and bttom it shows correctlt as Page 1 of 3. So if there is no value it has to redirect or jump to page 1.

Thanks and Regards,

Siva

[v-kpoloju-msft]

Hi @sspk,  

Thank you for reaching out to the Microsoft Fabric Community Forum. Also, thanks to @rohit1991, for his inputs on this thread.

The behaviour you are seeing happens because the table’s pagination does not automatically reset when you apply a search/filter. So, if you are on a page that has no matching results, it will show empty even though the total pages are correct. To fix this, you can reset the table to page 1 whenever a search is performed. Here’s a general approach:

Store the search keyword when the user clicks the search button. Apply the filter to your data source. Reset the pagination variable (or current page) to 1. Render the table/gallery with the filtered data and reset page. This ensures the user always sees data starting from the first page after a search.

If you are using Power Apps, you can implement it with Set(CurrentPage,1) and update your gallery items accordingly. For web/HTML tables, you can reset the currentPage variable in your search function before rendering the table again.

Refer these links:
1. https://learn.microsoft.com/en-us/power-bi/visuals/paginated-report-visual 
2. https://learn.microsoft.com/en-us/power-bi/paginated-reports/paginated-reports-report-builder-power-... 
3. https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-filter-lookup 

Hope that clarifies. Let us know if you have any doubts regarding this. We will be happy to help.

Thank you for using the Microsoft Fabric Community Forum.

[sspk]

Hi @v-kpoloju-msft , @rohit1991 ,

Thank you for your reply. Text Filter Search is a Component with inbuilt Search icon availabl;e.If i add an external button like below image , when i am in page 5 and i would like to search keyword AI in the below Table result. If i type AI and click the external button , Action Type bookmark and reset to page 1. But search operation will not perform here and the value in the text box is cleard.

Search operation fails here.Strange.

I am using the Component called "Text Filter". This componenet does no t have any action setting option.

It has only below options only,

Thanks nad Regards,

Siva

[v-kpoloju-msft · Accepted solution]

Hi @sspk,
Thank you for sharing the additional details and screenshots they really help clarify the scenario.

From what you described, the issue occurs because the Text Filter component applies the filter internally when you use its built-in search icon, but your external button with a Bookmark action only resets the page state. By default, bookmarks capture the entire visual state, including filters, so when you click the button, it resets pagination but also clears the search value. That’s why the search does not execute, and the text box becomes empty. If you want the search keyword to stay and pagination to reset to page 1.

Adjust Bookmark Settings: When creating the bookmark, go to View → Bookmarks Pane → Options. Uncheck “Data” so the bookmark does not overwrite your filter values. Keep Display and Current Page checked to reset pagination.

Use the Built-in Search Icon: If possible, rely on the Text Filter’s built-in search icon. It applies the filter correctly and avoids clearing the value.

Alternative Approach: If you need the external button for user experience, combine it with the adjusted bookmark. This way, the button resets pagination without clearing the filter.

Hope that clarifies. Let us know if you have any doubts regarding this. We will be happy to help.

Thank you for using the Microsoft Fabric Community Forum.

[v-kpoloju-msft]

Hi @sspk,

Just checking in to see if the issue has been resolved on your end. If the earlier suggestions helped, that’s great to hear! And if you’re still facing challenges, feel free to share more details happy to assist further.

Thank you.

[v-kpoloju-msft]

Hi @sspk,

Just wanted to follow up. If the shared guidance worked for you, that’s wonderful hopefully it also helps others looking for similar answers. If there’s anything else you'd like to explore or clarify, don’t hesitate to reach out.

Thank you.

[rohit1991]

Hi @sspk 

1. When you search, the table sometimes stays on the old page (like Page 4) - that’s why it shows blank results.

2. The main reason is the pagination not resetting to the first page after a new search.

3. The correct fix is to set the page number back to 1 before showing the filtered results.

4. Add this reset step inside your search button click or “on change” event.

5. Once you reset the page to 1, run your search or API call to fetch data.

6. Then refresh or reload the table to display the new filtered records.

7. This ensures users always see the correct results from the first page.

8. It also prevents empty screens when switching between different searches.

9. Simple rule: Every new search >> reset page = 1 >> then load results.