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.

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 4 weeks ago - last edited 4 weeks ago

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

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

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 Wednesday by Community Manager

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

Read more...

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.

Read more...

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.

 

KittyFunSplash.PNG

Read more...

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

Read more...

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!

Read more...

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

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

CRUD with single record addition, updating or deleting, has no doubt, the most common practice when dealing with database in most of the industries.

 

However, Batch saving of data has always been the most efficient way of data input especially in a group of identical source.

Before the introduction of ForAll function, I had posted in the forum using Timer.OnTimerEnd, Collection and Patch to save a batch of data thru filtering and patching Single Data (record) at a time until the end of the row of the collection. Though the process is a real pain, but it did help temporarily solving batch data saving.

Read more...

PowerApps Pro Tips | Using Variables

by AllisonCaldwell on ‎01-31-2017 10:22 AM - last edited Wednesday by Community Manager

Learn how to increase user communication by using variables in PowerApps.

Read more...

Pro Dev Bullish on PowerApps

by hacking-awesome on ‎01-26-2017 09:49 AM

Could PowerApps be a panacea for expensive, custom developed mobile apps?

 

This pro dev thinks so! If you're an Office 365 organization, you should be considering PowerAps for your mobile app strategy.

Read more...

Conditional Navigation - Triggered by User Selection

by PowerApps Staff audrieg ‎01-24-2017 02:24 PM - edited ‎01-24-2017 02:38 PM

Most of the time we are adding navigation via an icon in the top navigation, or a direct tap/press on a "next" button for instance. However, there are other times when we want to determine navigation based on user selection on a screen. This is the use case of this blog, prompted by a few of our community members.

Read more...

Using multimedia in Microsoft PowerApps

by suvidha1 ‎01-22-2017 11:16 PM - edited ‎01-22-2017 11:26 PM

Microsoft PowerApps provides an option to add multimedia in the mobile applications. In this blog, I would like to briefly describe how we can use the available media controls in our Apps.

 

Media options

Read more...

Let's walk through the process of building a Line of Business (LOB) Mobile Application to allow employees to submit Long Term Parking Requests, using PowerApps and Microsoft Flow! The app is secured by our Company's O365 Account, we have email notification capability, and the data is easily accessed via SharePoint by Approved Personnel where it can be further processed as desired.​​

Read more...

PowerApps with SQL server on-premises – Using the Gateway, Part One

by suvidha1 on ‎01-11-2017 03:43 PM - last edited on ‎01-11-2017 03:46 PM by Community Manager

The gateway is a bridge from your app to the on-premises or virtual machine where your data is stored. The gateway can be deployed centrally and you can connect to your on-premises data and manage it securely from PowerApps. In this blog, I’ll demonstrate how we can create a simple App in PowerApps which can connect to on-premises SQL database. The App is created to capture Leads information from the user’s phone and the submitted data is saved to SQL database which is on-premises.

 

This post is part one of two parts.

Read more...

PowerApps with SQL server on-premises – Using the Gateway, Part Two

by suvidha1 on ‎01-11-2017 03:42 PM - last edited on ‎01-11-2017 03:47 PM by Community Manager

The gateway is a bridge from your app to the on-premises or virtual machine where your data is stored. The gateway can be deployed centrally and you can connect to your on-premises data and manage it securely from PowerApps. In this blog, I’ll demonstrate how we can create a simple App in PowerApps which can connect to on-premises SQL database. The App is created to capture Leads information from the user’s phone and the submitted data is saved to SQL database which is on-premises.

 

This post is part two of two parts

Read more...

SharePoint: Cascading Dropdowns in 4 Easy Steps!

by PowerApps Staff audrieg ‎12-20-2016 10:58 AM - edited ‎12-20-2016 11:06 AM

One of the common requirements I run into when it comes to app forms of any kind is Cascading Dropdowns. So since I'm sure we'll all need them at one time or another, let's run through the steps to create them in PowerApps.

 

Goal:

This will be demonstrated on a Change Request app form that collects very basic information about change requests. The app will have three fields: Category, Sub-Category, and Answer. The sub-category will depend on the category selected, and the question the user will have to answer will depend on the sub-category selected.

Read more...

Labels