How To Filter Excel Table Rows In Power Automate: Text Numbers, Dates
This article explains how to filter Excel table rows in Power Automate using ODATA queries. It provides examples of how to write ODATA queries to filter text values in a spreadsheet and a workaround for filtering number and date data types which cannot be handled using ODATA queries. The article also explains how to create an Excel table in a spreadsheet and store it in SharePoint or OneDrive for Power Automate to use. It includes step-by-step instructions and Power Automate expressions for each example. The article ends with a subscription offer and an invitation to leave comments or questions.
Article 17m
Login now to access my digest by 365.Training
Learn how my digest works
Features
- Articles, blogs, podcasts, training, and videos
- Quick read TL;DRs for each item
- Advanced filtering to prioritize what you care about
- Quick views to isolate what you are looking for right now
- Save your favorite items
- Share your favorites
- Snooze items you want to revisit when you have more time