Search Content

Learn how to customize a gallery and use the Patch function directly within a gallery in Power Apps. Shane’s demo shows how to build a gallery that displays employee names, titles, and favorite colors along with cancel, edit, and save buttons. In this video you will learn about: The Patch function The UpdateContext function The Reset function Link to the video on YouTube: Power Apps Patch Function Link to the video for Curated Library subscribers: Power Apps Patch function Key timestamps: 0:00 Intro 1:02 Demo of the solution Shane demonstrates the functionality of his employees SharePoint list in a customized gallery. The favorite color and title fields are able to be edited and saved. 3:03 Create the solution in Power Apps and insert a gallery A vertical gallery is inserted into the app and the Employees SharePoint list is selected as the data source. The title field is customized to include first and last name. A label is added that displays ‘favorite color’ and a drop down control is inserted. An additional label is added that displays ‘title’ and a text input is inserted. 7:56 Add a save button and use the Patch function A button is added that allows users to save their changes in the gallery. The Patch function is utilized to update a single record. 11:08 Add an edit/cancel button and use the UpdateContext function A button is added that users must click in order to be able to edit the gallery. The UpdateContext function is added to the edit button to create a toggle effect. The If function is added to the edit button to allow users to cancel their changes in the gallery. 16:52 Add the UpdateContext function to the save button Upon clicking the save button, the screen reloads and everything resets. 17:52 Add the Reset function to the edit/cancel button Upon clicking the cancel button, changes that the user has made that have not been saved are discarded. 19:43 Demo of how to patch a new record Shane demonstrates the functionality of a button that utilizes the Patch and Default functions to patch a new record. 23:15 Demo of how to write a single record Shane demonstrates the functionality of an additional button that utilizes the Collect function to write a single record. Additional learning: Video: Power Apps Save Data - Patch, Collect and ForAll Video: Power Apps SharePoint Complex Columns - Patch person, choice and lookup fields Do you want to become a Power Apps Rockstar? Check out our different full length training classes at https://training.PowerApps911.com or you can download a working version of the app we built today by subscribing to the Curated Library .

In this video series you will learn how to work with Microsoft Forms. The following 3 videos are included in this series: Intro to Microsoft Forms - https://www.youtube.com/watch?v=YgWT9mJKEzk&t=19s Create SharePoint List from Excel MS Forms - https://www.youtube.com/watch?v=9hBeckKMlrg&t=45s Forms and Flow saving data and conditionals - https://www.youtube.com/watch?v=462l8JuJ9xM Working with Forms Intro to Microsoft Forms Microsoft Forms are a great way to electronically gathering information from either an anonymous source or a source that is outside of your organization. In Shane’s Introduction to Microsoft Forms – No more Survey Monkey video, he demonstrates how to create a form and navigate the many different customizable features. You’ll learn what forms are, how to share them, how to view the data that they collect, and much more. Throughout the video Shane also discusses the differences between Microsoft Forms and Microsoft Forms Pro, and the additional options that are available with Forms Pro. Key Timestamps: 0:00 Intro 1:16 Demo of the solutions 5:00 Create a new form and add different types of questions 9:12 Break the form up into sections 10:08 Create branching 11:11 Overview of form settings and multilingual 14:09 Overview of response results, analytics, and insights 17:21 Overview of themes 19:20 Forms within customer scenarios Create SharePoint List from Excel MS Forms In Shane’s Microsoft Forms to SharePoint List: Create SharePoint List from Excel video, he demonstrates how to move data from Forms directly to SharePoint by using Power Automate. The goal is to automatically record form responses in SharePoint each time that a response is submitted. Shane takes the demo a step further by adding an action to send an email in order to notify the recipient of each form response. Key Timestamps: 0:00 Intro 1:49 Demo of the solution 2:57 Create a new list from Excel in Power Apps 6:20 Create a Flow from the ‘Record form responses in SharePoint’ template Forms and Flow saving data and conditionals Learn about the relationship between Microsoft Forms and Flow in the context of a Covid-19 compliance app. In Shane’s Microsoft Forms and Flow – Saving data for a Corona Virus Compliance solution video, he demonstrates how to move data out of Forms and into a data source, and perform conditional logic using Power Automate. In this example SharePoint is used as the datasource. This app is a great example of how the Power Platform can be used to automate processes that were previously performed manually. This video builds off of Shane’s Introduction to Microsoft Forms – No more Survey Monkey video, listed above. Key Timestamps: 0:00 Intro 2:15 Demo of the solution 3:34 Create a branching rule within the form 6:59 Overview of form settings 8:16 Demo of how to send the form 9:00 Create a Flow from the ‘Record form responses in SharePoint’ template 12:23 Test the flow and form 14:37 Add an action to the flow to be notified if anyone says yes

Learn the basics of storing an Excel spreadsheet in OneDrive for Business and using this as a data source for Power Apps. This video lays the groundwork for being able to build more complex apps. In this video you will learn about: Adding an Excel spreadsheet to OneDrive for Business The ColorValue function Detail Form Edit Form Browse Gallery Link to the video on YouTube: Learn to connect: Power Apps Excel Spreadsheet hosted in OneDrive Link to the video for Curated Library subscribers: Learn to connect Power Apps Excel Spreadsheet host Key timestamps: 0:00 Intro 1:13 Create the solution in Power Apps 2:40 Format the Excel spreadsheet Shane formats the data in his Excel spreadsheet as a table in order for it be used as a data source. He then gives the table a name to make it easier to be referenced in Power Apps. 3:57 Add the Excel spreadsheet to OneDrive for Business The Excel spreadsheet is added to OneDrive and connected to Power Apps, which results in the creation of an app. 5:26 Demo of the solution The app is previewed and the title field on the edit screen is modified. This modification is also reflected in the Excel spreadsheet in OneDrive. 6:32 Customize the app and use the ColorValue function Title field is customized to include first and last name. The ColorValue function is added to the body field to display colored text based on favorite color. 11:49 Navigate the different screens in the app and perform additional customizations using Detail Form and Edit Form Legacy field is removed and the remaining fields are sorted via the Detail form. The first name and last name forms are unlocked and their display names are modified. The fields are sorted via the Edit form. 16:34 Sort the data using Browse Gallery Change the data to sort by the first name field instead of the department field via Browse Gallery. 18:08 Save and publish the app Name the app, select an icon for it, and save it to the cloud. 20:32 Demo of the solution through the Power Apps mobile app Additional learning: Video: Power Apps Multiple Data Sources Do you want to become a Power Apps Rockstar? Check out our different full length training classes at https://training.PowerApps911.com or you can download a working version of the app we built today by subscribing to the Curated Library .

