Filter Query GetItems Issue

(0) Share

Report

Posted on by NikTan

100

Hi Mates,

I am trying to featch records from SharePoint List using GetItems

I would like search on department and Designation. I would like to get Manager and Supervisor records. my query is like below but its not working its returing 0 records

Department eq 'A' and Designation eq 'Supervisor' and Designation eq 'Manager'

please let me know where i am doing mistake.

Thanks in Advance

Categories:

General topics

I have the same question (0)

All responses (7)

Answers (1)

ScottShearer 25,280 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Can you tell me what type of columns are department and designation?

Was this reply helpful? Yes No
NikTan 100 on at

Like (0)

Report
Copy link

Link copied!

Hi Scott,
Both the column have singe line of text data type

Was this reply helpful? Yes No
v-yamao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @NikTan,

I am afraid that it is not possible to filter one column twice at the same time. If you have two columns, say Designation1 and Designation2, then the code should work as expected.

I have made a test using the following code and it works fine.

Department eq ‘A’ and Position eq ‘Manager’ and Position1 eq ‘Supervisor’

Best regards,

Mabel Mao

Was this reply helpful? Yes No
NikTan 100 on at

Like (0)

Report
Copy link

Link copied!
Hi Mabel,
I dont have two columns, I have only one column on which i need to filter the records
As below.
Department eq ‘A’ and Position eq ‘Manager’ and Position eq ‘Supervisor’
is there any alternative solution for such kind of query

Was this reply helpful? Yes No
v-yamao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @NikTan,

What’s the exact column name?

Could you share a screenshot of your list structure? It will be better for understanding.

Best regards,

Mabel Mao

Was this reply helpful? Yes No
Verified answer

NIchageri 7 on at

Like (0)

Report
Copy link

Link copied!
Position Cannot have 2 values at the same time.
Try something like-
Department eq ‘A’ and (Position eq ‘Manager’ or Position eq ‘Supervisor’)

Was this reply helpful? Yes No
ScottShearer 25,280 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@NikTan:

The syntax proposed by @NIchageri will work for you:
I created a test Flow with the following filter than ran successfully:

However, you will probably want to convert the columns on which you are filtering to choice columns. If you are using free text columns, it is unlikely that your users will enter data consistently. Therefore, the results of the filter may not be as you expect. For example, some may enter Manager and other MGR.

Scott

Was this reply helpful? Yes No