Unanswered

Get items connector does not return columns with a null value

(2) Share

Report

Posted on by CarlMurphy

I am using the Get items connector and I only want to bring back where a specific column has no value (as I need to populate it).

I've read various posts about ensuring the "Limit Columns by View" is set to "Use all columns..." and putting the Filter Query in brackets or without brackets but neither seem to help in this situation.

Below is my current Get items configuration:

This returns zero results and if I remove the Filter Query and look at the results I can see that the column name is correct and shows in the JSON when it is populated, however for those records where it is null it simply doesn't show.

My question is whether it is possible to retrieve a list of SP List items where a specific column is blank.

Thank you

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (0)

Keith-Sayer 48 on at

Like (0)

Report

What type of data is your field? This might affect whether you can use the null filter or not. I just tested this with a simple string field and it worked.

Was this reply helpful? Yes No
CarlMurphy 18 on at

Like (0)

Report

Thank you for your reply, it is a simple single line text column, nothing special about it - very strange.

Was this reply helpful? Yes No
Keith-Sayer 48 on at

Like (0)

Report

The other thing to try just in case it's storing a space or something is

eq ''

or

eq ' '

Was this reply helpful? Yes No
ankurbansal11 2 on at

Like (0)

Report

Have you got the answer to the query? I am facing same issue , the column with null values are not getting returned in the List Rows connector of Dataverse.

Was this reply helpful? Yes No