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

Creating a Help Ticket Application in PowerApps

In this video, we look at the design of a PowerApps application that allows users to view their own tickets and add a new one. Along the way, we cover the Office365Users, Office365Outlook, and SharePoint data sources. We show how to set colors based on logic, show a label until all mandatory items are filled in, edit data cards, set and use global variables, and much more.

Subscribe to My Channel


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

Working with Video in Office 365 – Teams, SharePoint, and Stream

In this video, we show some tips and tricks on uploading and using video in Teams, SharePoint, and Stream.

Subscribe to My Channel


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

Controlling an Excel Web Part in SharePoint Using JavaScript

In this video, we look at how to show a different named part from an Excel workbook in a SharePoint page for each day of the month using JavaScript.

Subscribe to My Channel


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

Simple Programming Concepts Implemented in PowerApps, Web Forms, HTML, Windows Forms, and ToolBook

In this video, we build the same simple application in Visual Studio (Windows Forms, Web Forms, HTML), ToolBook, and PowerApps to see the differences in environments in working with properties, events, and methods.

Subscribe to My Channel


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

Implementing Search in PowerApps, SharePoint, and Teams

In this video, we customize the display of dates in a SharePoint Task List using Cascading Style Sheets (CSS), JavaScript/jQuery, and a Content Editor.

Subscribe to My Channel


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

Implementing Search in PowerApps, SharePoint, and Teams

In this video, we implement search in our “Help Tickets” SharePoint list datasource for multiline text columns using managed properties. We then examine how to add the list to Teams to implement search there. Finally, we build a PowerApps search application that uses collections to quickly search our tickets.

Subscribe to My Channel


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