طراحی پورتال های سازمانی شرکت پروجان

شیرپوینت و پراجکت سرور پروجان

استقرار شیرپوینت و پراجکت سرور

مسیر سایت

کتاب INTRODUCTION TO MICROSOFT POWERAPPS FOR ACCESS WEB APPS DEVELOPERS.pdf

INTRODUCTION TO MICROSOFT POWERAPPS FOR ACCESS WEB APPS DEVELOPERS.pdf

 

دانلود رایگان کتاب INTRODUCTION TO MICROSOFT POWERAPPS FOR ACCESS WEB APPS DEVELOPERS.pdf

Ben Clothier      Andy Tabisz

March, 2017

لینک دانلود کتاب INTRODUCTION TO MICROSOFT POWERAPPS FOR ACCESS WEB APPS DEVELOPERS.pdf

 

 

ABSTRACT
The one constant in software technology is that it’s constantly changing. You might ask: “What alternative is there to create a mobile or online solution for Microsoft Access?” Microsoft believes that Microsoft PowerApps is the answer. Although PowerApps is a relatively new product, Microsoft is making a significant investment in PowerApps to make it a premiere tool for business solutions and is adding new features on a regular basis. The purpose of this white paper is to demonstrate that PowerApps is a successor tool worthy of consideration for an Access web apps power user and developer. What follows is an in-depth comparison of PowerApps and Access Web apps that examines the pros, cons, and similarities of each tool, their key features, and the way data is managed. Hopefully, you’ll take the time to try out PowerApps and add it to your business solutions toolkit.

 

Contents

 

What is Microsoft PowerApps? ................................................................................................. 3
What makes PowerApps different from Access web apps? ......................................................... 3
Mobile-first ............................................................................................................................. 3
Multiple data sources .............................................................................................................. 3
No-Code interface .................................................................................................................. 3
Client-side vs server-side functionality ..................................................................................... 3
Other important differences .................................................................................................... 4
Development environment ...................................................................................................... 4
Understanding the distribution of native iOS and Android applications ........................................ 4
The Common Data Service ...................................................................................................... 4
Security ................................................................................................................................. 5
Replicating the functionality of Access web apps in PowerApps .................................................. 5
Menus and navigation ............................................................................................................. 5
Form and layout ..................................................................................................................... 7
List views ............................................................................................................................... 7
Datasheet views ..................................................................................................................... 9
Related data ......................................................................................................................... 13
Approach one: using lookups ................................................................................................. 13
Approach two: using the SharePoint lookup field ..................................................................... 14
Searching and filtering ........................................................................................................... 16
Layout perspective ................................................................................................................ 17
Search controls...................................................................................................................... 19
Data macros ......................................................................................................................... 23
What you can do in Access web apps but not in PowerApps ..................................................... 26
Inviting anonymous users ...................................................................................................... 26
Datasheet views .................................................................................................................... 26
Summary views ..................................................................................................................... 26
Transaction data tracking and troubleshooting.......................................................................... 26
What you can do in PowerApps but not in Access web apps ...................................................... 26
PDF viewer ............................................................................................................................ 26
Multimedia support ................................................................................................................ 27
Variety of controls.................................................................................................................. 28
Toggle .................................................................................................................................. 28

Slider .................................................................................................................................... 29
Rating .................................................................................................................................. 29
Other controls ....................................................................................................................... 29
Pen input .............................................................................................................................. 29
Variety of layouts and galleries ............................................................................................... 30
Rich user interface building capabilities ................................................................................... 30
SharePoint is not the only data source .................................................................................... 32
Extensibility .......................................................................................................................... 33
About the authors ................................................................................................................. 33

 

 

What is Microsoft PowerApps?

In a nutshell, PowerApps is a software platform for creating and sharing corporate, line-of-business apps quickly and without writing code. It’s designed to work natively on iPhone, Windows 10 Mobile, and Android phones, and works on the web as well. PowerApps allows you to connect to multiple data sources at once, allowing you to interact with this combined information as needed. This white paper assumes that you have basic knowledge of PowerApps.

PowerApps is designed for a corporate environment in which you share apps with employees. You sign in by using your work or school account. You can’t use personal email addresses with domains, such as hotmail.com, gmail.com, or aol.com, because those are not associated with a corporate environment.

 

 

What makes PowerApps different from Access web apps?

PowerApps and Access web apps are both geared towards mobility, but each platform has its own strengths and weaknesses. PowerApps can do many of the features of Access web apps, but it can’t be viewed as a direct replacement for Access web apps.

 

Mobile-first

By far, the best feature of PowerApps is that it is designed with a mobile-first strategy, meaning that it is ideal for phone devices. Access web apps is a browser-based application which does not work well on smart phones.

 

Multiple data sources
PowerApps can connect to many data sources including SharePoint, Office 365, Dropbox, Salesforce, MailChimp, and dozens of other data connections. Just like Power BI, each app you create can utilize data from multiple sources. By contrast, Access web apps are housed completely inside of SharePoint, whether in the cloud or on-premises, although you can interact with SharePoint data from an Access web app, and that data can be shared across Access web apps. You cannot connect one Access web app data to another Access web app. This document discusses how to replace an Access web app with a PowerApps app using SharePoint lists as the data source.

 

 

No-Code interface

Both are no-code solutions and neither uses VBA. Designing PowerApps screens is a lot like the Access web apps design experience except that instead of macros, you use extensive formulas and control properties which are much more like Microsoft Excel. This requires a different approach to writing logic compared to macros in Access web apps, which is addressed later.

 

Client-side vs server-side functionality
PowerApps functionality is mostly executed on the client-side. PowerApps may support some level of delegation where a bulk update is applied directly on the server. However, at the time of this writing, delegation is not supported for SharePoint lists. This means that when you work with more than one record, be careful not to write logic that could update only a subset of the list. Remember that PowerApps has a limit of 500 records downloaded to the local cache, and that’s even before a filter is applied. The other consequence to consider is that if you edit a large amount of records, it requiresmore time for PowerApps to apply the changes back to the database; PowerApps currently can’t invoke a procedure directly in the database.

By contrast, Access web apps does all query processing on the server, using a very powerful SQL server query engine. Access web apps have client-side, user interface (UI) macros, and server-side data macros that you can call. These data macros are essentially SQL triggers that perform backend operations, such as looping through all records in a dataset and performing a bulk update.

 

لینک دانلود کتاب INTRODUCTION TO MICROSOFT POWERAPPS FOR ACCESS WEB APPS DEVELOPERS.pdf

 

عضویت در خبرنامه