Top 10 Power Apps Articles Of 2022

I started my Power Apps blog in June 2020. I wanted was a place where I could write about the cool things I was learning and to document my best practices. I did not expect my blog to receive much attention at all. All I had was a simple goal. Just keep writing.

In 2022 there were 2,000,000 pageviews for matthewdevaney.com. Last year there were 700,000 pageviews. Why does this website continue to grow? I think there’s a few reasons:

• Consistency: I’ve written a new article every week this year
• Quality: I aim to write articles that most people can follow with little prior knowledge
• Power Apps: It continues to grow, and the need for Power Apps content grows along with it.

Anyways, enough about me. To anyone reading this message – anyone who has subscribed to my blog, retweeted my articles or said a kind word to me in private I want to say…

Thank You for giving me the incredible opportunity to help you make awesome Power Apps.

You are the reason I continue to write.

10. 2022 Power Apps Coding Standards For Canvas Apps

Welcome to the Power Apps Coding Standards For Canvas Apps.

In this guide you will find 50+ pages of coding rules, guidelines and best practices I use everyday to create Power Apps Canvas apps. I have spent the last 3 years building Power Apps every day. Now I want to share the knowledge I’ve gained in this set of easy-to-understand, actionable examples.

Click here to read the article

9. The Secret Way To View Word, Excel & PowerPoint Files In Power Apps

Power Apps has a secret Word, Excel and PowerPoint document viewer hiding in plain sight. It’s actually the PDF viewer. No, the PDF viewer can’t do this by default. But with one-line of code you can use Power Apps PDF viewer to show docx, xlsx, and pptx files instead of pdf files. It is very easy to implement. You just have to know how to do it.

Click here to read the article.

8. Show/Hide Button In Power Apps Based On The Current User

Need to show or hide a button in Power Apps based on the current user?  There are several ways to do it.  The quickest way is to comparing the current user’s email to a hardcoded value to see if it matches.  But the better way is is to check if the current user belongs to a specific Azure AD group or is found in a SharePoint list.  In this article I will show 3 ways to show/hide a button in Power Apps so you can decide which one is best for you.

Click here to read the article.

7. Power Apps Tabbed Form With An Awesome-Looking Design

When a Power Apps form is very long a tabbed form can make it more organized and easier to use.  A tabbed form is simple to build – create one button for each tab at the top of the form, when the user clicks on a tab store it’s name in a variable and then show only fields that should appear on that tab.  Your users will love having all similar fields grouped together one one screen without having to scroll.

In this article I will show you how to make a good-looking design for a Power Apps form with tabs connected to a SharePoint list.

Click here to read the article.

6. Power Automate Desktop: Data Entry From Excel To Website

Power Automate Desktop is a free application from Microsoft you can download to automate personal or business-related tasks on any Windows computer. One of the most popular use cases for Power Automate Desktop is taking data from an Excel and file and entering it into a form on website. Its absolutely amazing to watch as your computer quickly completes the boring task that used to take you hours. In this step-by-step tutorial I will show you how automate data entry from Excel to a form on a website.

Click here to read the article.

5. 7 Ways To Use The PATCH Function In Power Apps (Cheat Sheet)

Power Apps PATCH function is the hardest function to understand. Why? The Patch function is the only function you can use 7 different ways. Yeah, you heard me right. Seven. That’s why I built a no-nonsense cheat sheet that you can use to quickly figure out how the patch function works.

Note: in all of the examples below the datasource called Employees where records are being created/updated is SharePoint list.

Click here to read the article.

4. Easiest Way To Generate A PDF In Power Apps (No HTML)

With Power Apps you can take the data entered into a form and use it to create PDF. This feature is not available out-of-the-box but I can show you how to build it. To do this we will build a basic form in Power Apps. Then we will design a Word document template and use Power Automate to fill and convert it to PDF. From there you either store the PDF in a SharePoint document library or sent in as an email attachment. In this article I will reveal the simplest way to generate a PDF form in Power Apps.

Click here to read the article.

3. A Fool-Proof Way To Share Power Apps With External Users

Power Apps created for use inside a company can be shared with external users outside of the organization as well. External users require the same licensing as internal users but there is a different method to set them up vs. internal users. We can make sharing easier by placing all Power Apps external users inside of an Azure Active Directory security group and automatically granting app access and licensing to all users within the group In this article I will demonstrate a fool-proof way to share Power Apps with external users.

Click here to read the article.

2. 3 Ways To Filter A Power Apps Gallery By The Current User

Want to filter a Power Apps gallery by the current user? There are many ways to do it. The easiest way is to get the current user’s email and use a filter function to show only matching records in the gallery. A more secure way is to set item-level permissions by building a Power Automate flow or changing permissions in the list settings itself. In this article I will show you 3 ways to filter a Power Apps gallery by the current user so you can decide which is best for you.

Click here to read the article.

1. The Complete Power Apps Functions List

Welcome to The Complete Power Apps Functions List.

On this page you will find a categorized list of 150+ Power Apps functions with links to the official documentation. Experimental functions like PDF and ParseJSON are also included. Power Apps already has an official formulas reference so why did I do this? A few reasons:

• I wanted a functions cheat sheet where I could quickly see all the functions and how to write them
• Organizing all of the functions into categories makes it easier to discover new ones
• Gaps in the official Power Apps documentation can be filled-in with my own commentary

I hope you enjoy the Power Apps Functions List.

Click here to read the article.

Questions?

If you have any questions or feedback about Top 10 Power Apps Articles Of 2022 please leave a message in the comments section below. You can post using your email address and are not required to create an account to join the discussion.