0

I have a SharePoint list with around 100,000 items, and I have 5600++ items with a field named ExpiryDate = 7 June 2023

enter image description here

but when I defined the following Get_Items inside a manual flow (which get called from a scheduled flow) with this filter query, I only get one item out of 5600++ items!!.. any advice?

ExpiryDate eq '2023-04-22' or ExpiryDate eq '2023-05-08' or ExpiryDate eq '2023-06-07'

enter image description here

Any advice what is going on ? Now I have added an index to the ExpiryDate when I first created the list..

Here is the Get_Items settings

enter image description here

6
  • 1
    What is the data type of ExpiryDate column? Is it a string column or Date and Time column?
    – Harsh
    Apr 10, 2023 at 6:54
  • @Harsh it is a Date Only (without time) column type. thanks Apr 10, 2023 at 10:01
  • 1
    Try adding datetime just after the eq and let me know if that works.
    – Harsh
    Apr 10, 2023 at 11:41
  • @Harsh what i need to do exactly ? can you post the formula? Apr 10, 2023 at 11:53
  • 1
    Hi @microsoftdeveloperdesigner, Does below answer help you in any way? If yes, Please Upvote(^) & accept as an Answer as it helped you & it will help others with similar question in future. Apr 26, 2023 at 6:10

1 Answer 1

1

Try generating and using SharePoint REST API endpoint in Get Items action in Power automate flow like this:

https://****.sharepoint.com/sites/test/_api/web/lists/getbytitle('ListData')/items?$filter=(ExpiryDate ge datetime'2023-04-22T00:00:00Z' and ExpiryDate le datetime'2023-04-22T23:59:000Z') or (ExpiryDate ge datetime'2023-05-08T00:00:00Z' and ExpiryDate le datetime'2023-05-08T23:59:000Z') or (ExpiryDate ge datetime'2023-06-07T00:00:00Z' and ExpiryDate le datetime'2023-06-07T23:59:000Z')

Similar thread: Power Automate Filter query on created date column

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.