You can share a model-driven app, a security role and access to an environment all at once by adding a user to an Entra security group. This method of granting access makes it quick & easy to onboard a new user. And it also reduces the chance for errors during setup process. In this article I will show you my simple process for sharing model-driven apps. Table of Contents • Introduction: The Inspections App • Create An Entra Security Group In The Azure Portal • Locate The Security Role • Setup A Dataverse Security Team Linked To The Entra Security Group • Create A Nested Entra Security Gr ..read more

You can share a canvas app with a Microsoft 365 group along with any associated SharePoint lists. This makes granting access to an app quicker & easier. A user assigned to the group will automatically gain access to the app & lists at once. And it reduces errors because there is no chance you will forget to share the lists. In this article I will show you my method to simplify sharing for Sharepoint based Power Apps. Table of Contents • Introduction: The Cheque Requests App • Determine The Microsoft 365 Security Group Name • Get The Microsoft 365 Group Object ID From Azure • Enable Ap ..read more

You can create a button in Power Apps to download a file stored in a Dataverse file column. To do this, you must use the Dataverse Web API. If you haven’t used the Web API before it might be a little bit confusing. In this article I will show you how to use the Dataverse Web API in Power Apps to download a file from a file column. Table of Contents • Introduction: The Download File Button • Create The Dataverse Table With A File Column • Add A Download Button To A Canvas App • Construct A Dataverse Web API Request To Get A File • Store The Environment URL In An Environment Variable • Referenc ..read more

You can use Power Apps to display a list of SharePoint document library files along with their file type icon and file name. A file type icon is different for each file extension. There’s a PDF document icon, a Word document icon, an Excel spreadsheet icon etc. The file type icon is not included as a column in the datasource but we can get it by targeting the correct URL on the SharePoint static assets site. In this article I will show how you to include file type icons in a Power Apps gallery. Table of Contents • Introduction: The Documents Gallery With File Type Icons • Show File Type Icon ..read more

With Power Apps you can download a file from a SharePoint document library to the user’s computer. Depending on the browser’s settings the file might save to the downloads folder only or it might open immediately in a new browser tab upon download. My preferred method uses a special trick to force Power Apps to save to downloads folder only. In this article I will show you how Power Apps can download a file from a SharePoint document library. Table of Contents • Introduction: The Vendor Invoices App • Setup The SharePoint Document Library • Create A List Of Vendor Invoices • Show The Filename ..read more

Knowing how to append to an array in Power Automate is useful because you can take a set of individual objects and add them into a single array. Or to speak plainly, you can create a series of rows and combine them into a table. Using the append to an array variable action is the most obvious method but there are other techniques that are much faster. Table of Contents • Introduction: The Case ID Array • Method #1: Append To Array With Variables • Method #2: Append To Array Using The Compose Action • Method #3: Use The Select Action Instead Of Append To Array • Comparing Append To An Array Me ..read more

A Power Automate flow can unexpectedly fail to due invalid characters in a file name. To solve this problem we can obtain the file name and use Power Automate to remove characters from a string. I will show you two approaches to do this: defining a list of non valid characters and removing them from a filename and creating a list of valid characters and keeping them in the file name. Table of Contents • Introduction: The File Name With Special Characters #1 Remove Invalid Characters Method • Remove Characters From A String In Power Automate • Flow Expressions To Remove Characters From A Str ..read more

You can use Power Automate to an send email with a formatted and styled HTML table. With the help of the Create HTML Table action any set of SharePoint list items can be quickly converted into an HTML table. But that table will look pretty plain unless you apply some CSS to it. In this article I will show you my foolproof Power Automate method for HTML table styling. Table of Contents • Introduction: The Daily Cash Receipts Report • Setup The SharePoint List • Create An HTML Table From SharePoint List Items • Design And Apply An HTML Table Style • Send An Email With An HTML Table Style • Form ..read more

Want Power Automate to embed an image in email? I’ve done the research and I will show you the best ways to do it. Displaying an image properly in all email client is not an easy task. My goal was to find the most compatible and the cleanest method possible while still using standard licensing. And if you have a premium license I’ve got a neat trick to share with you that uses the Microsoft Graph API. Table of Contents • Introduction: The Email With An Image Automation • Setup The SharePoint Document Library • Method #1: Embed Image In Email Using Content ID • Method #2: Embed Image In Email ..read more

Power Automate email templates can show dynamic values from SharePoint as part of a beautifully formatted message. I’ve researched the best method to create responsive Power Automate email templates and I’ll show you where to find templates, how to add dynamic values and include images. You can customize it even further with your knowledge of HTML and CSS. Table of Contents • Introduction: The New Project Task Email Notification • Setup The SharePoint List • Trigger The Flow When An Item Is Created • Select An HTML Email Template • Send The Email Template To The Assigned Person • Fill-In The ..read more