cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
NikTan
Level: Powered On

Get Item SharePoint Filter Query Issue

Hi Team,

I am using Get Iteam method to retrun the approval name from SharePoint List

To filter out the result i am sending Department Name and Role to Query filter , but i am facing issue while query filter

 

I am using below query 

 

Department eq 'Design Admin' and Role eq 'HRReview'"

 

And i am having below sample data in SP list 

 

Depatment Name
1. Design Admin

2. Design Admin SG

3, Design Admin NG

 

because of that it returns me 3 set of records instage of one .

can you please help me to resolved this issue.

11 REPLIES 11
Highlighted

Re: Get Item SharePoint Filter Query Issue

Hi @NikTan,

 

Use this:

 

Department eq 'Design Admin' and Role eq 'HRReview'

 

Issue : your query is having extra quote at end

 

Also, confirm if it is "Department"  or "Department Name" to be added in query.

 

Regards,

Chandrashekhar,

Pune, India

 

 

NikTan
Level: Powered On

Re: Get Item SharePoint Filter Query Issue

Hi chandrashekhar,

Thanks for reply.

Its copy paste issue in forrum but in my acitivty it is 

Department eq 'Design Admin' and Role eq 'HRReview' like this only

 

And column name is Department.

Still i am getting mutiple records. Please help 

Re: Get Item SharePoint Filter Query Issue

Hi @NikTan ,

 

please share the screen shot of flow step.

 

 

Regards,

Chandrashekhar

NikTan
Level: Powered On

Re: Get Item SharePoint Filter Query Issue

Please find below screenshot 

 

Capture.PNG

NikTan
Level: Powered On

Re: Get Item SharePoint Filter Query Issue

Please find below screenshot 

 

Capture.PNG

Re: Get Item SharePoint Filter Query Issue

Hi @NikTan,

 

The query seems correct:

 

Please cross-verify following things:

1. "Department Name"  and "HRReview" names are correct and use internal of columns. Since it is highly case sensitive. "RR" can make a difference in "HRReview"

2. Please check in list  by filtering on this two values, may be there are mutiple records satifying the and condition.

 

Please revert. if still the issues exists, then we can use "Send an http request to Sharepoint" action provided by flow.

It is also simple to use and provides filtered data with mutiple filter conditions.

 

Regards,

Chandrashekhar

Community Support Team
Community Support Team

Re: Get Item SharePoint Filter Query Issue

Hi @NikTan,

 

Please share more details about the "Department" or the "Department Name" field and the "Role" field in your sharepoint list?

What is the type of the  "Department" or the "Department Name" field and the "Role" field?

 

Please share more details so we would try to provide a proper workaround for you.

 

Best regards,

Alice

NikTan
Level: Powered On

Re: Get Item SharePoint Filter Query Issue

Hi All,

Both Department And Role field is Single line of text. 

We had imported the data from excel to SharePoint List using Import From Spreadsheet option.

Please let me know if any other details required.

 

 

Community Support Team
Community Support Team

Re: Get Item SharePoint Filter Query Issue

Hi @NikTan,

 

I have made a test on my side and don't have the issue that you mentioned.

The screenshot of the sharepoint list as below:

Capture.PNG

 

The screenshot of the flow as below:

Capture.PNG

 

The flow would run successfully as below:

Capture.PNG

 

 

Please take a try to create a new list with the Department and Role field to see if the issue still exists.

 

 

Best regards,

Alice

NikTan
Level: Powered On

Re: Get Item SharePoint Filter Query Issue

Hi 

Michelangelo
Level: Powered On

Re: Get Item SharePoint Filter Query Issue

I know I am coming late to the game, but you need parantheses. 

 

(ColumnName1 eq 'Filter1') and (ColumnName2 eq 'Filter2')

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020.

thirdimage

Flow Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Users Online
Currently online: 142 members 3,641 guests
Please welcome our newest community members: