Unanswered

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

(1) Share

Report

Posted on by tidedbryant

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.

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

Here are the parameters (redacted any unnecessary information)

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

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

SanmeshG 1,947 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No
tidedbryant 47 on at

Like (0)

Report

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)

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.

Was this reply helpful? Yes No
SanmeshG 1,947 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

tidedbryant 47 on at

Like (1)

Report

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

Was this reply helpful? Yes No