cancel
Showing results for 
Search instead for 
Did you mean: 

Find articles, guides, information and community news

Most Recent
Rick72
Level 10

This blog post is part of a series called AMFTF (a message from the field) containing short blog posts about a best practice, a functionality, a how-to and/or something just worth writing a blog post about Robot Happy Todays topic is about making your apps a bit more perfect when switching screens. The function "Set" is used for this.

Read more...

Administrator Rank
Administrator

Flow and Power Platform Inaugural Event - Jan 10, 2019 from 6:00 PM to 9:00 PM (ET) 

 
 
Read more...

Rick72
Level 10

This blog post is part of a series called AMFTF (a message from the field) containing short blog posts about a best practice, a functionality, a how-to and/or something just worth writing a blog post about Robot Happy Todays topic is one of my best tips related to SharePoint forms.

Read more...

Super User Rank
Super User

This blogs focuses on how to add defaults to a SharePoint Customized (or PowerApps) form. The list in this demo includes all the column types including managed metadata. The video walks you through the steps in detail, however, this blog contains all the functions incase you want to copy and paste

Read more...

Super User Rank
Super User

This is the 5th in a series of blog posts regarding database design principles and PowerApps.  It presupposes that the prospective designer has reviewed the first 4 posts in the series and now has constructed the tables and defined the relationships between them.  All data points are reduced to their smallest logical component and each table has a single characteristic with fields that are either a number, currency, text, Boolean, hyperlink, or date/time and are not calculated from other fields.  Each cell of the table contains a single value or fact.  Each table has a primary key and there are no duplications of data between the rows. All tables are connected by Primary and Foreign keys. All Many-to-many relationships have been changed to two One-to-many relationships with a Junction table between them.

Read more...

Super User Rank
Super User

A very handy way to assist your Users in filling out forms is to autofill labels and TextInput fields for the City and State based on the user entering the Zip Code and then using the Lookup() function to pull in the City and State from a Lookup table.  This eliminates spelling errors and saves clerical personnel time as well since they only need to enter the Zip Code for any address. The technique involves bringing in the City, State and Zip Code data with the Excel Static Data connector.  This method also avoids delegation issues since Static Data is not affected by them.  A collection of >42,000 items can be created in seconds. Putting me on.pngYou're putting me on!

 

 

Read more...

Administrator Rank
Administrator

Due to a recent hotfix on the Community, please clear your cache if you encounter any problems with responsiveness. This will remediate the issue immediately.

Read more...

Administrator Rank
Administrator

PowerApps Mentorship Awards will be live online on January 7th, 2019 (11AM Pacific, 2PM Eastern). Hope to see you there! 

Read more...

Rick72
Level 10

This blog post is part of a series called AMFTF (a message from the field) containing short blog posts about a best practice, a functionality, a how-to and/or something just worth writing a blog post about Robot Happy Todays topic is about using a "Single line of text" column type instead of a "Lookup" column type in SharePoint Online.

Read more...

Super User Rank
Super User

This blog focuses on the on offline capability of PowerApps. Here you'll see the key features you need to add to your PowerApp in order to take input when there is no internet connection available and automatically upload it to your data connection. This written blog explains the features and the formulas/expressions used. The video deep-dives in the entire process. A copy of this app is attached to this blog.

Read more...

Administrator Rank
Administrator

Connect with the Microsoft Power platform team and other Power BI, PowerApps, and Microsoft Flow users at Power Summit Europe 27-29 March 2019 | RAI Amsterdam

Read more...

jamiewr
Level 8

98A8ED4E-D291-49FF-A608-AECAA13C3715.GIFCheck out my demo app that combines the Timer Control and some trigonometry functions to animate an old fashion clock face. 

Read more...

Administrator Rank
Administrator

Connect with experts, collaborate with your community and maximize learning opportunities at Microsoft Business Applications Summit. Back for its second year, this is the premier place for power users, analysts and technical architects to get hands-on with the tools you use every day – and get a sneak peek at what’s new and next. Registration is open – don't miss it! Read more...

Super User Rank
Super User

 

This blog pIt could work.jpgIt could work!!ost is the fourth of a series and it builds on the concepts and terms discussed in the preceding three posts.  At this point the designer has acquired all of the necessary data points and organized them into tables, each of which defines a single characteristic.  At this stage, it is important to add a Primary Key to each table and then link the tables together using these keys.  There are three possible relationships between the tables.  One to one, One to many and Many to Many.  This post will demonstrate how to connect the tables using the keys and how to deal with each type of relationship in the PowerApps setting.  

