Checking if SharePoint Library Doc is Sorted Under Specific Section

[Anonymous]

I have a SharePoint Library with documents that are sorted into multiple sections. I have a scheduled flow that is meant to check everyday if a document was last reviewed a year ago, but this only applies to some of the sections. I have the date check figured out, but I'm having trouble getting the flow to check if the document is sorted under the appropriate section. I want to set up an If condition, but I'm having trouble putting together the expression. Basically, I want it to look at each document, which hypothetically can be sorted under with Section One, Section Two, or Section Three. It will compare the document's section to the sections I specify need to be checked, say Section Two in this case. I'm thinking along the lines of: If document section = Section Two, check date, Else do nothing. Any suggestions are greatly appreciated.

[Brad_Groux · Accepted solution]

We've had much better success with fine grain SharePoint actions by utilizing the SharePoint API rather than the built-in actions within Flow. Here are some links to get you started: 

• MSDN REST API reference and samples
• SharePoint 2013 Lists and List Items REST API reference
• Working with lists and list items with REST
• SharePoint 2013 REST code samples
• SharePoint 2013 REST overviews
• Filtering Wiki
• JavaScript List Code Samples

Here's a look at how you can drill down into the syntax via ODATA filtering: 

You can use the built-in ODATA Filter Query: 

Or you can use the HTTP Request, and submit your own environment specific API calls. What works best for you, is kind of up to you. There is more than one way to skin a cat as they say. Here are some additional links for filtering:  

• Filter Data in an Array (blog post)
• Using Filter Expressions in OData URIs BLOG: Filtering Data with OData in Flow
• OData 2.0 URI Conventions
• Filter and copy data with Microsoft Flow
• Open Data Protocol Dynamics 365 documentation
• Query Microsoft Dynamics CRM 2015 data using the OData endpoint

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!