PowerApps Community Blog

Welcome to the PowerApps Community Blog

On this blog you will find articles, guides and information created by our community members and, from time to time, roundups and community news.

Malcolm Gladwell_Facebook_MBAS.png

Hear from bestselling author and like-minded analytics aficionado Malcolm Gladwell in a special closing keynote. Plus! Explore the session catalog.

Read more...

PowerApps_Flow_banner%20ad_728x90_MBAS.png

We’re excited to announce registration is open for the first-ever Microsoft Business Applications Summit, coming to Seattle July 22–24! Combining the best of the Microsoft Data Insights Summit, Convergence, and the Dynamics 365 Technical Conference, this new event is designed to help you create the best, lasting solutions for your business. Don’t wait – secure your spot today!

Read more...

Deep Dive: Click-Through PowerApps Analytics

by vivekb on ‎04-18-2018 07:02 AM - last edited on ‎04-18-2018 11:17 AM by mackenzie_lyng

In this blog post , we will walk through a simple approach to create your own click-through analytics. Extend your reporting options to include statistics which will raise visibility into how your app consumers navigate your applications, enabling you to use data to validate assumptions on app usage and design.

Read more...

Attachment

PowerApps Spring Update Blog Bundle

by mackenzie_lyng ‎03-21-2018 11:21 PM - edited ‎03-22-2018 02:21 AM

Spring Update Bundle baner.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

PowerApps Spring Update is here - and it's all about the Common Data Service! From model-driven apps to using the Common Data Service for Apps, here's a list of major announcements made this week on the PowerApps Blog

 

Read more...

Bulk updates for a filtered gallery

by Super User ‎03-18-2018 10:16 AM - edited ‎03-18-2018 10:59 AM

This blog with the video walks you through how you can update filtered items in bulk. In this blog items bulk updates have been done in an Excel spreadsheet present in OneDrive, however, you can do the same for SharePoint lists or SQL tables.

Read more...

Attachment

Happy Pi Day! 3.14...

by mackenzie_lyng ‎03-14-2018 02:35 PM - edited ‎03-14-2018 02:55 PM

Let's have some fun celebrating this milestone math day! Happy Pi Day PowerApps Community! 

 

ezgif.com-optimize (1).gif

 

Read more...

PowerApps Training App - new way to learn #2

by MichalRok ‎03-14-2018 07:56 AM - edited ‎03-14-2018 08:00 AM

Learn PowerApps directly in PowerApps with this interactive, hands-on material. This chapter covers galleries and data filtering, sorting and searching, in 10 tasks for you to complete.

Read more...

PowerApps Workflow Processes Part 1: Introduction

by Dawidvh on ‎03-13-2018 03:43 AM - last edited on ‎03-15-2018 09:09 AM by mackenzie_lyng

See PowerApps in action on multi-step Business Workflow Processes, that isn't hard-coded.

Read more...

MVP Global Summit | March 4-7

by mackenzie_lyng on ‎03-07-2018 02:10 PM

 

MVP Banner.PNG

 

 

 

 

 

 

 

 

 

The MVP Global Summit is happening this week in Redmond, WA. We are super excited to connect with all the MVP's and welcome them to our communities.

Read more...

Learn basics of controls, formulas, properties and navigation with 10 focused exercises - directly in PowerApps Studio.

Read more...

Attachment

Don't miss our live webinar on February 26 at 10:00AM PST (1:00PM EST) where Brian will showcase an amazing app for PATCHING SERVERS! You've got to see this one! 

Read more...

Tips and Tricks for multiselect controls with advanced tagging options

by paul_culmsee ‎02-18-2018 02:09 AM - edited ‎03-13-2018 04:00 AM

This article and accompanying video shows how with a little imagination, you can leverage recent managed metadata support in PowerApps in new and interesting ways for tagging content. Also learn some nice tricks around the use of canvas controls and relative positioning of controls

Read more...

This blog briefly talks about the main features used to build the vertical menu which will horizontal expand and collapse. A copy of the MSAPP has been attached for you to download and explorer.

Read more...

Attachment

Easily create multiple column based filters on any gallery or data table, while adding additional choices for items like "-All-", "-Me-", "-Today-" without having additional checkboxes, logic or if statements to get lost in.

Read more...

Attachment

This will be a multiple-part series on how I migrated my Access Web App to PowerApps. In this section I will focus on building a new screen which will be used to add and edit items.

Read more...

Community and Twitter side banner.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Share your posts and content directly from the PowerApps community to Twitter!

 

Read more...

How I migrated my Access Web App to PowerApps - Part 2

by Super User ‎01-11-2018 05:29 PM - edited ‎02-09-2018 07:46 AM

4 years ago I had written a TechNet Guru Award in the SharePoint category for writing an article on 'SharePoint Online: A no-code Solution to Create and Customize Access Service app using Access 2013'. Now I am going to migrate this Access App to PowerApps.  There is some urgency when it comes to migrating Access Apps because Microsoft has already stopped creation of new Access-based apps in SharePoint Online one June 2017 and will shut down any remaining apps by April 2018. For more information you can refer to the 'Updating the Access Services in SharePoint Roadmap'. You can also refer to the 'Introduction to PowerApps for Access Web Apps' developers document.

 

In this section I will focus on building the core design of the PowerApp and build the View Forms.

Read more...

How I migrated my Access Web App to PowerApps - Part 1

by Super User ‎01-11-2018 05:19 PM - edited ‎02-09-2018 07:43 AM

