cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ashnalin2020
New Member

OData filter query is not working except Title field of SPO list even filter criteria for other columns are correct.

Hi,

 

I am writing flow for getting filter data from sharepoint list and by default required field - 'Title', when I am applying filter criteria with this Title column then it is working perfectly. But when applying filter criteria with other column names then getting array blank with no results.

 

Working flow and getting result with this filter condition as expected:

Working flow.JPG

 

But this filter condition is not working. Only updating with new filter condition. Nothing changing except filter condition with valid column name. Here is the flow:

 

Not working flow.JPG

 

Getting output result with blank array even having data in our list:

Not working flow result.JPG

Thanks in advance. Any help will be appreciated.

 

 

 

 

4 REPLIES 4
gabibalaban
Dual Super User
Dual Super User

Hi @ashnalin2020,

I'd bet on a little spelling mistake something like 'pending' or a suplimentary space ... The syntax is correct. 

 

Hope it helps !

Hi @gabibalaban 

 

Sorry. But there is no spelling mistake. The text has mentioned there was as it is I am having inside my SharePoint list. Yes I know the syntax is correct but getting me and no result values.

 

Any help will be appreciated!

 

 

 

vernariesaco
Frequent Visitor

I am having the same issue with OP. I can't find the solution! 😞

@vernariesaco ,

When you mean Status column are you talking about the Approval Status column (sharepoint's native column) used when you activate the versioning ?

The ODATA query for this is:

OData__ModerationStatus eq statusValue

where  statusValue can be 0 - for approved items, 1 - for rejected items, 2 - for pending items.

 

You can receive the result using Sharepoint - Get Items or Sharepoint - Send a HTTP request.

gabibalaban_0-1652945452998.png

Hope that is what are you looking for !

 

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

Carousel_PP_768x460_Wave2 (1).png

2022 Release Wave 2 Plan

Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (3,030)