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

Working with SharePoint Lookup Columns in Power BI

In this video, we explore how to use the FieldValuesAsText functionality in Power BI to get the data from within a SharePoint Lookup column. We also explore the 2.0 beta version of the SharePoint Online List data source as well as creating custom columns and filtering by Content Type.

Subscribe to My Channel

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

Uploading Files from PowerApps to SharePoint and Emailing Links using Power Automate

In this video, we see how to upload multiple attachments from PowerApps to a SharePoint document library using Power Automate/Flow. While we are in Power Automate, we create an email of links to these documents and email it to the designated recipient.

Subscribe to My Channel

 

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

Displaying Embedded SharePoint Rich Text Images in PowerApps

In this video, we see how to use the PowerApps Substitute function to replace the relative image URLs within SharePoint List Rich Text columns with complete URLs so that images display correctly in PowerApps.

Subscribe to My Channel

 

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

Dynamically Setting Object Properties in PowerApps Based on a SharePoint List

In this video, we explore how to approximate dynamic object references/reflection in PowerApps. We take an “Actions” list in SharePoint and use it to set Text, Tooltip, and Visible properties of each corresponding button in PowerApps.

Subscribe to My Channel

 

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

Dynamic Information in PowerApps and Sending an Adaptive Card to Teams using Power Automate

In this video based on a real-life example, we create linked SharePoint lists that display status levels, colors, and associated steps. We then read these lists from PowerApps to create a status display that we display in a tab in Teams. Finally, we create a flow so that each time the status changes, we automatically post that to our Teams channel.

Subscribe to My Channel

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

Videos and Quizzes with Office 365 – Stream, Forms and Teams

In this video, we see how to use Stream’s new Record Screen capability to create a video of both your screen and the you as the narrator. We show how to edit the caption both in the Stream interface and by downloading and editing the .vtt file. Next, we add a Microsoft Forms Quiz and show how to embed that in the video. Finally, we demonstrate how to add the video as a tab in Teams.

Subscribe to My Channel

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

Creating a Power BI Visualization from SQL Server Data

In this video, we create a Power BI visualization using a query from Microsoft SQL Server. Specifically, we join several tables from the Tracker.Net Learning Management System to visualize student and lesson information. We cover slicers, cards, pie charts, tables, and the Text Filter control. We also examine how to customize the drill-down interactions with the pie charts.

Subscribe to My Channel

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

Overcoming Delegation Issues with PowerApps, SharePoint, and Flow

In this video, we look at how to use technique described in https://tinyurl.com/twzvbgl to overcome delegation limits in PowerApps using a SharePoint data source. We also implement a corresponding Power Automate Flow to copy the ID value to a numeric column each time we create a record.

Subscribe to My Channel


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