Building a Power Apps Front End for eSignature

In this video, we finish our series on electronic signatures by replacing our SharePoint form with a Power Apps entry form for kicking off the process. We use logic in the Visible property of an error label to ensure all required values are filled in and that the email address is in the proper format. We then use the Patch() function to write the information to SharePoint, which in turn initiates the Power Automate flow.

Subscribe to My Channel

 

My Book: Creating Business Applications with Microsoft 365: Techniques in Power Apps, Power BI, SharePoint, and Power Automate

Advertisement

Creating a Power Apps Front End to Power Automate for Finding Open Calendar Slots

In this video, we update our Power Automate flow for finding open calendar slots by skipping “free” appointments. We then create a Power Apps front end for the flow. We connect to Office 365 Users to look up any user for emailing or chatting the information, choose a time zone, copy the current user if needed, and more. We also add logic for daylight savings time, error checking, accounting for timing out of the flow, and notifying the user of success.

Subscribe to My Channel

 

My Book: Creating Business Applications with Microsoft 365: Techniques in Power Apps, Power BI, SharePoint, and Power Automate

Creating a Scoring Application in Power Apps and SharePoint

In this video, we create a scoring application where we patch three different SharePoint records at the same time. Along the way, we use cascading drop-down lists, collections, data tables, and variables.

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

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

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