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.

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.



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...


Embed Power BI tiles into PowerApps

by darogael ‎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.


Meet Datanaut Sandina Martinez

by Community Manager on ‎06-08-2017 12:50 PM

This week we announced some of the community events you can expect at the Microsoft Data Insights Summit next week, and debuted the Datanauts, a collection of space defenders representing Excel, PowerApps, Flow, and Power BI.


Today, meet Sandina Martinez.


Meet Datanaut Xander Cell!

by Community Manager ‎06-07-2017 01:05 PM - edited ‎06-07-2017 01:06 PM

This week we announced some of the community events you can expect at the Microsoft Data Insights Summit next week, and debuted the Datanauts, a collection of space defenders representing Excel, PowerApps, Flow, and Power BI.


Today, meet Xander Cell.


Meet Datanaut Flox!

by Community Manager on ‎06-06-2017 12:08 PM

Yesterday we announced some of the community events you can expect at the Microsoft Data Insights Summit next week, and debuted the Datanauts, a collection of space defenders representing Excel, PowerApps, Flow, and Power BI.


Today, meet Flox.


Can't make it to Microsoft Data Insights Summit? We’ll bring the conference to you!


We’re livestreaming our three keynotes and nine of our most popular breakout sessions, June 12–13, 2017 so you can learn alongside attendees. As Microsoft’s conference for business analysts, the Microsoft Data Insights Summit is filled with strong technical content to help you build a data culture at your organization.


See the full livestream schedule below. Mark your calendar and get ready to transform the way you work!


Translator App demo

by SandyU on ‎05-31-2017 11:42 AM

Main Menu screen.pngThis article walks through creating a "Quick Translator" app, which allows you to quickly translate commonly used words into the language of your choice, in both text and speech. It demonstrates use of the Microsoft Translator service connection, and each of its available methods.


In PowerApps Studio, you can now see how your variables interact with the page, and with other items on that page. This new feature is a great way to see how one item in PowerApps might affect the rest of your app.


Read Evan Chaki's original post on the Confluent blog, or keep reading below.


Assuming that you sign in PowerApps with a WorkMail, in your dept. but you have few users, and you wish to control who use the apps, access right, etc.Though this may not be a good idea due to data security, but it is a way of designing control right.


Known for his award-winning global achievements in infographics and multimedia as a professor, author, journalist and designer, we are excited to welcome data visualization expert Alberto Cairo back to the Microsoft Data Insights Summit, taking place June 12-13, 2017 in Seattle. This year Alberto will provide a special guest keynote focused on the different dimensions of data visualization and how to entice your audience to engage with your information.


PowerApps Pro Tips | Patching SharePoint Lists

by AllisonCaldwell ‎05-01-2017 11:49 AM - edited ‎05-02-2017 06:06 AM

Detailed instructions on how to build a PowerApps Sharepoint connection.




Connection housekeeping

by SandyU on ‎04-24-2017 11:56 AM

A quick tip about viewing and deleting Connections, for both PowerApps and Flow.


Learn how to get the most from your data — and the Microsoft tools you use every day — at the Microsoft Data Insights Summit, the company’s user conference for business analysts. Now in its second year, the event is packed with strong technical content, hands-on workshops, and a great lineup of speakers. And back by popular demand, you can now book an appointment with a Microsoft expert with our recently launched online Schedule Builder.


How to build a Message Box

by darogael on ‎04-14-2017 11:57 AM

This article walks you through how to build a message or dialgue box


With more than 5 million copies sold in 40 countries, Freakonomics is a worldwide phenomenon — and we’re thrilled to announce that authors Steven Levitt and Stephen Dubner will join us for a special guest keynote at Microsoft Data Insights Summit, taking place June 12–13, 2017 in Seattle.


We recently shared our full session catalog for this year’s Microsoft Data Insights Summit. This week we want to highlight some of the featured speakers  we’ll have at the event. The Data Insights Summit includes an amazing mix of BI experts, product partners, community members, and Microsoft product engineers – all at the conference to help you learn how make the most of your data. We’re thrilled to spotlight Amanda Cofsky, Brian Jones, Chris Webb, Danielle Dean, Jennifer Stirrup, Justyna Lucznik, Kim Manis, Marco Russo, and Rob Collie.


