Power Automate Part 9 – Sorting and Filtering using OData

By Andy Brown

You can download the files you’ll need for this tutorial at https://www.wiseowl.co.uk/power-automate/videos/power-automate-server/odata/ (click on the Files tab).

If you’d like to help fund Wise Owl’s conversion of tea and biscuits into quality training videos you can join this channel to get access to perks:
https://www.youtube.com/channel/UCbi5G5PjWBaQUFy7XU_O7yw/join

Or you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!

This tutorial shows how you can use OData to sort and filter tables of rows returned from online cloud-based apps like SharePoint and Excel 365, and why you should want to do this.

Chapters
00:00 Topic list
01:02 What OData is, and why it matters
02:35 Our example data for Excel and SharePoint
03:59 Excel and OData
10:36 SharePoint and OData
15:17 Advanced filtering using OData
22:29 Dynamic filtering in OData
26:11 Using experimental features

Visit https://www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Power BI, DAX, VBA, Python, Visual C#, Microsoft SQL Server, SQL Server Reporting Services SSRS, SQL Server Integration Services SSIS, Office Scripts, Power Automate and more!