Skip to main content

Notifications

Power Automate - General Discussion
Answered

Get Items SharePoint Connector not returning any value if date field is null

(1) ShareShare
ReportReport
Posted on by 47

I have a flow that gets all items from a SharePoint list, there are 5 items on this list at the moment. I've a condition that checks if the "scheduleddate" is null and if it is sends an email.

However, any record that has not been scheduled yet does not contain a scheduleddate attribute in the JSON, is this a recent change or is something unexpected happening?

Below is a document search result from pasting the JSON body into Notepad++, you'll see there are 4 hits, despite the body containing 5 root items.

tidedbryant_0-1720525702814.png

The screenshot below identifies 5 items being read from the list.

tidedbryant_1-1720525752621.png

Here are the parameters (redacted any unnecessary information)

 

 

 

 

 

 

{
 "dataset": "siteURL",
 "table": "tableID",
 "$filter": "Status ne 'Closed'"
}

 

  • Verified answer
    tidedbryant Profile Picture
    tidedbryant 47 on at
    Re: Get Items SharePoint Connector not returning any value if date field is null

    I enabled pagination and re-ran the test which then ran correctly, I removed pagination and re-ran (as there are only 5 records) and it still ran correctly. Assume user error. Closing this, thank you for your efforts @SanmeshG

  • SanmeshG Profile Picture
    SanmeshG 1,938 on at
    Re: Get Items SharePoint Connector not returning any value if date field is null

    Hi @tidedbryant ,

     

    Can you turn on the pagination and set the limit to 5000 and run the flow?

     

    By default the Get Items action returns only 100 items from the list. It could be that the items with the status value that you are trying to filter is over 100 items.

     

    Hope this helps!

     

    Thanks,

    Sanmesh

  • tidedbryant Profile Picture
    tidedbryant 47 on at
    Re: Get Items SharePoint Connector not returning any value if date field is null

    Hi @SanmeshG,

     

    I've verified the filter is set to Use all columns (do not limit)

    tidedbryant_0-1720528160696.png

     

    Pagination is off, but there are only 5 items on the list and the attribution isn't that large. The body is 518 lines in total.

  • SanmeshG Profile Picture
    SanmeshG 1,938 on at
    Re: Get Items SharePoint Connector not returning any value if date field is null

    Hi @tidedbryant ,

     

    If you filter in the SharePoint list (In All Item View) does it show items ?

     

    Have you checked the Pagination settings ? Can you set it to 5000 and check?

     

    If this helps , please give this a thumbs up and mark this as a solution.

     

    Thanks,

    Sanmesh

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,636

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,942

Leaderboard