I am still confused about Power Automate SharePoint "Get Items" action even after researching on the internet . So specifically if I have the following action on a list with more than 5000 items.
Will it only filter on the first 5000 items and return those that match or will it filter all the items but only return up to the first 5000 items where there is a match. All the columns in the filter are text.
My intention is that all the items should be checked against the filter criteria and those that match will be returned. I don't expect there to be ever more than 1000 that meet the filter criteria.
