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 will show how to load data from Excel tables, SharePoint lists, Outlook (for example, lists of emails) and OneDrive (for example, lists of files and folders). The tutorial also shows how to select only the columns you need, and how to present the information in an HTML table.
Chapters
00:00 Topic list
01:00 Creating Excel 365 tables
04:01 Loading tables from Excel
06:41 Selecting columns
09:20 Creating HTML tables
12:31 Formatting HTML tables
14:39 Other Excel tables available
16:55 Loading SharePoint lists
23:37 Loading tables from Outlook (eg emails)
27:44 Loading lists of files and folders from OneDrive
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