Let’s get started
Please enter your work or school account to get started.
For information about known limitations, see Common issues and resolutions.
Note: The version number of the most recent release of PowerApps varies by platform. To ensure that you have the most recent release of PowerApps for your platform, install it from the Windows Store, the App Store, or Google Play.
Show data in a gallery that resizes to fit items of different heights.
Add a variable-height gallery if you have, for example, text (such as a product description) that varies widely in length. By taking this approach, you can show entire descriptions without unnecessary whitespace in a vertical gallery.
Determine whether strings of text start with a sequence of characters that you specify.
Use the StartsWith function so that users can, for example, type a few letters in a search box to filter a list of items based on the text at the start of a field.
Determine whether strings of text fit a pattern that you specify by using a regular expression.
Use the IsMatch function to return a true/false value based on whether a field in a record matches, for example, a name, an email address, a phone number, or a U.S. Social Security number.
Customize the order in which controls are activated when users press the Tab key.
By default, the XY coordinates of each control determine the tab order. To specify a different order, set the TabIndex property of one or more controls to an integer greater than zero. If, for example, the value of a control is set to 1, it will be activated before a control for which the value is set to 2 or higher. You can make your app more accessible by adding tooltips and ensuring that the tab sequence of each screen is optimal.
Customize the thickness of a slider rail.
Users adjust the value of a Slider control by dragging its handle to the right or the left along its rail.
On Android devices, refresh the list of apps by tapping a button instead of swiping down.
For more information, see Use PowerApps on a phone or a tablet.
Bug fixes and performance improvements.
Support for universal links on iOS and Android devices.
Back button support on Windows Phone devices.
When you press the Back button, the app closes.
Better experience when you delete an app.
When you delete an app from https://web.powerapps.com, the app is deleted when you reopen PowerApps Mobile or Dynamics 365.
Support for context variables in delegable expressions.
Improved memory usage when you run an app.
Added AutoHeight property to the HTML text control.
Improved performance and fixed a variety of bugs, including in the Microphone, Ratings, Dropdown, and Camera controls.
Windows Phone 10.
A preview release of PowerApps Mobile is available for Windows Phone 10. For more information, see Use PowerApps on a phone or a tablet.
Run apps in any of several languages.
Manage apps and data in specific environments.
For more information, see Environments overview.
Specify a description for each app that you create.
By adding descriptions, app creators help users find the best apps for their needs.
Better support for the Back button on Android devices.
You're prompted to confirm whether you want to close the app.
Bug fixes and other improvements in performance, diagnostics, connections in shared apps, and accessibility.
Apps open faster and are easier to use with a screen reader or just a keyboard. We've improved the dialog box in which you confirm or change connections when you open an app that someone shared with you. We've added a Session details option, which contains diagnostic information such as a session ID. We've made gallery layouts more accessible and made other improvements throughout the product.
Available in several languages in addition to English.
Select and rename controls more easily.
When you select a control, its name and the name or names of any parent controls appear in a "bread-crumb" element near the lower-left corner. You can open the Rename text box by double-clicking the name of a control at the top of the right-hand pane or by double-clicking the name of a screen in the left navigation bar.
Find options on the toolbar more easily.
Show the Advanced view of control properties more easily.
Review and update property values of the selected control in the Advanced tab of the right-hand pane.
Refresh data in generated apps more easily.
When you automatically generate an app, the default browse screen contains a refresh button. Users can click or tap the button to display the most recent changes to the data from its source without closing the app.
Show two display fields in lookup controls.
Update multiple records at once by using the Patch function.
Create or update more than one record at a time by specifying a table of base records and a table of change records as arguments for the Patch function.
Perform calculations and actions on a set of records by using the ForAll function.
The ForAll function evaluates a formula for all records of a table. The formula can calculate a value and/or perform one or more actions, such as modifying data or working with a connection.
Calculate exponential values by using the Power function.
Better sorting and filtering across sessions and devices.
If you sort or filter your list of apps on a mobile device, that setting is retained even if you close PowerApps. If you sort your list of apps by when you opened them most recently, the sort order is accurate even if you opened an app on a different device.
Improved mechanism for providing feedback.
Instead of clicking or tapping the smile icon near the upper-right corner, create a ticket by clicking or tapping Contact on our support page and then providing information about your question.
Because of administrative details, different platforms show different build numbers, but 2.0.510, 2.0.511, and 2.0.512 were released at effectively the same time.
Open apps in iOS 10.
Mark favorite apps on iOS and Android devices.
You can mark an app as a favorite and show only your favorite apps in the list of apps that you can run.
Swipe down to refresh the list of apps on iOS and Android devices.
Delay property for text-input controls.
If you set the OnChange property for a Text input control to an action, that action occurs, by default, every time that the user types a character in the control. For example, a user might type seven letters in a search box, and the results will update every time the user adds a letter, which uses network bandwidth unnecessarily when a data source is searched. If you set the DelayOutput property for that control to true, the action doesn’t occur until the user types one or more characters and then stops typing in that control for a period of time.
Mathematical functions added.
Barcode scanner for UPC, Codabar, and other types of codes.
For step-by-step instructions and information about best practices and limitations, see Scan a barcode.
App templates that showcase the Common Data Model.
Use a template to quickly create a phone app to manage cases or a tablet app to register contacts for a contest. These templates are based on standard entities in the Common Data Model.
Bug fixes and performance improvements.
Use the entities in the Microsoft Common Data Model to build apps.
Store organizational data in standard or custom entities, build and share apps based on those entities, and open the entities in Excel to easily view and edit the data. For more information, see Understand entities.
Connect to data in an on-premises SharePoint site.
Show and manage data in an on-premises SharePoint site by using a data gateway. For more information, see Connect to SharePoint.
Get push notifications on your Android device when apps are shared with you.
Run apps using PowerApps Mobile on Android N.
Create and modify an app in a browser.
You can create and modify apps by opening either PowerApps Studio or a browser such as Edge, Chrome, or Internet Explorer 11. For more information, see Create an app in a browser.
Create an app from within a modern list in SharePoint.
For more information, see this blog post.
Add or duplicate a screen
In the left navigation bar, you can click or tap the ellipsis for a thumbnail and then click or tap New Screen to add a screen or Duplicate Screen to copy the current screen. In either case, the new screen appears just below the current screen instead of at the bottom of the navigation bar.
Dates and times when you create an app automatically.
If you create an app automatically from a data source that includes date information, the app will show that information on EditScreen1 in a DatePicker control by default. If the source also includes time information, it will appear in Drop down controls.
New sample apps and templates.
You can open a sample app that demonstrates a scenario such as showcasing products, surveying employee engagement, checking out assets, and helping a new employee choose a health plan.
Pass parameters while running an app in the browser using a query string.
Deprecated data sources from Project Siena.
If you created or updated an app in the beta 4 release of Project Siena to include data from any of these sources, that data will no longer appear if you run or edit the app in PowerApps:
If you open the app for editing, an error icon will notify you which control or controls have properties that refer to a deprecated data source.
Show and manage data in an on-premises SQL Server database by using an on-premises data gateway.
PowerApps on Firefox.
You can run apps in the most recent version of the Mozilla Firefox browser.
SharePoint Update control.
This control has been deprecated in favor of the Edit Form control. An app that contains the SharePoint Update control will still open, but the control itself will no longer appear.
Add data while customizing a form.
With a form selected, tap the data source for the form (or No data source selected) in the right-hand pane, and then tap Add a data source.
App from data now fully delegated for SQL Azure and Salesforce connections.
When you create an app from data for a SQL Azure or Salesforce connection, the resulting app now delegates all operations to the service. It's now possible to work with large data sets with these generated apps.
Instead of generating formulas based on Filter and Sort functions, we now generate formulas based on Search and SortByColumns functions. These new functions are easier to delegate to a data service because they don't depend on an arbitrary formula.
New Search function.
Acting as a specialized Filter function, the Search function takes a single string to look for and a list of text columns to search within. This function also automatically returns all records if no search term is present, suitable for direct use with a search Text input control. For more information, see the Search function documentation, or take a look at the formulas generated when you create an app from data.
In operator now supports delegation.
Feel free to use this operator in Filter functions to accomplish the same effect as the Search function.
Show PDF files that are protected by a password.
If you configure a PDF Viewer control to show a file that requires a password, each user must provide the password to view the file. To remove the password requirement, set the Password property of that control to the password for that file.
Coordinated Universal Time in the DatePicker control.
By default, the DatePicker control interprets all date values in the local time zone. If your input is given as midnight in the Coordinated Universal Time (UTC), it would show a date one day off in certain time zones. For example, a DatePicker control shows Dec. 31, 2016, if you set its DefaultDate property to “2017-01-01T00:00:00Z” and you’re in the Pacific time zone (UTC-0800). To ensure that the control shows those values correctly, change its DateTimeZone property from Local to UTC.
We've consolidated the Options and Quick Tools panes, and the Options pane remains open all the time.
Edit lookup control.
If you add and configure an Edit Lookup control in an Edit form control, users can add and update items in a SharePoint list that contains these types of columns:
Update required for PowerApps Studio and PowerApps Mobile.
Due to an internal change, you must install this update to continue to create and edit apps in PowerApps Studio and run apps in PowerApps Mobile.
For Windows 8 and Windows 8.1:
Enhanced delegation for large data sets.
Updates property added to the Edit form control.
You can use this property to pass form data to a REST API.
Bug fixes for Video control.
Now works with YouTube.
Single sign-on support for Microsoft services.
Single sign-on feature will automatically sign PowerApps users into their first party services that use Azure Active Directory authentication, such as SharePoint, Office 365, and Dynamics CRM.
Added Edit lookup card.
As soon as you install this PowerApps update, Display form and Edit form controls will show lookup fields to other tables, but this data will be read-only. As soon as other changes occur in the SharePoint connector, you’ll be able to update these fields for data in SharePoint lists. (You won’t need to update PowerApps again to take advantage of this capability).
Minimum/maximum values for numeric cards.
Numeric cards, such as those for ratings and percentages, reflect minimum and maximum values that you set (or that are set in the metadata for the data source).
Default value for the DatePicker control.
You can configure a DatePicker control with a blank value as its default.
Improvements to Display Form and Edit Form controls.
Form controls now show both a display name and the name of the field if they differ, and you can change the display name of a lookup control.
On powerapps.com, show only those apps you own or were shared with you.
Bug fixes and performance improvements throughout the product.
Use apps directly on the web!
You can find and use PowerApps on any device that has a web browser.
A new home screen at PowerApps.com.
A fresh new look for finding and managing your apps, connections, and notifications.
Improvements to the sharing experience.
Users can now reshare apps and share apps with their organization.
PowerApps is now available for Android!
Look for PowerApps in the Android store.
PowerApps has a new look for finding and opening apps on devices that run iOS.
Update your app or install anew from the Apple store.
Simplified sign-in and first-run experiences.
We've added hamburger navigation and an app context menu.
Streamlined page for starting to create an app.
New guided product tour.
A quick tour of the most important parts of the authoring experience to help new users get acquainted.
Contextual help links.
We've made it much easier for you to find help in the product and connect with others through our community.
Creating an app over data just got a whole lot easier. With these controls and their associated cards and functions, you can create a basic app to view and edit data without needing to manually call Patch, Validate, and other low-level functions.
These controls also offer a new configuration pane, where you can turn on and off fields and change the card for each field.
Check out Understand data forms for more details.
Until now, all Filter and Sort operations were handled on the device, which required the time-consuming and bandwidth-choking fetch of all the data. With this release, in certain situations, these operations can be delegated to the data source, which makes your apps more responsive and able to handle a large number of records. You can read more about it on the Filter and Sort pages.
Delegation is limited to certain situations. Apps created from data don't qualify. See Known limitations later in this article for more details. We will expand the scenarios in which delegation can be used.
To take advantage of this new capability, the Gallery control now supports paging. As the user reaches the end of a list of data, the control fetches more from the data source, seamlessly.
Search and scroll in the PDF viewer control.
The PDF viewer control now supports full-text search across the document, and we've added smooth scrolling between pages. No longer do you need to move page by page.
We continue to add connectors. Check out the list for the latest.
Update your metadata with a single click or tap (instead of deleting a connection and adding it again).
A list of your most recently used SharePoint sites.
Building a bunch of apps for the same SharePoint site? To make that easier, we track SharePoint sites that you've recently used so that you can easily select them again.
Performance and data-handling improvements, along with many other usability and bug fixes throughout!
This release supports these connections, among many others: