cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BigStev
Helper I
Helper I

Filtering SharePoint items

Hi All....

I am trying to filter a SharePoint list. Have already Filtered in the (Get Items) as seen below. Screenshot 2020-07-15 08.28.08_LI.jpg

 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:

Screenshot 2020-07-15 08.27.44.png

 There are No answers just not in this picture. 

If anymore information is need please let me know.

Thank you and happy flowing!!!!!!

2 ACCEPTED SOLUTIONS

Accepted Solutions

 

 

Check this article to get more details about Filter Query:

OData Filter query in SharePoint Get items in Flow

 

 

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

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!!!!

View solution in original post

9 REPLIES 9
BigStev
Helper I
Helper I

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
Community Support
Community Support

 

Hi @BigStev ,

 

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

200.PNG

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-bacao-msft !!!!

Thank you for getting back to me.

I have tried the solution that you sent me.

Value is falseValue is false

 

Value is NoValue 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.

Screenshot 2020-07-16 09.09.06.png

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

Screenshot 2020-07-16 09.10.37.png

 Please try and help me.

Thank you for your reply...

Happy Flowing!!!!

 

 

Hi @BigStev,

 

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

217.PNG

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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:Community1.png

 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.

Community3.png

 

Community4.png

 

Community5.png

 

I still get the same Output from SharePoint.

This is how i have filtered the SharePoint List

Community2.png

 

Please can you see my problem and give advice.

Happy flowing!!!!!

 

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,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

Check this article to get more details about Filter Query:

OData Filter query in SharePoint Get items in Flow

 

 

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-bacao-msft 

Thank you for helping!!!

Happy flowing

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!!!!

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.

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.

MPA Licensing.jpg

Ask your licensing questions at the Power Automate AMA!

Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.

Users online (1,740)