Forms – Power Automate – SharePoint and then Showing the Most Current Submission in Power BI

In this video, we take a simple Microsoft Form, copy each entry to SharePoint with Power Automate, and then visualize the data in Power BI. The main insight is to show only the most recent form submission by grouping within Power BI, creating a MaxDate column, and then filtering.

Subscribe to My Channel

 

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

Creating an Employee Recognition App in Power Apps, Power Automate, Power BI, Teams, and SharePoint

In this video, we demonstrate how to create a Power Apps and Power Automate employee recognition solution that can post the recognition to a Teams channel, send a Teams chat, and/or send via email. We try to make it optional for submitters to include their information, finding it works for chats and email but not posts. We store the information in SharePoint and then use Power BI to visualize the values demonstrated and other data.

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

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

Connecting to Excel from Power BI

In this video, we connect Power BI to an Excel spreadsheet and then use its power to visualize the data.

Subscribe to My Channel

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

Creating Business Applications with Office 365 eBook on Sale for $7 this week

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.

Creating a Survey in Forms, Copying the Responses to SharePoint with Flow, & Visualizing in Power BI

In this video, we create a help desk survey in Forms, copy each response to SharePoint using Flow, and then use the SharePoint list as Power BI data source for our visualizations.

Subscribe to My Channel

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

Visualizing a SharePoint Survey with Power BI

In this video, we explain the advantages of using Power BI to visualize SharePoint survey data and then create a powerful visualization that shows responses in the last week, month, and year.

Subscribe to My Channel

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

YouTube Channel

Please check my new YouTube channel at “https://www.youtube.com/channel/UCadnfEVO8PD48xbsE2GhxEg?view_as=subscriber. It has examples from my upcoming Creating Business Applications with Office 365: Techniques in SharePoint, PowerApps, Power BI, and More book as well as other programming and application examples.

Subscribe to My Channel