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.

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

Read more...

Meet Datanaut Sandina Martinez

by Community Administrator 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.

Read more...

Meet Datanaut Xander Cell!

by Community Administrator ‎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.

Read more...

Meet Datanaut Flox!

by Community Administrator 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.

Read more...

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!

Read more...

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.

Read more...

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.

Read more...

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.

Read more...

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.

Read more...

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.

 

 

Read more...

Connection housekeeping

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

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

Read more...

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.

Read more...

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

Read more...

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.

Read more...

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.

Read more...

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.

Read more...

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

Read more...

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 Administrator

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.

Read more...

Attachment

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. 

Read more...

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!

Read more...

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 Administrator

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.

Read more...

Attachment

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

Read more...

Attachment

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 Administrator

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

Read more...