MultiSelect Lookup Query for empty selections in Sharepoint Lists

(0) Share

Report

Posted on by jimi_hendrix

Honestly dont know what Im doing wrong here and the use case doesn't seem to be documented anywhere that I've found..

I have a multiselect lookup field that I would like to perform a filter on in the "get items" SharePoint connector. The filter query i have to filter for columns that contain something works... "Multiselectcolumn/Title eq 'getthisvalue'" but when replacing 'getthisvalue' with null or '' or 'null' doesnt yield the right results if the script even runs.. Any advise would be greatly appreciated.

I have the same question (0)

All responses (1)

Answers (0)

Rhiassuring 8,690 Moderator on at

Like (0)

Report

Re: MultiSelect Lookup Query for empty selections in Sharepoint Lists

Hi there @jimi_hendrix, love your music.

I just tried this out, and got the expected results.

Here's my data:

Here's my query:

And the result I got was only for ID 11, as expected.

Can we see a screenshot of your flow? It's weird that it's not working - it sounds like you're doing it right!

R

Was this reply helpful? Yes No