GET ITEMS | 8 COLUMN FILTER QUERY

(0) Share

Report

Posted on by MotionMan

Hello all, Struggling to get this to work, not sure why...

Help 2.jpg Help 1.png

Am I missing something? Not had to do this for as many as 8 columns before - but we're trying to capture a rare occurance.

Thanks

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

v-bacao-msft on at

Like (0)

Report

Hi @MotionMan,

First, we can only configure the normal string type, Date or Number type fields in Filter query.

We cannot use fields like Lookup, Person, or Choice.

In addition, if there are common String type fields, you need to add single quotes outside the judgment condition.

I noticed that the single quotes you configured do not seem to be single quotes in English. Please adjust the input method to the state of entering English, and then reconfigure the Filter query.

Please take a try.

Best Regards,

Was this reply helpful? Yes No
MotionMan 14 on at

Like (0)

Report

Hi Barry,

Thanks for your input - my fields are single lines of text and definitely not multiple choice, so all good there.

Cannot seem to work out what you mean by single quotes in english? Or how to change input method to the state off entering english.. is that a Flow option or..?

Single quotes outside the judgement condition... which one is the judgement condition? Sorry for my naievity - still learning.

Many Thanks,
Ollie

Was this reply helpful? Yes No
Verified answer

v-bacao-msft on at

Like (0)

Report
Hi @MotionMan,

You should have used ‘’ single quotes before.

The single quotes should be used '' .

I don't know if you can see the difference.

It is recommended to write the formula directly in Filter array instead of copying it from Notepad or other editors.

Try using this formula in the Filter query:

vk0i eq 'Yes' and dm9h eq 'Yes' and wgbx eq 'No' and ax6m eq 'No' and OData_x0061_xr8 eq 'Yes' and y31a eq 'Yes' and tjut eq 'No' and hk8k eq 'Yes'

Please take a try again.

Best Regards,

Was this reply helpful? Yes No