Odata filter query in Sharepoint Get Items connector dysfunctional

(0) Share

Report

Posted on by GG-29070657-0

I am using a simple Odata filter query in my Sharepoint Get Items connector. In my sharepoint list, there are only 3 dropdown values in my "Status" column. These values are either "Completed", "Not started", or "Ongoing". Using the Get Items connector in Power Automate, I am simply filtering values with "Not started".

I have used the help of Copilot and Microsoft Learn to create the Odata filter query expression. Not of it worked. I have used:

'Status/Value' eq 'Not started'
$filter = 'Status/Value' eq 'Not started'
('Status/Value' ne 'Completed') or ('Status/Value' ne 'Ongoing')
contains(Status/Value,'Not')
'Status' eq 'Not started'
$filter = 'Status' eq 'Not started'
('Status' ne 'Completed') or ('Status' ne 'Ongoing')
contains(Status,'Not')

Please help me resolve this issue. I simply do not know how to resolve this anymore I am losing my mind. This power automate flow is inside the same environment as the Sharepoint List so I don't understand how this is not working.

Please see attached screenshot of the error message.

Categories:

Using flows

I have the same question (2)

All responses (5)

Answers (0)

Michael E. Gernaey 53,969 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @GG-29070657-0

I'd prefer to see pictures of the Action and what you are typing, but do not put single quotes around field names.

For things that are Choices, use the Value, not the string to compare

If these suggestions help resolve your issue, Please consider Marking the answer as such and also maybe a like.

Thank you!
Sincerely, Michael Gernaey

Was this reply helpful? Yes No
GG-29070657-0 4 on at

Like (0)

Report
Copy link

Link copied!

Hello @Michael E. Gernaey,

Before your response I write them as this (like how I described in my post):

The corresponding error is shown in the screenshot I provided in my post.

After inputting your suggestions, I tried:

It now creates a different error:

I do not understand how this is possible because I am looking right at the sharepoint list and I do see the "status" column.

Please help me. I also attached a screenshot of the raw data showing "status".

Was this reply helpful? Yes No
GG-29070657-0 4 on at

Like (0)

Report
Copy link

Link copied!

Hello @v-yueyun-msft, I have seen your account answer many questions about Odata filter. May I get assistance from you please?

Was this reply helpful? Yes No
Suggested answer

UshaJyothiKasibhotla 225 Moderator on at

Like (0)

Report
Copy link

Link copied!

HI @GG-29070657-0

Here the correct way is
Status eq 'Not started'

However please check the internal name of the particular column name in Sharepoint

settings advanced click on the particular column and see the end part of the URL. that is the internal name of the column. sometimes that may be different with the display name.

please check

Hope this helps,

Usha

1 people found this reply helpful.

Was this reply helpful? Yes No
Michael E. Gernaey 53,969 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi

Just to be clear /Value is the number, not the text

Was this reply helpful? Yes No