By Andy Brown
You can download the files you'll need for this tutorial at www.wiseowl.co.uk/power-autom... (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:
/ @wiseowltutorials
Or you can click this link 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 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!
5 авг 2024