Search Content

Do you need to build forms and collect data from your users? Learn the best ways to save data back to the data source when building and working with controls in your apps by using the Patch, Collect, and ForAll functions. In this video you will learn about: The Patch function The Collect function The DropColumns function The ForAll function Link to the video on YouTube: Power Apps Save Data - Patch, Collect, and ForAll Link to the video for Curated Library subscribers: Power Apps Save Data - Patch, Collect, and ForAll Key timestamps: 0:00 Intro 1:45 Demo of the solution Shane demonstrates the functionality of his ‘Spooky Halloween Candy Tracker’ app. The data that is recorded for each house is sent straight to SharePoint. The app allows users to record data for both individual houses and groups of houses. 7:22 Walkthrough of the cat scratch image and sound effect The cat scratch image and corresponding sound effect are triggered when the user presses the ‘Enter if you dare!!!’ button. The UpdateContext, Clear and Navigate functions are utilized along with an audio control. 9:01 Brief overview of the Text input, Drop down, Slider and Rating controls The second Drop down control utilizes the If function and a Cascading Drop Down in order to display different options depending on what was chosen in the first Drop down control. 10:09 Walkthrough of the Patch function The ‘Record House’ button utilizes the Patch and Defaults functions to send the data to SharePoint. 14:41 Walkthrough of the Collect function The ‘Record House’ button on the Collection Style screen utilizes the Collect function to send multiple sets of data to SharePoint. The DropColumns function is utilized to drop the Bonus column because it has bad data. 21:20 Walkthrough of the ForAll function The ‘Save - Hard Way’ button on the View Collection screen utilizes the ForAll, Patch, and Defaults functions. Additional learning: Video: Power Apps AddColumns ShowColumns Video: Power Apps Patch Function 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 .

