Filter SharePoint data with oData for Power Automate and Copilot Studio

Learn to filter SharePoint data in Power Automate cloud flows and Copilot studio using oData filter. We focus on the Get Items action but oData in applicable to many different actions and products. Dataverse, SQL, SAP, and more all use oData for filtering their queries.

In this video, we dive deep into oData filter queries, covering:
✅ Basics of Get Items and filter queries in Power Automate
✅ Using AND, OR, and Parentheses for complex queries
✅ Filtering Choice and Lookup Columns in SharePoint
✅ Working with multi-choice and text-based columns
✅ Handling dates and numbers effectively
✅ Best practices for failing fast and troubleshooting errors
✅ How to filter files vs. folders in document libraries

Blog post with copy and paste syntax https://www.powerapps911.com/post/fil...

0:00 oData filters for SharePoint in Power Automate and Copilot Studio
1:19 SharePoint Data Source
2:12 Create the test flow
2:47 SharePoint Get Items Action
3:54 Intro to oData fitler query
4:35 Filter by a text field
5:51 Add a Compose
8:38 Filter by a Choice column
9:34 Filter by a Multiple Choice column
10:38 Using and or filter
13:24 Grouping with parentheses
14:24 Finding your column name
18:36 Filter by a number column
19:50 Filter by a date column
23:00 Filter by a Lookup column
24:52 Filter by Created By or Author column
25:54 SharePoint Get Files Properties Only action
26:47 Filter by File or Folder type FSObjType

Do you need some help with something that you are working on, contact us!
https://www.powerapps911.com/contact

Join this channel to get access to perks:
   / @shanescows  
#powerautomate #copilotstudio #sharepoint