Skip to main content
Community call
March 20th, 2019
8:00 AM PST
https://aka.ms/powerappscommunitycall
Microsoft PowerApps
• https://aka.ms/powerappscommunitycall
• Monthly cadence
• Every month on the third Wednesday
• Next call: 08:00am PST, April 17th, 2019
• Latest news and community contributions
• Meet the product teams behind PowerApps
• Technical deep dives
• Q&A
Todd Baginski
Canviz
@toddbaginski
www.toddbaginski.com/blog
Audrie Gordon
Microsoft
@ArtsyPowerApper
community.PowerApps.com
Dave Chennault
SkyLite Systems
@davechennault
www.SkyLiteSystems.com
Adrian Orth
Microsoft
community.PowerApps.com
Brian Dang
Microsoft
@8bitclassroom
8bitclassroom.com
InfoPath to PowerApps
migration
Modernize
• Build the apps that users need
• Apply consumer app styling
• Multiple form factors
Streamline
• Make users more productive
• Optimize the interaction with flexible platform
Extend
• Pull in data from other places
• Enable others to benefit from the data
Moving Business
Apps to
PowerApps
Review data relationships
• Entities
• Lookup and collection relationships
Current and planned data volume
• Record count
• Attachments and images
• Archiving
Complexity of business logic
• UI logic
• Web services
• Assemblies
Data security
• Determine access levels
Analyze data
schema, volume,
and business
logic
Decide data storage
• Common Data Service entities
• SharePoint Lists
• SQL tables
Features helping
• Dependent drops downs (all)
• Relationship properties (currently only CDS)
• Creating CDS fields within canvas designer
• Common Data Service platform
Create data
schema and add
sample data
App type options
• Embedded apps – SharePoint Custom Forms,
SharePoint Web Parts, Teams, etc.
• Standalone mobile apps or web app
Features helping
• Responsive canvas layout using expressions (public
preview)
• Unified control framework for PowerApps (public
preview)
• Compose and reuse rich components (public
preview)
Determine app
type and page
flow
Business logic options
• Canvas app logic
• Flow
• Custom Connector
• Business Rules or Plugins (CDS specific features)
Features helping
• View results of formulas and sub-formulas in canvas
apps
• Improved formula and error handling
Add business
logic
Submit requests for
• Richer patterns
• Building without expressions
• Delegation
• Control gaps
• Ideas making business app migration easier
https://powerusers.microsoft.com/t5/PowerApps-
Ideas/idb-p/PowerAppsIdeas
PowerApps
Feedback
InfoPath to PowerApps
Planning, Inventory, and
Migration
www.SkyLiteSystems.Com
2 - Mapping of XML form schema or list & create new target
3 - Export of data to allow data cleansing
4 - Import of cleansed data to new target – SharePoint, CDS, ...
5 - Creation of new PowerApps
Inventory
Schema
Mapping &
Create New Lists
or Entities
Export Data Import Data
Create New
PowerApp &
Flows
**** Form Complexity
 < 50 fields – Low
 50 – 75 – Medium
 75-100 – High
 >100 or code-behind – Very High
1 - Inventory of InfoPath Forms within SharePoint
2 - Map XML form schema or list to new target & create new
lists or entities in CDS
3 - Export of data to allow data cleansing
4 - Import of cleansed data to new target – SharePoint, CDS, ...
5 - Creation of new PowerApps
Inventory
Schema
Mapping &
Create New Lists
or Entities
Export Data Import Data
Create New
PowerApp &
Flows
InfoPath to PowerApps...
Source is a Forms Library Because
• Repeating Sections
• Some forms have Code-Behind
• Very Common Scenario
Migrated For PowerApps to 3 Lists
• Main Form
• 2 Repeating Sections
• Migrated Attachments
Resources
https://docs.microsoft.com/en-us/business-applications-release-notes/April19/microsoft-
powerapps/
https://powerapps.microsoft.com/en-us/blog/components-available-in-preview
https://powerapps.microsoft.com/en-us/blog/craft-app-height-and-width-expressions-to-
create-responsive-canvas-apps/
https://powerapps.microsoft.com/en-us/blog/powerapps-ten-reusable-components/
https://skylitesystems.com/i2p-express
Dave Chennault
SkyLite Systems
@davechennault
www.SkyLiteSystems.com
Adrian Orth
Microsoft
community.PowerApps.com
Recent News
https://docs.microsoft.com/en-us/business-applications-release-
notes/April19/microsoft-powerapps/
https://powerapps.microsoft.com/en-us/blog/powerapps-ten-reusable-
components/
https://resources.techcommunity.microsoft.com/wp-
content/uploads/2018/11/Transforming-Business-Process-with-Microsoft-365-
4.pdf
https://github.com/SharePoint/sp-powerapps-solutions/tree/master/solutions
Community Contributions
https://www.agileo365.com/2019/03/building-responsiveish-
powerapps.html
http://dynamicsgpblogster.blogspot.com/2019/03/powerapps-using-
components-to-create_4.html
https://www.youtube.com/watch?v=hGjRFT2Lxhc&feature=youtu.be
https://aka.ms/OfficeDevYouTube
https://aka.ms/PowerAppsCommunityCall
Q&A
PowerApps community call-March 2019