1 Dec’16

Dynamics 365, EnterprisePowerApps

What is PowerApps?

PowerApps is a Microsoft product which allows developer/non-developer to build an application without writing a single line of code.

  1. PowerApps creates custom business apps for web and mobile devices that help you do your job more efficiently and collaborate better with your co-workers.
  2. Use PowerApps to solve problems specific to your business and extend the software you’re already using such as apps for custom site inspections, cost estimators, budget tracking, or managing customer opportunities
  3. You can use PowerApps in any web browser, including the mobile web.
  4. You can also download PowerApps Mobile for iOSor Android to use apps on your phone or tablet. No matter where you’re working, just open PowerApps to find the apps available to you.

What data sources can my apps connect to?

PowerApps connects to a range of data sources out of the box, and Microsoft adding more all the time. Some examples of data sources and services include:

  1. Excel files stored on OneDrive for Business, Dropbox, or Google Drive
  2. SharePoint Online lists
  3. Salesforce objects
  4. Microsoft Dynamics CRM Online records
  5. Azure SQL Database tables
  6. Office 365 Exchange data
  7. Twitter
  8. Microsoft Translator
  9. Your own custom APIs
  10. And many more applications.

What’s a work or school account, and why do I need one to use PowerApps?

  1. Because PowerApps is built for business apps that you share with your team, we require you to use an email address associated with an organization (your work or school account) to sign up. Shared email providers like Hotmail or Gmail won’t currently work with PowerApps.

Who can I share apps with

  1. You can share apps with anyone in your organization, that is, anyone who has your same email domain—for instance, anyemployee@contoso.com.
  2. Anyone who uses your apps will also need access to any data sources those apps connect to. For example, if you build an app that uses an Excel file on OneDrive, people you share the app with will also need to have access to the Excel file in order to fully use the app


  1. Go to: https://powerapps.microsoft.com/
  2. You need to sign in the powerApps portal using the given link and signin/singup
  3. Once you are logged in successfully, you can create a new app from the portal.
  4. Click on create new App.
  5. You can develop PowerApps either on desktop application or on the browser, you can download it from the Store or you can directly edit in browser.
  6. Once you have installed the PoweApps from the Store now you can develop your own application by click on the new button.
  7. Select from the existing app which is a predefined template
  8. Establish your connection with CRM:
    1. If you have already connected with the existing CRM than you don’t required to connect. If your login for the first time you need provide the connection details. Click on the Dynamics CRM Online.
  9. To design the PowerApps you need to select a table from the available list, select the table(entity)
  10. Once you have done with your app is ready and you are able to see the app with 3 different type of forms.

Design app

  1. BrowseScreen1:shows a list of all items and some information about them so that users can easily browse for the item they want.
  2. DetailScreen1:shows all information about a single item.
  3. EditScreen1:provides an Edit form control for adding an item or updating information about an item.


  1. Search and sort the contact
  2. User can search for one or more records, sort the list of records in ascending or descending order, or both.

Form Type

Display Screen:

  1. You can add the records from the right side pane. this only displays the records.

Edit screen:

  1. Here user can change the value of a record.




Looking value from other data set from the other data set

  1. LookUp(Accounts, accountid=ThisItem._parentcustomerid_value).name
    1. Table– Required. Table to search.
    2. Formula– Required. This formula is evaluated for each record of the table, and the first record that results in true is returned. You can reference columns within the table.
    3. ReductionFormula– Optional. This formula is evaluated over the record that was found, reducing the record to a single value. You can reference columns within the table. If this parameter is not supplied, the function returns the full record from the table.
  2. Update = DataCardValue9.Text;
  3. Search(Contacts, TextSearchBox1.Text, “firstname”, “_defaultpricelevelid_value”, “_ownerid_type”, “_ownerid_value”)
    1. Table – Required. Table to search.
    2. SearchString – Required. The string to search for. If blank or an empty string, all records are returned.
    3. Column(s) – Required. The names of columns within Table to search. Columns to search must contain text. Column names must be strings and enclosed in double quotes. If SearchString is found within the data of any of these columns as a partial match, the full record will be returned.
  4. SortByColumns( Contacts, ” firstname “, SortOrder.Descending )
  5. Bind data to Dropdown
    1. Table – Required. Table to sort.
    2. ColumnName(s) – Required. The column names to sort on, as strings.
    3. SortOrder(s) – Optional. SortOrder!Ascending or SortOrder!Descending. SortOrder!Ascendingis the default. If multiple ColumnNames are supplied, all but the last column must include aSortOrder.
  6. SortByColumns(Search(Contacts, TextSearchBox1.Text, “firstname”, “_defaultpricelevelid_value”, “_ownerid_type”, “_ownerid_value”), “_defaultpricelevelid_type”, If(SortDescending1, Descending, Ascending))

Reference Link

1. https://powerapps.microsoft.com/en-us/tutorials/getting-started/
2. https://powerapps.microsoft.com/en-us/tutorials/formula-reference/
3. https://powerapps.microsoft.com/en-us/tutorials/working-with-cards/

Written by

Team Member


Leave a Reply

Your email address will not be published. Required fields are marked *

Time limit is exhausted. Please reload the CAPTCHA.

Want to streamline your business processes?

  • This field is for validation purposes and should be left unchanged.

Recent Articles

  • Design Views in App Designer – D365

    11 April’ 2018

    Introduction: Create and edit public or system views by using the app designer Description: Dynamics 365 sales app des...

    Read more
  • Call Management in D365 Field Service

    10 April’ 2018

    Introduction: This blog provides a solution to requirement of Client for Call Management in D365 Field Service. Scenari...

    Read more
  • Fetch Hierarchical data for Product Category in Dynamics 365 Operations

    10 April’ 2018

    Introduction: In this blog article, we will see how we can fetch hierarchical data using X++. How to fetch? We will ta...

    Read more
  • PowerBI April 2018 Update: Combo Chart Line Formatting

    10 April’ 2018

    Introduction: PowerBI introduced the feature to format line styles and legends for line charts a while ago. However, th...

    Read more
  • Power BI April 2018 Update: Q&A Explorer

    10 April’ 2018

    Introduction: In this blog we will explore some of the new features added to Power BI. Power BI has upgraded its Q&...

    Read more