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

CRUD in Single-Page (Tablet Mode)

by hpkeong 2 weeks ago - last edited 2 weeks ago 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...

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

Read more...

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

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

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

Welcome to the new PowerApps Community Blog!

by Community Manager ‎12-14-2016 02:02 PM - edited ‎12-14-2016 02:03 PM

We want to hear what's got you thinking about PowerApps and business app development, from opinion pieces on the latest industry trends, to helpful tips and how-tos for your fellow PowerApps users, to "trip reports" from your local. It's your community blog, and we want to hear from you!

Read more...

Join the Blog
Interested in blogging for the community? Let us Know.

Labels