Information on Office 365, SharePoint, Power BI, PowerApps, JavaScript, jQuery, and more.
May 25, 2020 Leave a comment
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.
April 13, 2020 Leave a comment
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.
April 5, 2020 Leave a comment
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.
February 22, 2020 Leave a comment
In this video, we show some tips and tricks on uploading and using video in Teams, SharePoint, and Stream.
February 9, 2020 Leave a comment
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.
February 2, 2020 Leave a comment
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.
January 25, 2020 Leave a comment
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.
January 5, 2020 Leave a comment
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.
December 22, 2019 Leave a comment
In this video, we connect Power BI to an Excel spreadsheet and then use its power to visualize the data.
November 30, 2019 Leave a comment
My book Creating Business Applications with Office 365: Techniques in SharePoint, PowerApps, Power BI, and More is on sale for $7 this week as part of the Apress Cyber Monday Sale. Enter code CYBERWEEK19 at checkout. Here is the direct link: https://www.apress.com/us/book/9781484253304.
