I am trying to user a query to filter the results before fetching from a SharePoint list.
Have tried filtering afterwards using if conditions but the query only returns a limited amount of rows (100) and even if increased it doesn't help.
I am sure that, if the previous month filter is applied, then I would receive less rows than the limit, also I understand that this $limit or $top can be increased to a maximum 5000
Anyhow, the screenshot bellow should explain better what I am trying to achieve...
@VJR @Anonymous @Highboy @MichaelAnnis @Henrik_M
Hello @eraznus
This is a completely different approach than what you are trying to do, but have you tried execute an SQL query against SharePoint lists?
I've made a post on how to do that in the following thread.
I hope this is helpful to you.