This video series will teach you everything you need to know about Power Apps Forms . These videos will not only get you started working with Forms, but will teach you more advanced concepts that you need to produce complex forms. The following 7 videos are included in this series: Intro to Power Apps Forms - https://www.youtube.com/watch?v=yT4gGVunU0o Power Apps Form Modes - https://www.youtube.com/watch?v=BnzaSDYl8mA Forms Unsaved, Updates & Last Submit - https://www.youtube.com/watch?v=N8DWvS7P9lw Power Apps Form OnSuccess - https://www.youtube.com/watch?v=q2bhlBAqN_E&t=30s Customize your Forms like InfoPath - https://www.youtube.com/watch?v=5vVFgaEBYuM Power Apps Tabs - https://www.youtube.com/watch?v=if_mFIfi5PM&t=24s SetFocus & Scroll up Form - https://www.youtube.com/watch?v=dDsY3kap0rw What are Forms? A Form is a prebuilt interface used to display details of a record, edit details, and create new records. Why use Forms? Forms talk directly to your data source and builds out any requirements that exist within your data source. Once the requirements have been built out, Cards can be customized and functions can be utilized to affect the entire Form. A few functions that you will learn to work with in this video series are EditForm, ResetForm, ViewForm, SubmitForm, and NewForm. Working with Forms Intro to Power Apps Forms One of the first steps to take when getting started with Forms is to add a gallery to your blank screen in Power Apps. The gallery will display a data source of your choice, and the form will display one record of that data source. Shane uses SharePoint as a data source throughout this video series, but any data source will work. There are two form options to choose from: an Edit Form and a Display Form. Display Forms are used to display data, while Edit Forms are customizable and their modes can be changed. The number of columns, size of cards, order of cards, and more can all be altered in an Edit Form. Fields can easily be added and deleted depending on the content that you want your users to see. Shane's first video, Power Apps Forms – Introduction to data sources, data cards, and layout , will lay the groundwork for you to be able to build your first form and for the rest of the video series. Key Timestamps: 0:00 Intro 1:24 Add a vertical gallery 2:21 Overview of Edit vs Display Form and add an edit form 3:57 Set the item property 4:26 Overview of pop out menus and demo of snap to columns 10:22 Customizing Fields and cards Power Apps Form Modes Forms can be put into and taken out of New, Edit, and View modes. This can be done via the NewForm , EditForm , and ViewForm functions. In Shane’s Power Apps Forms – Form Mode video, he demonstrates how to put a form in each of these three different modes by utilizing a button per function. One thing to keep in mind here is that buttons must be added outside of the form itself. The SubmitForm function is used to create a ‘Submit or Save’ button that either saves a completely new record that has been created or updates an existing one. The ResetForm function is used to create a ‘Reset’ button that resets the form back to its default. Key Timestamps: 0:00 Intro 1:30 Add labels to the screen to display the form mode and form display mode 4:13 Change the default mode of the form 5:42 Add a button to change the form mode using the EditForm function 7:08 Add a button to cancel being in edit mode using the ViewForm function 7:58 Display the cancel button depending on what mode the form is in with an If function 9:50 Modify the If statement 11:22 Add a button to put the form in new mode using the NewForm function 12:12 Difference between form mode and form display mode 15:44 Add a button to submit the form using the SubmitForm function 16:45 Reset the form back to default using the ResetForm function 18:17 Overview of item property Forms Unsaved, Updates & Last Submit When working with Forms, you have the opportunity to use a few unique properties. The Unsaved property lets you know if edits have been made but not yet saved. The LastSubmit property contains the record of the last item that the form submitted. The Updates property shows values we pushed to our list. Shane demonstrates how to use all of these properties in his Power Apps Forms – LastSubmit, Updates, Unsaved video. Key Timestamps: 0:00 Intro 1:05 Add the Unsaved property and warning text 5:04 Disable the save button while there are unsaved changes using the Unsaved property 7:31 Add the Last Submit property to show info that was just submitted 12:25 Add the Updates property Power Apps Form OnSuccess This video will teach you how to avoid common errors and the correct way to use three different properties with Forms. The OnSuccess property triggers a behavior after a form has been submitted. The OnFailure property triggers when a form fails to submit. The OnReset property triggers each time that form is reset. In Shane’s Power Apps Form OnSuccess, OnFailure, OnReset video, he demonstrates how to use these 3 properties and how to send an email every time that a change is saved in a form. Key Timestamps: 0:00 Intro 1:20 Add a button that sends an email via Office365Outlook.SendEmailV2 in the OnSuccess 4:42 Add the ResetForm to the OnSuccess property 5:04 Use LastSubmit to include a specific field in the email 6:50 Overview of OnFailure and OnReset Customize your Forms like InfoPath Forms can be customized to look like InfoPath . In Shane’s Power Apps Custon Forms to look more like InfoPath video, he demonstrates how to add headers and subsections, get fill colors, set borders, disable fields depending on the user, and more. This video will teach you numerous tips and tricks to get your forms looking more like InfoPath . Key Timestamps: 0:00 Intro 1:25 Demo of the solution 1:57 Start with a blank tablet layout and add a gallery 2:59 Create a second screen, add a form, and remove unnecessary fields 5:08 Add a header to the top of the form/screen 6:50 Add a custom card to break the form up into sections 8:49 Wrap text in a notes field via mode 10:46 Make a field not editable and hide an entire card depending on the user 14:02 Create a third screen for app notes and fill screens via a color code 17:54 Add submit and cancel buttons 20:37 modify border thickness 22:06 Duplicate the screen Power Apps Tabs In Shane’s Power Apps Tabbed Form video, he demonstrates how to create a tabbed form that creates a much more user friendly experience. The purpose of a tabbed form is to get an entire form onto one screen, completely eliminating the need for your users to scroll in order to be able to complete a form. This video will teach you how to create a single screen with multiple tabs for separating different sections of a form. Key Timestamps: 0:00 Intro 1:38 Demo of the solution 3:44 Walkthrough of the solution 8:52 Start with a blank screen, add a gallery, and add a form 9:56 Add 3 buttons to create the tab functionality 11:48 Set the OnSelect using the Set function and set the DisplayMode using an If function 13:04 Set the DisabledFill and BorderThickness properties 17:35 Set the visible fields for each button 23:03 Add an icon to save the form using the SubmitForm function and add an icon for a new form using the NewForm function SetFocus & Scroll up Form Adding scrolling functionality within a form is one way to better your users overall experience. In Shane’s Power Apps SetFocus and Scroll to top of a Form video, he demonstrates how to use the SetFocus function in order to scroll to the top of a form once it has been submitted. The SetFocus function can also be used to send your users cursor where you want it to go. This functionality is great for directing users to a specific place within the form or drawing their attention to something that might otherwise be easily overlooked. Key Timestamps: 0:00 Intro 0:44 Demo of the solution 1:29 Overview and nuances of the SetFocus function 3:23 Use the SetFocus function to scroll to the top of a form 4:16 Use the SetFocus function to scroll to the top of a form that does not have text inputs

