Filtering SharePoint items

[BigStev]

Hi All....

I am trying to filter a SharePoint list. Have already Filtered in the (Get Items) as seen below. 

 This has aloud me to get the right row2 of items using a tracking number. But i would like to filter this even more by only getting the Column Name and the item value that eq to No.

My SharePoint list looks like this:

 There are No answers just not in this picture. 

If anymore information is need please let me know.

Thank you and happy flowing!!!!!!

[BigStev]

Hi @ScottShearer 

Please see this problem that I still have from yesterday, you showed me a way to filter but I still need your help. If you see the last post that I did I have my SharePoint list and flow filter pictures there to give more information.

Please help.....

[v-bacao-msft]

Hi @BigStev ,

You need to add multiple conditions in Filter Query. Like:

Best Regards,

[BigStev]

Hi @v-bacao-msft !!!!

Thank you for getting back to me.

I have tried the solution that you sent me.

Value is false

Value is No

The flow works if all the answers are eq 'No', but when I change one of the answers in the SharePoint list to 'Yes' the flow still shows successful but only gives me this as a output answer.

 Please see if I am not doing it right. I have created a smaller SharePoint list well I'm testing this.

 Please try and help me.

Thank you for your reply...

Happy Flowing!!!!

[v-bacao-msft]

Hi @BigStev,

If the type of these fields is Yes/No, please try the following configuration:

Best Regards,

[BigStev]

Hi @v-bacao-msft 

Thank you for taking the time to get back to me. I have tried filtering with the solution you gave me and it works if the values eq 'Yes', but as soon as I change a value from 'Yes' to 'No' I get this in the body:

 As you can see I get a successful run, but the SharePoint Body(Output) on gives a value:[].

I have tried 3 ways of editing my SharePoint columns.

I still get the same Output from SharePoint.

This is how i have filtered the SharePoint List

Please can you see my problem and give advice.

Happy flowing!!!!!

[v-bacao-msft]

Hi @BigStev ,

It is recommended that you set the field type to single line of text, and then you can use Intercom eq 'No'.

Another thing to note is that you need to get the internal name of the field first. You can run the Get items action without configuring Filter Query first. Check the Body to get the internal name of the field, you can also check the actual value of the field.

Add a space between the eq and the single quote to avoid unnecessary errors.

Best Regards,

[v-bacao-msft · Accepted solution]

Check this article to get more details about Filter Query:

OData Filter query in SharePoint Get items in Flow

[BigStev]

Hi @v-bacao-msft 

Thank you for helping!!!

Happy flowing

[BigStev · Accepted solution]

Hi all!!!!

Here is the final site i stopped at to get my answer.

https://sharepains.com/2018/04/20/microsoft-flow-getting-your-sharepoint-field-values/

Happy Flowing!!!!