Unanswered

Get Items Filter Query Not Pulling Dates Correctly from SharePoint List

(0) Share

Report

Posted on by kmaack

I have a flow that I want to pull data from a SharePoint list that are from a specific department, status is approved, and from the previous month. However, I can't get the filter query in the get items to pull all the records. I used the below today and it pulled almost the entire month of April except all records from April 30 and all but one record from April 29. I can't figure out why it didn't pull all from the date range.

Below is what I am using. The first "formatDateTime" is the following expression: formatDateTime(startOfMonth(getPastTime(1,'Month)),'M/d/yyyy')

The second "formatDateTime" is the following expression: formatDateTime(startOfMonth(utcNow()),'M/d/yyyy')

I plan on having this flow scheduled to run the first of every month to pull the data from the SharePoint list meeting the filter for the previous month.

I tried reading a few others posts, but they either were not quite the same or I didn't follow it.

Thanks!

I have the same question (0)

All responses (3)

Answers (0)

PowerAppsWizard 388 on at

Like (0)

Report

Re: Get Items Filter Query Not Pulling Dates Correctly from SharePoint List

Hi
one first thought, Is the date format correct?
You should check the sharepoint returned date format and them format the utcNow with the same format.

Was this reply helpful? Yes No
kmaack 39 on at

Like (0)

Report

Re: Get Items Filter Query Not Pulling Dates Correctly from SharePoint List

Hi @PowerAppsWizard

I believe it is! I did check how the dates were appearing in my SharePoint list date column and they show as m/d/yyyy. Below is a screenshot of a couple dates from the list.

Was this reply helpful? Yes No
kmaack 39 on at

Like (0)

Report

Re: Get Items Filter Query Not Pulling Dates Correctly from SharePoint List

Is my issue actually related to the limit that can be pulled for the get items action? I came across this when researching for a different issue I am having with a different flow. I believe I only have a standard license.

https://powerusers.microsoft.com/t5/General-Power-Automate/Power-Automate-Limit-with-SharePoint-List/td-p/1296052#:~:text=The%205000%20item%20limit%20applies,you%20have%20a%20standard%20license.

Was this reply helpful? Yes No