Reading a delimited file to copy and delete attachments with .NET

This video expands on a previous video and reads the attachment information from a delimited file instead of an Excel spreadsheet. It also shows how to keep a list of missing and renamed files and display those in the application.

Subscribe to My Channel

 

My Book: Creating Business Applications with Office 365: Techniques in SharePoint, PowerApps, Power BI, and More

Reading an Excel file to automate the copying and deletion of attachments with .NET

In this video, we build a .NET Windows Forms application to programmatically read a column in an Excel worksheet, manipulate it to remove HTML and format its file names, and bind that to a grid. We then programmatically find each file and copy it to a new directory. Finally, we optionally delete the original files.

Subscribe to My Channel

 

My Book: Creating Business Applications with Office 365: Techniques in SharePoint, PowerApps, Power BI, and More

Joining SharePoint Lists in Power BI

In this video, we look at a different way to visualize data from a lookup column in SharePoint. We join the columns in Power BI and then use both lists to create our visualizations.

Subscribe to My Channel

 

My Book: Creating Business Applications with Office 365: Techniques in SharePoint, PowerApps, Power BI, and More