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.

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

PowerApps Community Blog FAQ!

by Community Manager Tuesday - last edited Tuesday

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

Read more...

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

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