In February, we announced that our Microsoft Data Insights Summit will return for the second year, and invited you to register and join us June 12-13, 2017 in Seattle, WA. This is THE user conference for Power BI, SQL Server BI, Excel, PowerApps, and Flow.


What this 4 minute video to demo what the blog has to offer!


CRUD in Single-Page (Tablet Mode)

by hpkeong on ‎03-13-2017 11:16 AM - last edited on ‎03-13-2017 11:40 AM by Community Manager

PowerApps Group has provided an excellent Phone-Layout 3-Screens CRUD Apps and generate automatically using existing data.


For PC-Tablet Layout, it is yet to be included by PowerApps Group.


Nevertheless, 3-Screens CRUD may NOT be so practical for Big-Screen devices. Hence, I have resorted to making app for PC-Tablet Layout with ONE-SCREEN CRUD, so that it looks neat, faster response, no-navigation and hopefully, with less resources used, the apps will response much more smoothly.



We’re excited to announce the Microsoft Data Insights Summit, our user conference for business analysts, is back June 12 – 13, 2017 in Seattle, WA. This two-day event is designed to help you identify deeper insights, make better sense of your data, and take action to transform your business. The conference sold out last year – and we don’t want you to miss out – so we encourage you to reserve your spot soon. 


Announcing App in a Day Workshops | April 18-19, DC & NYC

by AllisonCaldwell ‎03-07-2017 08:49 AM - edited ‎03-07-2017 08:53 AM

Send customers to one of two App in a Day workshops (so far!) -- April 18 in DC, or April 19 in NYC!


Apps with Batch Saving & Single Record Updating [Part 3: Final]

by hpkeong on ‎02-28-2017 01:16 PM - last edited on ‎02-28-2017 01:17 PM by Community Manager

Continue from Part 2…


In the previous Chapter, I had shared on the basic coding for SAVE New data.

In this Final Chapter, let's concentrate on how can we UPDATE a single record using

- UpdateIf function based on CONDITION


Why use Toggle?

As I was responding to @OlaH’s question, and understand that using Toggle looks more gorgeous and App’s like looking, I also found that Toggle is very suitable for small screen, user-friendly and widely used in most of the Apps.



When learning jQuery, various plug-in program attracted me. One of the useful plug-in program for data viewing is “Pagination”.


Today, I spare some free time and wish to share how to utilize PowerApps simple formulas to create the same function.

Formulas used in creating pagination cover only:

- If

- UpdateContext

- RoundUp & RoundDown

- CountRows

- LastN & FirstN



PowerApps Pro Tips | Full Screen Image Pop-Outs

by AllisonCaldwell on ‎02-21-2017 11:22 AM - last edited on ‎05-24-2017 12:57 PM by Community Manager

Learn how to create full screen image pop-outs in PowerApps


Cascading dropdowns for single line of text

by darogael ‎02-17-2017 01:02 PM - edited ‎02-17-2017 01:40 PM

This blog walks you through the process of how you can create cascading dropdowns in a PowerApp and save it to a  single line of text column. In this blog a SharePoint list with three single line of text columns has been used to save the item. In addition, three separate lists are used for the cascading dropdown data.


Kitty Video App - Demo of Video Control Usage with YouTube

by PowerApps Staff audrieg ‎02-12-2017 03:06 PM - edited ‎02-12-2017 03:07 PM

I made this little PowerApp today just to demo the way you can use the Video Control with YouTube Videos. Let me know if you'd like to dive deeper into this one, but I think it's pretty straight forward.




Apps with Batch Saving & Single Record Updating [Part 2]

by hpkeong ‎02-08-2017 10:27 AM - edited ‎02-09-2017 04:50 AM

Continue from Part I


In the LAST Chapter, I had shared on the basic coding for the UI.


Today, I will continue to explain on

- Counter (for No. of Students)

- Saving (in Batch) to another Attendance DataSource


Expediting App Builds Using PowerApp Templates!

by PowerApps Staff audrieg ‎02-01-2017 07:02 PM - edited ‎02-01-2017 08:32 PM

The built-in templates available in PowerApps Desktop Studio are helpful for building apps that look beautiful, and just work right out of the box! Let's learn how to build a Service Desk app from a template today, and how to personalize it for release to our team tomorrow!