ODATA filter query for Get Items from Sharepoint list

(0) Share

Report

Posted on by CU25091742-0

I have a Sharepoint list for which I want to filter based on a comparison of two fields. I’d like to retrieve records for which the Title field does not match the DisplayName of a person field called Building_Monitor. Building_Monitor does not allow multi-selects.

The filter works if I compare either of these fields to a literal:

Title ne ‘Doe, John’

Building_Monitor/Title ne ‘Doe, John’

It does not work, however, if I try to compare the two.

Building_Monitor/Title ne Title

Title ne Building_Monitor/Title

These both produce the error “Fetching items failed. Possible invalid string in filter query.”

What’s the correct syntax for such a search?

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Levbert 28 on at

Like (0)

Report
Copy link

Link copied!

looks to be a limitation in power apps

you might have to use filter action

1 people found this reply helpful.

Was this reply helpful? Yes No
Ram Prakash Duraisamy 5,866 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Here you are comparing field with field Title ne Building_Monitor/Title in OData you can compare field with Value that's restriction.

Please mark as answer if my suggestion helps.
Subscribe here for More Useful videos : https://www.youtube.com/@rampprakash3991

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

developerAJ 4,763 on at

Like (0)

Report
Copy link

Link copied!

I understand you’re doing this in the Power Automate Get items action. Unfortunately, it doesn’t support dynamic comparisons — you can only compare a column with a static value, not with another column. In such cases, the ideal approach is to filter out the static conditions first, and then use a Filter action to compare the columns

If this solution helped you resolve your issue, kindly mark it as accepted — it makes it easier for others to find and also closes the discussion. If you found it useful, a Like ❤️ would be greatly appreciated!

🤝 Let’s connect on LinkedIn || 📘 Explore more on my articles

1 people found this reply helpful.

Was this reply helpful? Yes No
WarrenBelz 155,575 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @CU25091742-0,

I will add that you can do this directly in Power Apps, however you are going to have Delegation restrictions as it will only act on the first Data Row Limit of your list
With( {_Data: SPListName}, With( { _Match: Filter( SPListName, Building Monitor'.DisplayName = _Data.Title ) }, Filter( _Data, !(ID in _Match.ID) ) ) )

Was this reply helpful? Yes No
developerAJ 4,763 on at

Like (0)

Report
Copy link

Link copied!

Following up to check if the issue has been resolved. I hope the suggestion helped:

‘I understand you’re doing this in the Power Automate Get items action. Unfortunately, it doesn’t support dynamic comparisons — you can only compare a column with a static value, not with another column. In such cases, the ideal approach is to filter out the static conditions first, and then use a Filter action to compare the columns.’

If this resolved your issue, please go ahead and close the thread.

If this solution helped you resolve your issue, kindly mark it as accepted — it makes it easier for others to find and also closes the discussion. If you found it useful, a Like ❤️ would be greatly appreciated!

🤝 Let’s connect on LinkedIn || 📘 Explore more on my articles

Was this reply helpful? Yes No
developerAJ 4,763 on at

Like (0)

Report
Copy link

Link copied!

Please let us know if the issue still exists. If it has been resolved, kindly close the thread by accepting the solution

If this solution helped you resolve your issue, kindly mark it as accepted — it makes it easier for others to find and also closes the discussion. If you found it useful, a Like ❤️ would be greatly appreciated!

🤝 Let’s connect on LinkedIn || 📘 Explore more on my articles

Was this reply helpful? Yes No