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

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

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

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 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

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

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

We are exciting to announce this new book by Jeff Rhodes being published by Apress. Preorder now on Amazon and coming soon to other retailers.

Watch for upcoming posts and videos on Office 365 and related technologies.