{"id":1765,"date":"2022-11-29T16:25:42","date_gmt":"2022-11-29T05:25:42","guid":{"rendered":"https:\/\/www.dynamicwebtraining.com.au\/blog\/?p=1765"},"modified":"2024-11-14T14:10:10","modified_gmt":"2024-11-14T03:10:10","slug":"getting-familiar-with-microsoft-power-apps","status":"publish","type":"post","link":"https:\/\/www.dynamicwebtraining.com.au\/blog\/getting-familiar-with-microsoft-power-apps","title":{"rendered":"Getting Familiar with Microsoft Power Apps"},"content":{"rendered":"\n

Microsoft Power Apps is an online tool to build mobile and desktop applications for personal and business use. People who want to develop an app but don\u2019t have any coding or technical knowledge in software development can use Microsoft Power Apps to build it easily without spending much time and money.<\/p>\n\n\n\n\n\n\n\n

Microsoft Power Apps: A Guide<\/h2>\n\n\n\n

Microsoft developed Excel over three decades ago and since then MS Excel is the most preferred and used spreadsheet software around the world. Power Apps also comes from the same Microsoft family with same easy to use features. <\/p>\n\n\n\n

The reason for the popularity of MS Excel is that it is so user friendly that without any technical knowledge users can use it to store data in tabular form and define custom formulas on their data for various calculations. Similarly, Microsoft Power Apps is gaining popularity for its easy to use and instant app developing feature which do not require any prior coding or traditional software development knowledge.<\/p>\n\n\n\n

If you have been an MS excel user for years and have used excel for storing, organizing, and presenting your data, then at some time you must have envisioned that excel should go online so that you can access the stored information from anywhere. Hence MS Excel went online and today we have an online version of excel which can be accessed from anywhere in the world. However, if you wish to share the online data with multiple users with customized access to add and\/or modify the data and to update the data in real time, then an app developed using Microsoft Power Apps Platform can do this for you. <\/p>\n\n\n\n

Power Apps comes with a feature that lets you build an app within minutes from your existing data which is stored in an online Excel or any other online data storage platforms. Developing a Power Apps mobile or desktop app from your existing data in excel or any other platform is as simple as you select and add different items to the shopping cart and buy things online.<\/p>\n\n\n\n

Like MS Excel, Power Apps is also suitable for the users who have technical knowledge and want to develop complex apps using their skills. PowerApps has the capability to develop very powerful complex apps which can be used by thousands of users at the same time with hundreds of screens in it, But the gaining popularity of Power Apps is not because of it\u2019s capability of building complex business apps but due to it\u2019s simplicity that any user can build a simple yet powerful app within minutes from their existing data and start using it in their business.<\/p>\n\n\n\n

Developing a Power App:<\/h4>\n\n\n\n

Let\u2019s have a look at how easy it is to develop an app in Microsoft Power Apps from our existing data in excel. Assume that we have the data in the form of a table in Microsoft Excel sheet saved in Microsoft OneDrive and we want to view the data and add or edit the data online through an app.<\/p>\n\n\n\n

To create the app, all we need to do is to go to Microsoft PowerApps home page<\/a> and follow the below steps:<\/p>\n\n\n\n

1. Click on Create.<\/strong><\/p>\n\n\n\n

2. S<\/strong>elect Excel Online.<\/strong><\/p>\n\n\n\n

\"Power<\/figure>\n\n\n\n

3. Select OneDrive or OneDrive for Business<\/strong>, whichever is the source.<\/p>\n\n\n\n

\"Power

When you click on New Connection, a list of all connections will be displayed as shown in below screenshot.<\/em><\/figcaption><\/figure>\n\n\n\n
\"Power<\/figure>\n\n\n\n

4. Click on Create <\/strong>button from above screen to create the OneDrive\/OneDrive for Business Connection for the first time<\/p>\n\n\n\n

\"Power<\/figure>\n\n\n\n

5. Click on OneDrive\/One Drive for Business<\/strong> under Connections.<\/p>\n\n\n\n

6. Choose the Excel File<\/strong> where data is saved.<\/p>\n\n\n\n

7. Choose the Table where Data<\/strong> is saved.<\/p>\n\n\n\n

\"Power<\/figure>\n\n\n\n

8. Choose the Table where Data<\/strong> is saved.<\/p>\n\n\n\n

9. Click on the Connect <\/strong>button to create the Power Apps Canvas App.<\/p>\n\n\n\n

    \n
  1. <\/li>\n<\/ol>\n\n\n\n
    \"Power<\/figure>\n\n\n\n

    Microsoft Power Apps will automatically create the app for you. The created app will have 3 screens in mobile layout. The screens are:<\/p>\n\n\n\n

    Browse Screen:<\/h5>\n\n\n\n

    This is a gallery displaying all the items with search & sort option.<\/p>\n\n\n\n

    \"Getting<\/figure>\n\n\n\n
    Detail Screen:<\/h5>\n\n\n\n

    This screen is used to view the details of a selected item from Browse Screen.<\/p>\n\n\n\n

    \"Getting<\/figure>\n\n\n\n

    <\/p>\n\n\n\n

    Edit Screen:<\/h5>\n\n\n\n

    This screen is used to add a new item or to edit the details of a selected item from the Browse Screen.<\/p>\n\n\n\n

    \"Getting<\/figure>\n\n\n\n

    This app can be saved and shared with a number of end users to start using it right away.<\/p>\n\n\n\n

    Power Apps License:<\/h4>\n\n\n\n

    Now, talking about the cost, PowerApps license comes along with other office 365 package and also in the form of a stand alone product. You can follow the below link to check various options to buy Power Apps license.<\/p>\n\n\n\n