4 years ago I had written a TechNet Guru Award in the SharePoint category for writing an article on 'SharePoint Online: A no-code Solution to Create and Customize Access Service app using Access 2013'. Now I am going to migrate this Access App to PowerApps.  There is some urgency when it comes to migrating Access Apps because Microsoft has already stopped creation of new Access-based apps in SharePoint Online one June 2017 and will shut down any remaining apps by April 2018. For more information you can refer to the 'Updating the Access Services in SharePoint Roadmap'. You can also refer to the 'Introduction to PowerApps for Access Web Apps' developers document.

 

This will be a multiple-part series on how the migration occurred. In this section I will demonstrate the Access App and then migrate it to SharePoint Online.

Read more...

PDF Viewer for a better control and files selection

by Super User on ‎01-11-2018 08:13 AM - last edited on ‎01-11-2018 10:44 AM by mackenzie_lyng

One of the key features of PowerApps is the capability in viewing PDF file, either in

- Web (URL)

- One Drive or Google Drive

 

However, due to the default design of PDF Viewer, we can improve further on:

  1. Create a Button.OnSelect to resume to original FitBoth Zoom or Zoom to the size we wish
  2. Using Slider to replace the mini “+” & “-“ button to Zoom In / Zoom Out for a better user experience.

 

Read more...

Community Announcement | PowerApps Community Blog FAQ!

by mackenzie_lyng ‎01-09-2018 05:23 PM - edited ‎03-22-2018 02:14 AM

PowerApps Community Blog FAQ banner.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Have a question about our Community Blog! We got you covered. Check out the PowerApps Community Blog FAQ to get your answer! 

 

Read more...

Saving to SharePoint Managed Metadata columns using Patch function

by Super User ‎12-29-2017 07:44 AM - edited ‎12-29-2017 07:45 AM

This is a continuation of the 'Building PowerApps from Scratch? Use Patch!' blog.

This blog shows you how you can use the Patch function to save to a SharePoint Metadata column in a list.

Read more...

PowerApps - One Stop-Shop for Social Media Communication

by Super User ‎12-15-2017 05:49 AM - edited ‎12-15-2017 05:53 AM

This blog walks you through how you can use the two attached templates to build your own mobile PowerApp as a central place to post comments to Facebook, Slack, Twitter and Yammer. The three attachments includes a MSAPP file for the PowerApp, zipped file for Flow and STP file for SharePoint. The steps described in this article must be followed in the precise order to get the final app as desired.

Read more...

Attachment
Attachment

PowerApps: Get and save multiple selection values to Excel

by Super User ‎12-01-2017 02:10 PM - edited ‎12-01-2017 02:20 PM

This blog shows how PowerApps can be used to lookup values from an Excel spreadsheet stored on OneDrive, make multiple selections and then save it back to the Excel. 

Read more...

Fun with PowerApps: X and 0's

by Super User on ‎11-06-2017 01:00 AM

This blog is a part of my 'Fun with PowerApps' series. This blog talks about playing X and 0's using an app built using PowerApps. The blog itself briefly talks about the key features of the app, however, the MSAPP file is attached which you can download, open it your own PowerApp and publish it. The app is self-contained, i.e. no data connections are required for this app to fully function.

Read more...

Attachment

Don't want to use the Out-Of-Box PowerApps form but yet have the flexibility to save your data to a SharePoint list? Look no further, this blog walks you through the Patch function available to save your items to a SharePoint list. This is a no code solution blog and hence will not focus on the Metadata and Choice with multiple select checkbox columns. This blog focuses on how to add the Patch formula to save data to a SharePoint list and does not include all the features of the PowerApps, however, I have attached the SharePoint STP files and the PowerApps MSAPP file which you can use to rebuild this solution in your environments.

Read more...

Attachment

Fun with PowerApps : Circle of Dots

by Super User on ‎09-21-2017 05:44 PM

To my fellow PowerApps users, here is my free gift to you all! The fun PowerApp, Circle of Dots.

Read more...

Attachment

A PowerApps solution for audit scenarios

by paul_culmsee ‎08-30-2017 09:19 PM - edited ‎08-30-2017 09:34 PM

In my opinion, the one use-case that PowerApps is born for is handling checklist or audit scenarios. To this day, organsiations large and small fill in paper checklists that often end up in a filing cabinet, adding no value whatsoever. PowerApps - with a little help from Flow - has several compelling features to address this effectively. in this article, I am going to illustrate a great a solution to the audit challenge. Not only does it showcase the best of PowerApps, it was actually written by my daughter...

Read more...

PowerApps is so much more than just a web based form and this blog will demonstrate that first hand. Here we are building a powerful tablet app where users can watch the planets of our Solar System revolve around the Sun. The app gives the users the option to filter out any of the planets they don't wish to see while they are still revolving.

Read more...

Attachment
Attachment

How my daughter won a PowerApps contest with a fidget spinner

by paul_culmsee ‎08-14-2017 06:03 PM - edited ‎08-14-2017 11:35 PM

My 18 year-old daughter has no coding experience whatsoever. Yet after two week of learning PowerApps, she won a contest put out by the PowerApps team by developing a fidget spinner without using any trickery like animated gif's or embedded videos. This article shows how it was done...

Read more...

Embed Power BI tiles into PowerApps

by Super User ‎07-31-2017 05:34 PM - edited ‎07-31-2017 05:36 PM

This blog is an example of the latest feature which the PowerApps team announced on July 27th, 2017 i.e. the deep integration of Power BI with PowerApps. Now you can embed Power BI tiles into your PowerApp.

Read more...