Read more...

Super User Rank
Super User

 

normal.gifThis post is the third in a series following the steps in designing the database that will provide the Back-end of a PowerApp.  The terminology assumes that you have reviewed the preceding two posts.  Hopefully, following this review, the prospective designer will be ready to take all of the data necessary for the application, break each datapoint down to its smallest usable components and then construct the tables.  The designer will then examine each table to eliminate redundency. This process is called Normalization.  A sample table will be provided and the first 5 forum members to successfully normalize the the table will be given double kudos.  

Read more...

Super User Rank
Super User

how-i-did-it.jpg“Start with the customer and work backwards” – Jeff Bezos

 

“If you don’t know where you are going, it’s unlikely that you will get there except purely by accident, involving innumerable trials and errors” – Me

Read more...

Super User Rank
Super User

Description
This blog shows you how to work with the CDS Entity Option Set fields for the PowerApps Patch and the Flow Condition to work successfully.
 
Scenario
Consider a ticketing PowerApp which is using a CDS entity. The status of the ticket is saved in an Option Set field in the entity. When the ticket is created the status is changed to In-Progress using the patch function and when the ticket is completed an email notification is sent using Flow.
Read more...

KroonOfficeSol
Level 10

This blog is about using Flow as an interface between PowerApps and SQL Server. I three simple to follow steps I will show you how to set-up this solutions.

 

Reasons to adopt this technic are:

  • Ability to store more then 2.000 records (limit connector)
  • Dis-connect the direct connection between PowerApps and your SQL Tables
  • Increase speed off your PowerApp
  • Overcome cashing issues SQL Server table content 

Are you more visual oriented then you maybe first want to look at this video

Read more...

Super User Rank
Super User

hump - Copy.gif"What hump?"It is amazing that you can actually create a App with PowerApps without understanding the principles of relational database design.  What is not amazing is how inefficiently the app will function with respect to creating new records, retrieving accurate and usable information, updating existing records that need to be changed, and deleting the right records without removing other valuable information from the database.

Read more...

tchin-nin
Level 10

Working on PowerApps with big data set is subject to "Delegation", a PowerApps feature made to ensure good performances into apps. This is a key concept as it will define which data source you are able to use to achieve what the business scenario requires. This post provides detailed explanations about the delegation concept. 

Read more...

Super User Rank
Super User

This blog describes how you can save multiple comments to an single data entry using one-to-many relationships. The blogs walks through how you use IDs from the tables to build the relationships. The demo includes a sample app used by a school teacher to save comments and scores of students, however, the same app can be used for other similar scenarios. Majority of the content is covered in the video, however, expressions and important links are provided here.

Read more...

Rick72
Level 10

This blog post is part of a series called AMFTF (a message from the field) containing short blog posts about a best practice, a functionality, a how-to and/or something just worth writing a blog post about Robot Happy Todays topic is about investigating if changing the setting "Data row limit for non-delegable queries" can improve performance for delegable queries.

Read more...

TimoPertila
Level: Powered On

article-image.png

 

Can I use a SharePoint list as a data store in my PowerApps? In case I will have more than 10 000 items? Or Should I use SQL Database instead? Are there any shortcomings with these options? How about Common Data Service for Apps?

 

I wrote this article with these questions on my mind.

Read more...

Super User Rank
Super User

This blog walks you through how you can use PowerApps in Power BI to save a snapshot of data available in a Power BI Report. In addition, we will add the option to add a comment.

Read more...

Rick72
Level 10

This blog post is part of a series called AMFTF (a message from the field) containing short blog posts about a best practice, a functionality, a how-to and/or something just worth writing a blog post about Robot Happy Todays topic is about a community initiative called 'PnP PowerShell'.

Read more...

Administrator Rank
Administrator

The redesigned experience for the PowerApps Community is up and running!

Read more...

Administrator Rank
Administrator

If you are attending Ignite 2018, stop by to meet the Business Applications Communities Team in the Microsoft Showcase Area on Level 2 in the West Hall of the Orange County Convention Center.

Read more...

Administrator Rank
Administrator

The PowerApps Community is about to get a whole new look!

Read more...

TimoPertila
Level: Powered On

Näyttökuva 2018-9-17 kello 18.23.59.png

 

In this article, I show how to build cascading selections in the PowerApps. First with a drop down control and after that with a combo box control. 

Read more...

Helpful resources

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