An introduction to the Power Apps Search function and how to use it to create a search box. Lots of good little details to get you off and running with the Search function. In this video you will learn about: The Search function The ShowColumns function Link to the video on YouTube: Power Apps Search Function Link to the video for Curated Library subscribers: Power Apps Search Function Key timestamps: 0:00 Intro 1:06 Create the solution in Power Apps and insert a gallery to build the search box The search box is composed of a gallery and a text input. The Search function is added to the gallery to reference what users type in the text input against the Employee Details 4:54 Nuances of the Search function The search box uses text and performs a case insensitive search. Multiple columns can be searched at once. 6:36 Explanation of what the blue circles mean and an overview of delegation The blue circles appear within the app due to delegation. The SharePoint data connection does not fully support the Search function, and instead Power Apps only returns 500 items at a time. 9:36 Explanation of what the Search function returns The Search function returns a table, and not text. 10:21 Utilize the Search function and ShowColumns function with a Drop down control The ShowColumns function is needed in addition to the Search function when working with a Drop down control. 12:10 Troubleshooting error messages The blue wavy lines only appears on the first item. 14:43 Demo of an app from a SharePoint list & how to fix it The Filter function must be modified in order for the search functionality to work with the SharePoint list. Additional learning: Video: Learn to use the Power Apps Filter function Do you want to become a Power Apps Rockstar? Check out our different full length training classes at https://training.PowerApps911.com or you can download a working version of the app we built today by subscribing to the Curated Library .

In this video series you will learn how to work with SharePoint and Power Apps. The following 5 videos are included in this series: Learn Power Apps - https://www.youtube.com/watch?v=BnYe_7fpZRM SharePoint Custom Forms Power Apps - https://www.youtube.com/watch?v=Badj3_T8zAw&t=1s Patch SharePoint Columns - https://www.youtube.com/watch?v=gsk14D-CYRE&t=2s SharePoint Columns vs. Power Apps - https://www.youtube.com/watch?v=mwXnJUkTug0 SharePoint Approval Flow - https://www.youtube.com/watch?v=3shHcIgjxH4 Working with SharePoint Learn Power Apps If you are new to Power Apps, this is the video for you! In Shane’s Power Apps with a SharePoint List – Learn Power Apps Tutorial video, he demonstrates how to use Power Apps to create an app with SharePoint as the data source. You will learn how to build your first Power Apps app and perform customizations to the different screens, columns, fields, and more. This video lays the groundwork for being able to make more complex Power Apps. Key Timestamps: 0:00 Intro 1:09 Create a new phone layout SharePoint app 3:54 Preview the app 5:14 Access the data controls in order to be able to edit the app 6:24 Modify the color column with the ColorValue function 9:10 Sort the screen by a different field using the SortByColumns function 10:26 Modify the fields in the editscreen 13:09 Overview of app settings and save the app 14:43 Preview of the app on mobile SharePoint Custom Forms Power Apps Create a better experience for your users by building and utilizing a custom SharePoint list form in Power Apps. In Shane’s Custom SharePoint List Form with Power Apps video, he demonstrates how to use Power Apps to get started with customizing SharePoint list forms. This video lays the groundwork for building more complex list forms in future videos. You’ll learn how to edit fields, add a button, and more. Shane also covers the SharePoint Integration capability. Key Timestamps: 0:00 Intro 1:30 Create a new custom form in Power Apps, and save and publish the app to SharePoint 4:28 Walkthrough of different form modes 6:33 Hide unnecessary fields in the form via the Visible property 9:14 Refresh the SharePoint page to show new changes 10:45 Document changes made in a new screen 12:19 Add a button to the form that sends an email via the Office365.SendEmail connector 16:44 Overview of licensing and permissions 17:45 Overview of how to delete a custom form Patch SharePoint Columns If you use SharePoint as a data source, you have likely encountered problems at some point while working with person, choice, and lookup columns. In Shane’s Power Apps SharePoint Complex Columns – Patch person, choice, and lookup fields video, he demonstrates how to directly patch complex column types in Power Apps using the Patch function. In this video, two approaches for patching each complex column type are shown: an intermediate way and a more advanced way. The intermediate way for patching columns is done with either a Drop down or Combo box control. The advanced way for patching columns is done with just a button. Key Timestamps: 0:00 Intro 1:42 Demo of the solution 3:43 Patch a choice column via a Drop down control– intermediate 6:12 Patch a choice column – advanced 7:19 Patch a lookup column via a Combo box control – intermediate 8:58 Patch a lookup column – advanced 10:51 Patch a person field via a Combo box control – intermediate 12:04 Patch a person field – advanced 14:06 Patch a multi select choice column via a Combo box control – intermediate 15:32 Patch a multi select choice column - advanced 17:11 Patch a current user and an additional user into a multi people field SharePoint Columns vs. Power Apps Do you use SharePoint columns as a data source for your Power Apps? When creating custom SharePoint lists, there are a few things to keep in mind that will make your life easier in the long run. In Shane’s Understanding SharePoint Columns and Power Apps video, he demonstrates how to create and name SharePoint columns. In order to avoid confusion in Power Apps, all SharePoint columns should be initially named without using any spaces. Shane also recommends that if you are creating a SharePoint list to be a data source only for a Power App, that you use the single line of text, number, and date and time columns. Keep in mind that column types matter when creating your SharePoint lists! Key Timestamps: 0:00 Intro 1:08 Create a SharePoint custom list and name the column 2:51 Rename the ‘LastName’ column to include a space 5:33 Overview of different column types SharePoint Approval Flow In certain situations, you want to be able to control the content that your users are seeing by approving that content prior to it being published. This can be accomplished through a SharePoint Approval Flow . In Shane’s SharePoint Approval Flow video, he demonstrates how to build a SharePoint list, add SharePoint approvals, and put that into an approval process in Flow. The resulting solution is a SharePoint picture library that requires approval once a user has uploaded a picture to it. Key Timestamps: 0:00 Intro 1:48 Create a picture library in SharePoint and customize the library settings 3:15 Create a flow from blank and add the ‘When a file is created’ SharePoint trigger 6:28 Add an approval action 8:58 Add a response condition 11:46 Add the ‘Get file metadata’ SharePoint trigger 14:34 Add the ‘Send an email’ action 16:01 Name and save the flow 17:17 View the approvals on a desktop, email, and mobile device

In this video series you will learn how to work with attachments in Power Apps. The following 3 videos are included in this series: Save All Files with the Attachment Control - https://www.youtube.com/watch?v=Pa-pYEkLH-U Upload to SharePoint Document Library - https://www.youtube.com/watch?v=3QaiM8SeWfM&t=1428s Power Apps Azure Blob Storage - https://www.youtube.com/watch?v=wF0MmiaGO_o Working with Attachments Save All Files with the Attachment Control Do you or your users need to be able to upload and save different types of files? If you have attempted to accomplish this via the Add Media control, you know that this control only shows image files. In Shane’s Power Apps Attachment Control – Upload All Files not Images Only to Azure Blob Storage video, he demonstrates how to hack the Attachment Control to upload all files rather than image files only. The files are then saved off to Azure Blob Storage, and all of this is shown in the context of an expense report app. Key Timestamps: 0:00 Intro 1:09 Demo of the solution 2:33 Insert a blank screen and add a Form 3:50 Copy the Attachment Control from the Form and delete the Form 4:28 Edit the control in the formula bar 5:42 Manipulate the OnAddFile code 7:35 Add a gallery 11:09 Customize the appearance of the app 13:39 Preview of a different app that utilizes the Attachment Control Upload to SharePoint Document Library Uploading files to a SharePoint document library can now be made easy through Shane’s super simplified solution! Learn how to create a button that uploads a file directly to your SharePoint document library from Power Apps. This includes PDFs, word docs, excel files, images and more. In Shane’s Power Apps upload file to Sharepoint document library video, he demonstrates how to do the above with no crazy code, parsing, or hacking. Key Timestamps: 0:00 Intro 1:54 Demo of the solution 3:51 Create the solution in Power Apps and add the Attachment and Image controls 6:20 Add a button to the app and utilize the Set and JSON functions 9:16 Perform text manipulation to isolate the base64 13:53 Write a flow to get the base64 into SharePoint 18:05 Perform additional text manipulation 20:07 Demo of the final solution 21:25 Simplify the appearance of the app Power Apps Azure Blob Storage A straightforward method for storing and accessing your files in Power Apps. In Shane’s Power Apps Azure Blob Storage connector video, he demonstrates how to quickly get files in and out of Power Apps via the Azure Blob Storage connector. You’ll learn how to set up an Azure Blob Storage account, download the Azure Storage Explorer, and utilize Azure Blob Storage. Key Timestamps: 0:00 Intro 2:01 Demo of the solution 4:57 Set up an Azure Blob Storage account 8:16 Download the Azure Storage Explorer and create a Blob Container 10:51 Create a tablet app in Power Apps and add the Azure Blob Storage as the datasource 12:45 Upload a file to Azure 16:54 Create a second screen and add a gallery show the file 19:25 Add the ClearCollect function to the OnVisible property of the gallery 22:00 Add the Launch function to the OnSelect propery of an icon to have the gallery interact with other files 30:51 Add the Camera control 33:39 Set the Public Access Level in the Azure Storage Explorer

Explore App.StartScreen, App.OnStart and Deep Linking - all in Power Apps. You will be able to ditch the Navigate property and see how new features work. Shane explains the Start Screen he created and how you can customize your app to add a welcome/intro screen. In this video you will learn about: Setting the start screen in Power Apps How StartScreen may be affecting your apps App.OnStart feature The retired feature you may need to enable Deep Linking Link to the video on Shane's YouTube channel: Power Apps StartScreen, OnStart, and Deep Linking Fix Link to the YouTube Resource Library Subscribers click here to view the video within the library Key Timestamps: 0:00 Intro 0:35 What you're going to learn Shane explains what App.StartScreen, App.OnStart, and Deep Linking are and what will be taught regarding those topics. 1:32 Demo of Start Screen Shane shows and explains his current Start Screen in Power Apps. 2:10 How does Power Apps know what screen to show first Learn how Tree View affects the order of the screens in Power Apps. 3:00 App.StartScreen property Use this property to redirect what screen is shown. Save your app and ensure correct changes in order to display the desired screen. 5:00 Changes with App.OnStart - Navigate Shane shows an old way of making the past changes - using Navigate - and how to do those same actions and more with new features. Navigate is now not permitted in OnStart, therefore the StartScreen property should be used instead. 6:02 How 'IF' logic is supported on StartScreen 8:00 What is "imperative" and "declarative" logic 10:15 Deep Linking- another way to use Start Screen Shane shows the 'Param' function and how to use it to look for certain screens. 14:00 Demo of Shane's "Deep Linking Demo App" 15:50 Using past methods in your new apps Enable Retired Features in your new app when receiving error messages when attempting to perform previously used methods. 17:30 Where is the evolution of Power Apps heading? Blog post explains new features. Upcoming new features soon to be added to Power Apps. Additional Learning: Do you want to become a Power Apps Rockstar? Check out our different full length training classes at https://training.PowerApps911.com By subscribing to YouTube Video Resource Library you can access downloadable apps that are used in Shane's demos.

Get started with an introduction to Power Automate Desktop Flows. Shane explains exactly what it is, how to install it, and how to solve a few automation challenges. Follow along with Shane through this video as you build your first Desktop Flow. Included in this video: What are Power Automate Desktop flows and how to install Building your first flow Browser Automations Outlook and Excel Actions Link to Shane's YouTube channel: https://www.youtube.com/channel/UC7_OGRP8BYvtGB8eZdPG6Ng Link to this video on YouTube: https://youtu.be/suk4eLS4A-E Key Timestamps: 0:00 Intro 1:17 Getting started by installing Power Automate Desktop Flow Shane demonstrates how to install Power Automate Desktop Flow, what extensions you can download, and explains any problems you may come across. 2:33 Start building the Desktop Flow Learn how to begin navigating through Power Automate once you have it downloaded. Shane explains how the flow he will build is going to perform in Power Automate. 4:51 Browser Automation and our first variable Shane begins with opening a new browser window and extracts data from a web page. Learn how to then store your data within a variable, while also understanding any possible errors. 9:34 Outlook Actions to send email messages through Outlook + Flow control Wait Learn how to send a new Outlook email message within Power Automate. Shane explains how to make Power Automate delay closing Outlook to ensure the message is sent, and Outlook is not closed too quickly. 13:29 Excel Actions + Date time action Open an existing file in Excel and create a variable. Use an action to retrieve the first free column/row on the active worksheet. Shane explains how to write the current date and time to your Excel worksheet. 19:35 Running the Desktop Flow you built You did it! You have completed your first Power Automate Desktop Flow. Run it and see your hard work in action. Additional Learning: Video: Power Automate Desktop Web Recorder, Conditional, and Go To action Video: Create SharePoint List using Power Apps and Power Automate Do you want to become a Power Apps Rockstar? Check out our different full length training classes at https://training.PowerApps911.com or you can access downloadable apps used in Shane's videos through our YouTube Video Resource Library .

In this video series you will learn about different methods for generating PDFs and printing with Power Apps. The following 5 videos are included in this series: Power Apps PDF generator - https://www.youtube.com/watch?v=2rfAQe1kK8M Dynamic PDF generator - https://www.youtube.com/watch?v=bfXV_GXc_JM Convert Images for PDFs & Components - https://www.youtube.com/watch?v=bIne3DD3HAg&t=2s Power Apps Print API - https://www.youtube.com/watch?v=m4Fu9af2h1c&t=205s Print with Power Apps - https://www.youtube.com/watch?v=JMhVtII5hQs&t=3s Printing in Power Apps: Power Apps PDF generator Do you need to make invoices or keep record of something in Power Apps? Learn how to do this and more by using the Microsoft Flow PDF Converter to create a PDF generator in Power Apps. In Shane’s Power Apps PDF Generator using Microsoft Flow PDF Converter video, he demonstrates how to make HTML, utilize Flow and OneDrive, and finally send information from Power Apps directly to a PDF. The goal with this video is to automate data collection in order to get rid of paper, store the data in an accessible location, and subsequently present that data in an efficient way. Key timestamps: 0:00 Intro 2:04 Demo of the solution 3:08 Write the HTML, add it to Flow, and utilize the Concat function 9:21 Convert the file format and utilize the DataUri expression 14:35 Edit the flow and convert the HTML file to a PDF 17:33 Add the flow to Power Apps 23:32 Generate a PDF from Power Apps Dynamic PDF generator This video takes the PDF generator a few steps further and will teach you how to build a more complex PDF with dynamic data and an HTML table. Shane's Power Apps PDF from table data video builds upon the concepts shown in his Power Apps PDF Generator using Microsoft Flow PDF Converter video above. By filtering a data source, multiple rows and columns will be returned that can then be saved as a PDF from Flow. Key Timestamps: 0:00 Intro 1:37 Demo of the solution 4:10 Overview of the solution 9:50 Overview of the Flow 11:37 Utilize the Concat function 15:13 Create an HTML table 20:38 Format the HTML table 25:24 Generate a PDF from Power Apps Convert Images for PDFs & Components Image files can be tricky to work with throughout your Power Apps. One way to navigate this is to convert image files and use them in their encoded form. In Shane’s Power Apps Convert Image to Base64 for Emails, PDFs and Components video, he demonstrates how to convert an image to base64 for emails, pdfs, and components. Key Timestamps: 0:00 Intro 1:47 Insert an image and resize it using the Snagit Editor 4:24 Convert the image to Base64 5:45 Add the Base64 to the image control 6:47 Send the image in an email 10:02 Overview of including the image in a PDF 12:06 Update the image in the component library Power Apps Print API One approach to printing labels, barcodes, forms, and more directly from Power Apps is to utilize a 3rd party API called PrintNode. PrintNode allows users to connect their printer, generate an API key, and then use that API key over in Flow. In Shane’s Power Apps Print directly to a printer with an API – PDFs, Labels, Barcodes, and more with Flow video, he demonstrates how setup PrintNode and build a Flow in order to print directly from Power Apps. Something to keep in mind here is that the Flow is premium, and Shane will further discuss licensing later in the video. Key Timestamps: 0:00 Intro 2:15 Demo of the solution 5:44 Overview of the Flow 8:12 Overview of PrintNode 10:42 Build the flow 19:38 Overview of licensing Print with Power Apps The new Print() functionality in Power Apps allows you to save a screen as a PDF or print it directly to a printer. Printing can be done by simply inserting an icon and adding the Print function. In Shane’s Power Apps Print function and adding it to your forms and apps video , he demonstrates how to add the Print function to an existing form and app. Also covered in this video are some of the nuances of the functionality. For example, Shane compares the Print function to taking a screenshot. If you are trying to print screen that includes a gallery or a form, only what is displayed on the screen will be printed rather than the entire gallery or form. In addition, the Print function is does not currently work on a mobile device. Key Timestamps: 0:00 Intro 1:23 Demo of the solution 3:12 Print an existing app with the Print function 5:00 Nuances of the Print function 5:26 Hide the print icon from the screen when printing it in the Visible property 8:45 Print a single record to look like data 12:12 Send the user back to where they came from after printing in the OnSelect property 14:44 Remove the screen fill from the screen when printing in the Fill property

In this video you will learn how and when to use contextual and global variables within your Power Apps. In this video you will learn about: Contextual variables Global variables Link to the video on YouTube: Intro to Power Apps Variables Link to the video and the app download for Curated Library subscribers: Key timestamps: 0:00 Intro 0:51 Create the solution in Power Apps and demo of Excel-like functionality Shane starts by creating a blank tablet layout app in Power Apps. An Excel spreadsheet is recreated in the app by inserting two text inputs and two labels. variables not used 5:15 Demo of a Contextual variable A contextual variable stores a value and makes it available on one screen. A button is inserted and the Update context function is added to the button. 9:49 Demo of pushing a Contextual variable to another screen A button is inserted and the Navigate function is added to the button. 13:44 Demo of a Global variable A global variable only needs to be created once and then can be used throughout an entire app. A button is inserted and the Set function is added to the button. Additional learning: Video: Working with a Power Apps Collection Do you want to become a Power Apps Rockstar? Check out our different full length training classes at https://training.PowerApps911.com or you can download a working version of the app we built today by subscribing to the Curated Library .

Learn everything you need to know about building your first custom app in Microsoft Teams by using Power Apps and Dataverse. Start by creating a table, adding columns, and then customize the app to your liking. In this video you will learn about: Creating an app in Microsoft Teams Creating a table in the app and different column types The Color and Font size property The User function Table, Gallery, and Form customizations Link to the video on YouTube: Build and Customize your first Teams App with Power Apps Full Training Link to the video and the app download for Curated Library subscribers: 9/22/2020 - Build and Customize your first Teams App with Power Apps Full Training Key Timestamps: 0:00 Intro 1:26 Demo of the solution Shane demonstrates the functionality of his employee dataset app in Microsoft Teams. The app includes a gallery of employees and each is able to be edited by the user. 3:10 Create the solution in Power Apps within Microsoft Teams and add a table in the app Find and select the Power Apps Preview app in order to create an app directly in Microsoft Teams. Create a table and add columns for job title, first name, last name, age, hourly wage, hire date and good at their job? The columns utilize numerous different types such as text, number, decimal, date, yes/no and choice. 10:21 Preview the solution and perform additional editing to the data Shane demonstrates an alternative way to view and add columns to the table. Add an image column called ‘face’ to be able to display employee pictures. General navigation and how to move back and forth between Teams and the app. 17:28 Customize the app Use BrowseGallery to change the order of the fields. Show first and last name in the label control. Change the age label to display hourly wage, and format as currency. 22:06 Overview of Power Apps Formula Reference 24:58 Use the Color property and Font size property Shane demonstrates different ways to show colored text with the color property, the RGBA function, and the ColorValue function. 29:37 Add the Face field to the form Face field is added to the app. Employee pictures are now able to be added to the form and to the gallery. Change the properties on the face card to display the picture as high resolution. Change the number of columns and customize the layout. 35:21 Use the User function Displays ‘Hi (employee name)’ depending on what user is viewing the app. 37:02 Publish to Teams Add the app to a channel and view the app in the channel that it was saved to. Changes that are made to the app are not visible to users until the app has been published. Additional Learning: Video: Create your first custom app for Microsoft Teams with Power Apps in 5 minutes - Dataverse for Teams Article: Power Apps Formula Reference Do you want to become a Power Apps Rockstar? Check out our different full length training classes at https://training.PowerApps911.com or you can download a working version of the app we built today by subscribing to the Curated Library .