In this post, you will learn how to build a custom SharePoint List Form with PowerApps. Here, we will focus on the basics and get you through a few challenges along the way. As we dive in, some of the topics we cover include: SharePoint Integration connector, modifying the form, adding a button, and how to delete the form. Let’s get started! Create Your Form First of all, you will need to create a SharePoint list using the modern SharePoint experience. If you don't use the modern SharePoint experience to create your list, you're not going to have the same options we'll work with and discuss within this post. If you have used the modern SharePoint experience, you’ll see “PowerApps” on the top bar. For this example, we have created a list that includes: CEO Driver PowerApps Guru Dog To start, click on the first item, “CEO.” Once you do this, you’ll see that the default SharePoint List Experience opens, which you can then edit. At the top, you have the option to “Customize.” If you click on “Customize,” PowerApps will launch after about 20-30 seconds. Now, you can see that PowerApps and SharePoint work together to create a list form. Here you can see various fields. Some fields are editable, and others are not. And, just like that, you can create a fully functional form. Now you need to click on one of the Data Cards. Whatever property shows up in the fx column, hit space, and then go back and delete it. Basically, you’ve made a change and deleted it. Then go to “File” and “Save.” And, in a few seconds, that will save your app. Next, click “Publish to SharePoint”. Trick: If you do use the link SharePoint gives you, you have to wait for PowerApps to load and unload all the time. Instead, take advantage of the link they provide you in the “Save Menu” you’ve just used and right-click on it and hit: “Open Link in New Tab.” This way, you have one environment working on PowerApps and one with SharePoint. This will cut down on the back and forth between pages–which can be finicky. So, now you can work between the two tabs more easily. Now go back to your SharePoint list and click on “CEO.” You will see a new list. If you click on “Edit All”, you can see your PowerApps app and which fields are editable and not edible. Here, you can “Save,” “Cancel,” and “Copy Link,” etc. Now you have a custom form. (If you are new to PowerApps and SharePoint, there is a YouTube tutorial that you may want to watch first and come back to this post. You can find the link to the video here .) Modifying Your Form Next, switch back to your PowerApps tab, and you’ll see from a PowerApps point of view the automatic process created a “Form Screen 1” on the left-hand side. Underneath this, you’ll see they have only put one SharePoint Form. Take note that this is a little different from the default Sharepoint App that has 3 screens. (One for viewing, one for editing and new, and one for finding the item in the list.) Here they have all these in one screen instead. Understandably, this will take a little getting used to. But, they have based this form on how you have got here. So, how you got here is going to determine what ‘form mode’ the form is in. The way you can figure this out is that if you click on “SharePoint Integration” on the top left-hand side, and then click on the “Data Source” dropdown. This is where you control the form. If you click on “View”, it opens up the form and puts the form mode in View. And “Edit” puts the form mode in Edit. This is important for two reasons: It figures out what mode to be in. Showing you and giving you the proper experience you want. This is helpful as you explore more in-depth custom solutions down the line. Next, we’ll look at editing the actual forms. When you have the edit experience, you’ll see that you have several fields that you can’t edit. So, let’s try and get rid of these. So, go back to your SharePoint list and click on the “Modified Data Card”. Then click on the “Data Source” dropdown menu and go to “Visible.” Right now, you will see that it’s set to “True” in the fx formula. To change this, instead of “True”, enter “ sharepointform1.mode=Formmode.View, true, false ”. This simple formula will help clean up your editing experience and hide the things you can’t edit. However, you don’t want to deal with this formula all the time. And, we know that you can’t group Data Cards together. But here is what you can do: Editor Form Screen (you were just on Modified) Now, you go back to your Data Source dropdown menu. Select the ‘Visible’ property and change the property to: “Modified_DataCard1.Visible.” ‘ ID’ is another one you may want to hide, so paste: “Modified_DataCard1.Visible.” again to hide it. You can then do it for ‘Author’ too. Paste: “Modified_DataCard1.Visible.” The last one is ‘Created’, so change this to: “Modified_DataCard1.Visible.” So now, when the form is in ‘New’ and ‘Edit’ mode you are not going to have to worry about this. Now, “Save”, and Hit “Publish To SharePoint.” If you hit “Refresh”, and hit “Edit”, you’ll see the properties are still here. Remember, you will need to refresh again. Now you’ll see the changes that have been made. Be sure to hit refresh often, as this will help eliminate any hiccups. Take note: One of the downsides of hiding these fields is that it can lead to trouble down the line. You might forget you’ve hidden them, or maybe someone else needs to edit your app. To prevent this, you will need to create documentation. Go to “Form Screen 1”, click on “Home Screen” Click on “Screen 1,” then “New Screen” and you’ll see it pop up at the bottom. Call this “Documentation.” Next, insert a label and make it bigger, and place some text in here, such as this, "Modified_DataCard1.Visible hides the non-edible properties." You can now create documentation for your own benefit, and there is no way app users can access it. Create a Button Now, let's customize this app a bit more by adding a button. To start, grab the form box border and pull it up. So now you have a blank space to do something with. Let’s make a button that emails a link to users here. First, you are going to add a text input on the form. Click “Text” then “Input.” Now drag the text box down. Next, get rid of the default text in the fx formula. Click on “HintText” and then “Enter an email address” Then rename “TextInput 1” to “EmailTo” for example. Then hit “Button” on the top. Next, add “Data Source” to the button. A pop-up menu will appear on your right. Next, click on “+ add data source.” As an example, here you can choose the Outlook option. (If you need a tutorial on how to create emails, watch this video .) Now that you’ve added this, select the button and in the fx formula delete the default text and add: “Office365.SendEmail (EmailTo.Text, Check out this item, “SharePointIntergration. Selected”. You’ll now see all the properties for the current item you are working with. Then choose the “Link Property” option. Finally, you can change the text on the actual button and call it, “Email Link.” Now, go to “File,” “Save”, and hit “Publish in Sharepoint.” Now, go back to your PowerApps and hit refresh to save yourself from any frustrations. Click on “CEO.” The pop-up menu will now show your new button and you can test it. Place your email address in the box above the button. Hit the button below “Email a Link,” and you should see an email in your inbox. There will be a link within the body of the email that will open the item in your browser. What happens if you don’t like the form? Maybe you want to delete the form or start over? To do this, go to “List Settings.” Under “List Settings” you’ll see “Form Settings.” Here you will see three choices that you can select: 1. Use a custom form created by PowerApps: You will only use this option if you want to use SharePoint’s out of the box form. 2. Use the default Sharepoint form: If you want to get rid of your form altogether, use this option. That will switch it back to the SharePoint out of the box form. Now you’ll see “Delete Custom Form” appear below this option. That will delete it completely. 3. Use a Custom Form outlined in InfoPath: We won’t go into this option in this post. A Few More Things to Consider: Anyone using this SharePoint List needs to have a PowerApps license to use your PowerApps form. If someone else logs in, they will need to allow all the data connections. For example, because you added the email link, the new person logging in will need to agree to these. So, there you go. Now you know how to customize a SharePoint List Form with PowerApps. While we have used some basic examples, we hope that this forms a good foundation that will help you to customize your SharePoint list even more. And open up your minds to a variety of creative solutions. Build Your Own App with PowerApps Today Power Apps provides a rapid application development environment to build custom apps for both your personal or business needs. Apps built using PowerApps have a responsive design and can run seamlessly on your browser, and mobile or tablet devices. Whether you need assistance with an issue or complete project services, PowerApps is here to help. To watch the full video tutorial on how to Customize a SharePoint List Form with PowerApps, click here.

Learn how to share your Power Apps Canvas App with users who are outside of your company. If you need to share your Power Apps canvas apps with vendors, partners, customers, clients, or anyone outside your organization now you can thanks to Azure B2B sharing. In this video, you will learn about: sharing with Gmail accounts sharing with Office365 accounts using SharePoint external sharing and Office365 Manage Users to share apps troubleshooting Link to the video on Shane's video on YouTube: https://youtu.be/suk4eLS4A-E Key Timestamps: 00:00 It starts 2:06 Demo of the app Shane demonstrates his app and begins beginning steps on how to share with external users that have an Office 365 account. 3:07 Start sharing with an external Office 365 user via SharePoint Share Shane explains how to share the data source and app to the desired user. See what this looks like for the external user that you are sharing with. 8:55 Troubleshooting data source access issues Shane explains how to resolve a few issues you may come across when the external user is trying to see your app. 11:43 Inviting an external user in Azure AD from their Gmail account using the admin portal Shane uses recently created test email to help explain inviting external Gmail accounts. In the Azure AD portal, invite a guest user through their email. Understand the steps the user will have to take to access this app. 15:14 Creating a Microsoft Account with your Gmail address Your user must connect their Gmail to a Microsoft Account in order to view the app you shared. 19:10 Fix the "You don't have permission to view this data" error messages by sharing lists Ensure the guest user will be able to see what you have shared. 21:00 Brief overview of licensing external users Shane explains you must provide a license to users who do not have one from their organization. 21:52 Authentication vs. authorization aka who deals with passwords If you are facing any challenges, PowerApps911 can help you! We have mentoring services where we can talk you through fixing your problems. Or maybe you don't have the availability to work on this on your own... no worries! We offer full project services where we can do the entire build for you. Additional Learning: Power Apps Images to Email and PDF - YouTube 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 with Shane Young how you can use Power Apps and Power Automate to get attachments into SharePoint; no forms necessary! Included in this video: Attach files to SharePoint Attach images from the camera control to SharePoint Attach signatures from the pen input to SharePoint Link to Shane's YouTube Channel: https://www.youtube.com/channel/UC7_OGRP8BYvtGB8eZdPG6Ng Link to this video on Shane's YouTube: https://youtu.be/K74UFYgrKB4 Key Timestamps: 00:00 Intro 2:01 Demo of attaching a file to a SharePoint list item using power automate flow Shane walks through how he attaches a file to a SharePoint list from the app he built. No form controls are used; instead, independent pieces are used, then passed through a flow. 5:18 Demo of attaching a signature from the pen input control to a SharePoint list using power automate flow Shane uses pen input control and uploads it to his SharePoint list. 5:43 Demo of attaching a picture from the camera control to a SharePoint list item using power automate flow Shane demonstrates how to take a photo in camera control, then upload the image to a SharePoint list. 6:41 Begin to build as you follow along with Shane Creating the PowerApps inputs, including choices, for creating the item. 7:56 Get a PowerApps Attachment Control from a form Shane explains how to get an Attachment Control using a form. Save time on this build. Instead of trying to copy from this video, subscribe to YouTube Video Resource Library and be able to download all apps Shane uses in his videos. 13:08 Create a flow for uploading attachments to SharePoint Create an Instant Cloud Flow. Create Item and Add attachment actions. 21:44 Attach an Excel file to a SharePoint list item via Power Apps Shane explains how this work with any attachment, such as Excel files. 22:52 Use a Pen input to capture a signature with Power Apps and attach it to SharePoint 24:45 Take a picture with the PowerApps camera control and attach it to the SharePoint item Additional Learning: Power Platform for SharePoint 201 - On Demand Power BI 102 - On Demand All Access Subscription - On Demand

Shane Young demonstrates how to customize your SharePoint list forms with Power Apps. Learn how to get started, has SharePointIntegration control works, save, publish, and tips to make it easier for you to customize your SharePoint Online lists. Included in this video: getting started SharePointIntegration Control saving and security adding an Outlook and Power BI connector warning tips Link to the video on Shane's YouTube : https://youtu.be/2J9h8dqQlg8 Link to Shane's YouTube Channel: https://www.youtube.com/channel/UC7_OGRP8BYvtGB8eZdPG6Ng Key Timestamps: 00:00 It starts 1:38 Demo of a custom SharePoint form with an Outlook and Power BI Connection 4:13 Customize your first SharePoint form including save and publish Shane shows how to customize your first SharePoint form using PowerApps. Save and publish your form. 8:40 The forms DataSource and Items property 10:24 SharePointIntegration control .Selected record and .SelectedListItemID Shane explains what each of these are and how you use them. 12:00 Save, Publish, and open SharePoint list Do this in a second tab to make going back and forth quicker and easier. 13:18 SharePointIntegration Edit button, New Button, Save Button, Cancel Button, OnEdit, OnNew, OnSave, OnView, OnCancel Follow along on how to change buttons if needed to direct SharePoint to do what you need. 14:27 SharePointForm1 OnSuccess ResetForm(Self) RequestHide() 15:43 Add the Office 365 Outlook Connector Send an email with a button SendEmailV2. 18:19 Resize the display form Learn how to resize your form it doesn't look how you want. 21:06 Saving and security File, Save, Save As, Security Running the form stand alone, and why none of them work for these custom forms 22:36 Add the Power BI Tile 23:01 Manage your form Manage, hide, and delete your custom form from SharePoint List Settings Form Options 24:19 Warnings!!!! Shane shares his warnings on overusing this. Don't do too much! 25:25 Use the SharePoint Webpart Microsoft PowerApps Preview on a Modern Page Additional Learning: Power Platform for SharePoint 201 - On Demand Course Learn how to use Power Apps and Power Automate (Flow) with SharePoint Online. This course teaches you everything you need to know to start customizing today. All Access Subscription - On Demand Courses Gain access to ALL our On Demand content that we have available, along with Office Hours invitations and YouTube Video Resource Library access. Cancel anytime.

In this video, Shane Young answers the question of how to set default values based on a dropdown. By following along, you will learn to create a dropdown, and when your user selects a record you will then populate a text input, a different dropdown, a combo box, a collection, and even a people picker. Included in this video: set default values based on a dropdown use a dropdown to set various input values for Patch use a dropdown to set other field values use a dropdown to find a default user in a combo box use a dropdown to populate a collection from another datasource Link to the video on Shane's YouTube: https://youtu.be/1Q8L2H8cpEo Link to Shane's YouTube Channel: https://www.youtube.com/c/ShaneYoungCloud/videos Key Timestamps: 00:00 Start 01:34 Demo Shane shows his app and the problems you can solve with dropdowns. 04:01 Using a dropdown to set default values By using his app, shows how to use a dropdown to set default values of a text input, drop down, and a label. See what errors may show, and how to resolve them. 09:37 Shane goes back to the previous normal form to show more steps Setup a gallery, a form, and unlock some cards. Populate fields based on data from a different table data source. Understand what some common errors mean. 17:19 Questions from viewers - People picker field Look at how to set a combo box from the selection in a dropdown control used for a people picker and Office365Users.SearchUserv2 19:09 Use the chosen record in a Power Apps Dropdown to populate a collection Shane explains how he does this by using the OnChange property. Additional Learning: Power Apps and Power Automate 201 - On Demand Course Take your fragmented Power Apps and Power Automate skills and transform them into solid skills with this course. You know your business process inside and out, let us help you with Power Apps and Power Automate. Power Apps and Power Automate 401 (Advanced) - On Demand Course In this class, you will explore 8 different topics that will have you think at the next level. Each module will use a real-world example to illustrate how to implement the concepts discussed.

Learn how to make your first app in Power Apps with Shane Young's updated version of his PowerApps tutorial for Beginners. Follow along as you learn all the options available when creating your first app. Get started building now! In this video: Build your first app from SharePoint data Make customizations to your gallery Save, publish, and share your first app in Power Apps Advice from Shane Young to help you continue your learning journey Link to the video: Power Apps Tutorial for Beginners - Learn to make your first PowerApps Intro Link to Shane's YouTube Channel: Shane Young's Channel Key Timestamps: 0:00 It Starts Begin learning how to make your first app in PowerApps with Microsoft MVP, Shane Young. 0:26 Start at https://make.powerapps.com 1:08 Overview of Power Apps Template apps Shane explains that he recommends using the templates for inspiration, and not editing them. 1:44 Start from the beginning See the different ways you can begin creating your app. Begin with a Blank App or from data like, Dataverse, SharePoint, Excel, or SQL Learn why starting with SharePoint is best when making your first app. 2:32 Quick view at the SharePoint list we are going to use to build the app Shane shows a view of the SharePoint list that will be used in this video, which also has been used in countless previous videos on his channel. 3:13 Create a PowerApp from SharePoint list by connecting to SharePoint Copy the URL of the SharePoint list you are using. Choose 'SharePoint' in the 'Start From' section; by doing this, Power Apps automatically walks you through the process of automatically creating an app from this particular SharePoint list. Beginners will select 'Create a New Connection' on the left side of the desktop. Paste the URL you previously copied, and click Go. 4:20 Give your app a name and save it. A fully functional app is created for you. Click 'File', and give your first app a name. 5:18 Preview the app by using the play button Make sure you save your work to activate Autosave. See your app in action. 5:36 Mobile PowerApps vs. tablet or desktops apps Apps look different depending on the device you are using. The automatic process built a mobile Power Apps app. 6:04 View and edit your SharePoint items with the app Explore the SharePoint items that are now in your app. Learn how to view these items, as well as edit them if needed. 7:08 Create a new SharePoint record by using Power Apps Along with viewing, editing, and deleting; you can also create a new item in your app. 7:45 Editing the app in PowerApps Studio by introducing the Gallery control BrowseGallery is one of the controls in Power Apps. Galleries show you listed data. 8:54 Write your first formula using the Text function to format the number as currency like Excel Transform the current numbers into formatted numbers with the Text function. 9:58 Save and Publish your app Your users will always see your Published version of your app. You can always make changes, but until you publish those changes they will not be seen. 10:32 Share your app with a coworker and overview how PowerApps security works including co-owner and data permissions Share the first app created. Add a co-owner if you would like someone else to be able to use, edit, and share the app. 11:36 Ideas to explore the app more Congratulations! You have built your first app. Your next step would be to explore more of your app and understand options for adjusting items in your app. Learn more with our FREE introduction course. See details below. Additional Learning: Did you enjoy Shane Young's Power Apps Tutorial for Beginners? The fun doesn't stop there! Enroll in our FREE Introduction to Power Apps Course. - Power Platform 101 Do you have the hang of it and want to advance your skills even more? Check out the Live and On Demand Power Platform Training options that we have available! - PowerApps911 Training

Learn what are relationships, why Many-to-one, One-to-many, and Many-to-many aren't so overwhelming, and how to create the relationship. With your table structure in place we then go to Power Apps and update the relationship with Forms and Patch. Finally, we use edit data in Excel as the final tool to maintain these powerful relationships. Included in this video: Learn to use the Dataverse Lookup column to create relationships. Difference between Many to 1, 1 to many, and many to many Update Lookups with Forms, Patch, and Excel Viewing the related data and polymorphic lookups Link to the video on YouTube: Click here. Link to Shane Young's YouTube Channel: Click here. Key Timestamps: 0:00 It starts 1:58 Create a Dataverse table to use as our lookup table Shane shows on his desktop the table and Lookup columns that were previously built. In Dataverse, it will always show the primary name column. You can not change its name afterwards; be sure the name of your column makes sense for when you are looking up. 4:11 Quickly populate the new table Click Edit Data in Excel and add your sample data. Publish the data and refre sh. 5:43 Add a PowerApps Dataverse Lookup column to the table and connect it to the new table Connect your column to the new table in order to reference values you want to pull. 6:41 Explanation of a lookup or relationship between two tables Shane explains why you want to have related tables and a way to connect them. 8:01 Dataverse Add Relationship types Many-to-one, One-to-many, and Many-to-many. N:1, 1:N, N:N 12:58 Brief overview view of a Many-to-many relationship. This type of relationship is more complex than others. Shane gives a quick overview on what it is. 14:56 Create a PowerApps Canvas app to explore the relationship from the app side Create a blank app, insert a gallery, and select a data source. 16:30 Use a form to update a Dataverse lookup column from Power Apps Follow along with Shane as he uses his demo app to explain how he updates the lookup column. 17:54 Configure the gallery to display values from a lookup column via the polymorphic lookups Shane demonstrates how using a dot notation (.) to pull in all the fields from the relationship. 19:52 Use the Patch function to create a record with a lookup column Via a dropdown or a lookup function 24:25 Using the GUID primary key for the lookup Follow Shane as he explains how to use the GUID primary key and what it is. 25:49 Overview of the Relate function and Unrelate function With Many-to-Many you have to use the Relate or Unrelate functions. 26:33 Filtering on the Dataverse Lookup column Shane shows how to filter your data and show the information you are wanting to see quickly. 27:38 Use Edit data in Excel to modify a Lookup column If you ever need to manipulate the relationships on the Excel side, change the GUID column instead of text. Additional Learning: Power Apps and Power Automate 201 - Live or On Demand Take your fragmented Power Apps and Power Automate skills and transform them into solid skills with this course. You know your business process inside and out, let us help you with Power Apps and Power Automate. Learn more here.

Learn how to build a PDF from your SharePoint data by using Power Apps and Power Automate flow. No premium license, no 3rd party connectors, just simple actions put together smartly. Included in this video: Previewing the PDF in Power Apps Dynamic data including images Examples of more complex solutions Common errors and questions The new flow connector in Power Apps Power Apps v2 flow trigger in Power Automate Link to Shane's YouTube channel here . Link to this video on YouTube here . Key Timestamps: 0:00 It Starts Shane gives a quick overview on what will be covered in this video. 1:04 Demo of PowerApps app for creating a PDF from SharePoint Data Shane gives a demo of his app that he will be using in this video. 3:08 Connect to our data and view it in a gallery to get started Follow along as Shane connects his SharePoint list to a gallery. 3:26 Add an HTML Text Control to visualize the HTML for the PDF Select Text. Then in the dropdown, select HTML Text. This control is not required, but it does make it more simple to learn as you build. 3:50 Walk through the process of creating a PDF using Power Apps and Power Automate Flow Shane explains this process in just a few steps: Create HTML that represents the PDF we want to use then send it to Power Automate (Flow.) Next, (in Power Automate) convert the HTML file. Create a file using the output of previous file content. 5:08 Using w3schools to create HTML https://www.w3schools.com/html/defaul... Check out this helpful tool for dealing with HTML. 8:50 Using an HTML unordered list in your PDF By using the previous mentioned HTML tool, see how you can create html lists - in this case unordered lists (small black circles). 11:33 Getting an error when copying and pasting HTML with " instead of ' Understand the error you receive when inserting double quotes compared to single quotes. Correct all double quotes to single quotes to remove the error. 13:56 Using a Text function in your HTML Body to view a number as currency Learn how to view numbers as a currency type. In this video, Shane explains by using the example of inputting text as hourly wage. 15:26 Adding a dynamic image into your HTML for the PDF as base64 img src style width height Follow along as Shane explains how he will be adding an image to the HTML. 16:35 Getting the base64 of an image control by using the JSON function In order to add an image to the HTML, you need the base64. To get this you must process the image through an image control. Use the JSON Function to load the base64 of your image. When performing this in the future, always do this towards the end. This process may slow down your HTML. 18:32 Creating the Power Automate Flow with the Power Apps v2 trigger to create a PDF using OneDrive for Business Create file and OneDrive for Business Convert File Now open Power Automate, and create a new flow. Select Power Apps as the trigger. Add HTML as your input then follow these 3 steps: In OneDrive for business, follow along to create a file. Also in OneDrive, convert the file. Choose an operation - your choice. 22:25 Adding the flow to your Power Apps Add a button to your Power App and attach a Flow to it. This adds the flow as a data source in your app. 25:13 Common questions and errors I get about creating a PDF Shane explains common concerns when creating a PDF. 26:22 A couple of example of complex structures Additional Learning: Power Apps and Power Automate 201 - Live or On Demand Take your fragmented Power Apps and Power Automate skills and transform them into solid skills with this course. You know your business process inside and out, let us help you with Power Apps and Power Automate. Learn more here. If you prefer to learn on your own, there is a downloadable app included with this video in our YouTube training library for only $15/month

It's time to start learning! Do you need Power Apps and Power Automate to send emails from someone other than the person who pressed the button? Learn how sending emails out via SharePoint gives you more control to set the email To's title and have replies go to that person automatically. Just takes a small call to the SharePoint Rest API to do it. Click above to go straight to this video and follow along with the following summary. Link to Shane's YouTube channel: https://www.youtube.com/c/ShaneYoungCloud/videos Key Timestamps: 0:00 Power Apps and Power Automate Send a no-reply email from SharePoint Shane explains what will be happening in this video and what all will be covered. Let's get started! In this video, Shane will be explaining how to send a no reply email from either SharePoint or Power Automate Flow by using SharePoint Rest API. Why would you want to perform this action using this method? Maybe you do not like the fact when a user sends an email from Power Apps it either comes from that user or seems to come from nowhere. When using this method when sending an email from the SharePoint site, the email comes in as a no reply email and has the capability to have a specific From user. Also, if the receiver replies to the email, the reply can go directly to the From user that was designated. In conclusion, the emails sent using this method will not technically come from a specific user but replies can be sent back to the user performing this function. 2:00 Demo of the functionality Shane shows the demo of his Power App and how he performs this method. See how Shane utilizes this method by sending a no reply email from a PowerApps911 employee email to Chewy and himself directly from his demo app. Do you want quick access to all downloadable apps and code snippets Shane uses in his videos? Save time building on your own and check out Shane's YouTube Video Resource Library ! 3:53 Build a Power Automate Flow with a Send an HTTP request to SharePoint to Post to the Rest API Follow along with Shane as he explains how to build a Power Automate Flow. Open Power Automate Flow > Create > Instant Cloud Flow > Manually Trigger a Flow > Create > New Step > Search SharePoint > Send an HTTP Request To SharePoint (This does not require special licensing, only permissions. YAY!) Once Send an HTTP Request To SharePoint opens, follow along with Shane to learn how to fill in the blank fields with the needed information. 4:56 A listing of the little caveats of using this method Important points about using this method: It can not send emails to external users. It can not send attachments. It can do to BBC, and CC. It only works when sending to users the SharePoint site is familiar with - people within the user table / users who have used (or are associated with) the SharePoint site. To, CC, and BCC are all formatted the same in the Body field. Use square brackets [.] around one or more email addresses, each address within single quotes '.' and a comma between each address. Example: 'To': ['Shane@powerapps911.com','Chewy@powerapps911.com'] Shane shows the difference of using this method to send from a "fake" email address compared to a existing email address. 10:57 Changing the SharePoint Site Title to affect the From Title of the email Go to SharePoint site > Site Information > View All Site Settings > Title, Description, and Logo Under the Title field will be what is shown on the no reply email if you send from a non existing email address when using this method. Changing this field will give you the ability to change what users see when receiving no reply emails that you send. 11:36 Integrating the flow with a Power Apps app for dynamic content Shane explains how to perform this flow within an app in Power Apps inputting dynamic content. Refresh and add the Flow to your Power App. 16:12 Create the email string you need Follow Shane as he shows how to use Combobox and Concat. Run your flow. You did it! Additional Learning: If you prefer to learn on your own, there is a downloadable app and code snippet included with this video in our YouTube Resource Library for only $15/month! Do you want in-depth and self-paced Power Platform training? Are you looking to advance in your current role with the use of Power Platform? Take a look at our On Demand Training content and get learning today!

Are you looking for ways to save your business money in 2023? The Power Platform offers a variety of tools that can help you streamline your operations and cut costs. In our latest YouTube video, " 7 Ways to Save Your Business Money in 2023 with Power Platform ", we'll show you how to use the Power Platform to improve your business's efficiency and save money. What is the Power Platform? The Power Platform is included with Office 365, so if you already have Office 365, you already have access to the Power Platform. The platform includes Power Apps, Power Automate, and Power BI, which can be used to create custom apps, automate workflows, and create data visualizations. These low code/no code tools offer you unlimited possibilities for creating custom business apps without the expense of large-scale development projects. Inspection and Reporting Apps with Power Apps One effective way to reduce costs for your business is by creating a custom Power Apps Inspection and Reporting app. PowerApps can be used to streamline various types of inspections, such as vehicle inspections, product evaluations, and job checklists. By using PowerApps, you can eliminate the need for paper-based processes and expensive off-the-shelf software that may not fully meet your needs. PowerApps is user-friendly, low-code/no-code platform, making it accessible even if you have little to no coding experience. You can easily design an app that aligns with your specific business processes, rather than having to conform your processes to fit a pre-existing app. Automate customer contacts and leads with Power Automate Another way to save your business money is by using Power Automate for new customer intake and response. This can help you automate the process of responding to new customer inquiries and can save you time and money on labor costs. In the video, you will see an example Power Automate flow we use here at PowerApps911 for handling the thousands of contacts our website gets from people like you. It involves Cognito, SharePoint, Teams, MailChimp, and a whole lot of Cloud Flow automation. Lots of options in the Human Resources space Power Apps can also be used to create custom Human Resources apps with Power Apps . These apps can help you automate HR processes such as employee onboarding and can also help you manage employee data. This can save you time and money on labor costs, as well as help you ensure that you're complying with HR regulations. Some examples discussed include Offboarding/Onboarding, Kudos, Time Off requests, Performance review/goal tracking, and a full demo of how we do Job Tracking for our small business. Invoices: Add Artificial Intelligence to reduce human workloads The Power Platform also includes AI Builder, which can be used to create custom AI models without writing code. One way to use AI Builder is for invoice scanning. By automating the invoice scanning process, you can save time and money on labor costs, and also reduce the risk of errors. One example is doing double entry batching. Let the AI scan the invoice or receipt and extract the values. Then have a human do the same. If the human and AI got the same values, then move the invoice along. If there is a discrepancy, then start a manual reconciliation process. This will allow you to greatly reduce data entry errors without doubling the human workload. What is AI Builder? AI Builder is a feature within the Power Platform that allows users to create custom AI models without the need for specialized coding knowledge. It enables non-technical users to leverage pre-built templates and use their own data to train models that can perform tasks such as image recognition, text classification, and form processing. With AI Builder, businesses can automate tasks such as invoice scanning, sentiment analysis, and predictive maintenance, and integrate the AI models into their Power Apps and Power Automate workflows, to improve efficiency and save time and money. Expense and Spending management Power Apps can also be used to manage expenses and spending. You can create custom apps that help you track expenses, manage budgets, and even create custom reports. This can help you save money by identifying areas where you can cut costs. Every business has the need to track and report on spending. Let the Power Platform help you build solutions that fit your business exactly. Inventory and Asset Management In addition, the Power Platform can also be used for inventory and asset management. This can help you keep track of your inventory and assets and can also help you automate the process of ordering and tracking inventory. This can save you time and money on labor costs. Whether you track things today using Excel, Access, or just good ole pen and paper you can do better with the Power Apps and Automate. One of our construction customers replaced a six figure a year 3rd party tool with a custom Power App. Our favorite customer example we built Their app takes a user through the whole process. First you use a desktop Power App to create a Purchase Order. Adding vendors and products from an easy-to-use process. Once the PO is ready to go, they submit it via the app, it is then automatically turned into a PDF and sent directly to the vendor for fulfillment. When the products show up IT uses a mobile Power App to find, receive the order into inventory. The app uses the built in barcode scanner to scan serial numbers and asset tags. Now the items are in inventory they are assigned and distributed to the users. Nothing over the top. Just a simple app that is 100% tailored to their business process. Timesheets or time tracking are easy wins Finally, the Power Platform can be used to create custom timesheets, which can help you automate the process of tracking employee time. This can save you time and money on labor costs, and also help you ensure that you're complying with labor regulations. One customer saw massive ROI with their timesheet app because not only did they track hours, but they used the app to track equipment used on the job, which was billable back to their client. Their custom timesheet app literally made them money. What is next In conclusion, the Power Platform can be a great tool to help you save your business money in 2023. If you're interested in learning more about how the Power Platform can help your business let us help. If you are new to the Power Platform and want to see how it works, more examples, and how to build your first solutions then check out our Free Power Apps, Power Automate, and Power BI training . Each product is broken into its own section and will show you how to build your first app/flow/report. If you are more intrigued and are looking to have someone help you build your custom business solution, we do that also. Go to the bottom of this page and fill out the contact form. We can answer questions on what is possible, help you with any challenges you might be having with your app, or just build the whole thing for you. And of course, if you just want to see all of the apps and workflows you just read about remember to check out our PowerApps Example video .

Are you tired of working hard on Power Apps and not seeing the results you want? Look no further! In our latest video, we'll show you how you can use ChatGPT to instantly become better at Power Apps. Check out our video “Quit working so hard! Use ChatGPT 🤖 to instantly become better at Power Apps” to see it in action or keep reading to learn more. Improving Your Power Apps Code with ChatGPT First, let's take a look at how ChatGPT can help improve your Power Apps code with its advanced language processing capabilities. In our example, we walk through taking some HTML that we borrowed from w3schools and enhance it. By asking the right questions it adds for us a new column to the table, switches to inline styles, and shades the top row. Seem like small changes but the fact that ChatGPT wrote both the HTML and PowerFX code for us when they were intertwined is a game changer. Generating Code Comments with ChatGPT Next, we get to the feature that caused my “ah ha” moment. ChatGPT can do your code comments! 🤯 Do you also hate writing code comments? If so, then let ChatGPT write them for you. It is as simple as pasting in your code and saying, “Please write Power Apps code comments for the following code”. Boom. Commenting done. Then you can paste exactly what the 🤖 wrote back into Power Apps because they are formatted correctly. Understanding Complex Formulas with ChatGPT But ChatGPT isn't just limited to code improvement, it can also help you understand those complex Power Apps formulas that have been giving you trouble. In the example we give it a formula and ask for an explanation. Hooray. I now understand the crazy code that my co-worker wrote. Also, we didn’t show it in the video, but you could even ask if the code could be optimized. 🤔 Answering Questions with ChatGPT Then we get a bit more random for a lack of a better word. In the video we talk about using ChatGPT to answer questions. Showing both a multiple-choice exam question and a user question from Reddit. It is pretty crazy that you can just get answers. Now, they are not always correct, but they are good starting points for you to work from. So powerful! Getting Started with ChatGPT Finally, we'll share our thoughts on how to get started with ChatGPT and how it can revolutionize the way you work with Power Apps. Using ChatGPT can save you time, increase efficiency, and improve your skills with Power Apps. Don't miss out on this opportunity to improve your Power Apps skills with ChatGPT. The big key is you need to find your "ah ha" moment where you and the tool connect. Then it is game on! 😊 Don't forget to watch the full video on our YouTube channel “ Quit working so hard! Use ChatGPT 🤖 to instantly become better at Power Apps ” and discover how ChatGPT can help you instantly become better at PowerApps. Or better yet? We can help you get rolling with Power Platform with or without ChatGPT. Just click the Contact Us link and reach out. We promise a human, not a robot, will reply to you to help. 🥰 (At least for now)