PowerApps community call-March 2019

Agenda for this month included
-InfoPath to PowerApps migration
-Expediting InfoPath analysis and migration
-Recent News and Community Activities
-Monthly Tips
-Q&A

1. Community call   March 20th, 2019 8:00 AM PST https://aka.ms/powerappscommunitycall  Microsoft PowerApps

2. About the PowerApps Community Call 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

3. Call Agenda Today’s presenters InfoPath to PowerApps migration Expediting InfoPath analysis and migration Recent News and Community Activities Monthly Tips Q &A

4. Today’s Presenters 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

5. Today’s PowerApps Product Team chat channel gurus Brian Dang Microsoft @8bitclassroom 8bitclassroom.com

6. InfoPath to PowerApps migration

7. 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

8. 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

9. 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

10. 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

11. 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

12. 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

13. InfoPath to PowerApps Planning, Inventory, and Migration

14. InfoPath to PowerApps Planning, Inventory, and Migration Dave Chennault SkyLite Systems www.SkyLiteSystems.Com [email protected]

15. Where Are Our Legacy InfoPath Forms? Which Forms Do We Use? How Big a Job to Migrate? How do I Migrate the Data ? “How am I going to do this?” “I need to move from InfoPath to PowerApps & Flow but....”

16. XML in Forms Library - Tough Tip - InfoPath Stores Data Two Ways SharePoint List - Easier

17. InfoPath Migration/Replacement - 5 Steps 1 - Inventory of InfoPath Forms within SharePoint 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 We have a tool - i2P Express - to help you complete Steps 1-4

18. Inventory Module – i2P Express **** Form Complexity ·          < 50 fields – Low ·          50 – 75 – Medium ·          75-100   – High ·          >100 or code-behind – Very High

19. After You Select a Form and Complete Steps 2- 5 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

20. 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

21. Data – Before and After

22. Resources

23. Resources Release notes https://docs.microsoft.com/en-us/business-applications-release-notes/April19/microsoft-powerapps/ Components https://powerapps.microsoft.com/en-us/blog/components-available-in-preview Responsive: https://powerapps.microsoft.com/en-us/blog/craft-app-height-and-width-expressions-to-create-responsive-canvas-apps/ Reusable components https://powerapps.microsoft.com/en-us/blog/powerapps-ten-reusable-components/ i2P Express - InfoPath Migration Tool https://skylitesystems.com/i2p-express PowerApps.Com > Partners > Consulting Services Migrate InfoPath Data-New Tool and: 2-Hr Workshop

24. Thanks to our presenters! Dave Chennault SkyLite Systems @ davechennault www.SkyLiteSystems.com Adrian Orth Microsoft community.PowerApps.com

25. Recent News

26. Recent News April 2019 Release Notes https://docs.microsoft.com/en-us/business-applications-release-notes/April19/microsoft-powerapps/ 10 Reusable Components: tab control, calendar, dialog box, map control and more https://powerapps.microsoft.com/en-us/blog/powerapps-ten-reusable-components/ Transforming Business Process with Microsoft 365 White Paper https://resources.techcommunity.microsoft.com/wp-content/uploads/2018/11/Transforming-Business-Process-with-Microsoft-365-4.pdf Supplementary PowerApps Solutions https://github.com/SharePoint/sp-powerapps-solutions/tree/master/solutions

27. Community Contributions

28. Thank you for your contributions!! Haniel Croitoru , Building Responsive( ish ) PowerApps https://www.agileo365.com/2019/03/building-responsiveish-powerapps.html Mariano Gomez Bent, Using Components to create a Digital Clock http://dynamicsgpblogster.blogspot.com/2019/03/powerapps-using-components-to-create_4.html Keith Craigo , Show and hide controls based on AAD Group Membership https://www.youtube.com/watch?v=hGjRFT2Lxhc&feature=youtu.be # PowerAppsCC

29. Todd’s Monthly Tip InfoPath Think before you migrate Re-imagine processes Leave it better than you found it

30. Audrie’s Monthly Tip InfoPath Change management tips Ideas for integrating new technologies Considerations related to revisiting information architecture

31. Recording will be available soon on Office Developer YouTube https://aka.ms/OfficeDevYouTube Submit your community content now: Tweet # PowerAppsCC FYI: You will be automatically entered into the 1st quarter raffle to win an Xbox! Add to your calendar: https://aka.ms/PowerAppsCommunityCall Next call: 08:00am PST, April 17th, 2019 Thank you for joining us today!

32. Q&A