Power Automate Filter query on created date column

Question

I have a big document library has documents for than one lakh in it. I am trying to get all documents created in certain months in year, let's say I want to get all documents created in the month of April '2021' In the Power Automate Odata filter query, how we can we add this as filter query.

Similarly, in the SharePoint Online document library - want to create a view for this filter. What will be filter criteria for this?

Answer 1

For SharePoint out of the box view in document library, use filter conditions like this:

---

For Power Automate flow, use filter query like:

Created ge datetime'2021-04-01T00:00:00Z' and Created le datetime'2021-04-30T00:00:00Z'

Source: Filter Created in SP REST API

Also,

1. Set Top Count of "Get items" action to 5000
2. Enable pagination from settings of "Get items" action and set pagination threshold more than 10000.
3. Add indexing on "Created" column from library settings

Top Count:

Pagination settings: