You can also see all the sessions from these MBAS Community Galleries: Power Apps Community | Power Automate Community | Power Virtual Agents Community | Power BI Community

The shortcut for this blog for easy reference is https://aka.ms/pa/mbas2020
Update 22nd May 2020: Added 36 new sessions (including relevant sessions from our FastTrack & Industry Accelerators Teams)
Update 2nd June 2020: Added 12 new sessions
Update 4th June 2020: Added 5 new sessions
Jump to links for the 108 sessions below

• Keynote – 2 Sessions
• Real-World stories – 13 Sessions
• Power Apps – 24 Sessions
• Power Automate/RPA – 10 Sessions
• Power Virtual Agents – 3 Sessions
• Power BI – Customer stories – 11 Sessions
• Power BI – 27 Sessions
• Relevant sessions from the Dynamics 365 FastTrack team – 6 Sessions
• Certification – 1 Session
• Industry Accelerators – 11 Sessions

Keynote

Hear from James Phillips and Alysa Taylor Alysa Taylor; James Phillips James Phillips, President of the Microsoft Business Applications group, shares the latest product strategy, highlights from the Dynamics 365 and Power Platform 2020 release, and how those innovations…

Empower your organization with the Microsoft Power Platform Arun Ulagaratchagan; Charles Lamanna; Emma Archer; Julie Strauss; Kim Manis; Miguel Martinez; Priya Sathy; Ryan Cunningham; Ryan Jones; Stephen Siciliano The Microsoft Power Platform is a low-code development platform empowering your employees to solve today’s most challenging business problems with ease and within the bounds of your IT governance. The…

Real-World stories

	Real-world stories: Individuals and organizations driving transformation with the Power Platform Foyin Olajide-Bello; Nathan Backers; Sameer Bhangar; Saurabh Pant; Tijn Tacke In this session, hear directly from customers that range from citizen developers to full stack professional developers on how they’re using Microsoft Power Platform to transform business processes, de…
	Real-world stories: Organizations scaling adoption of the Power Platform with a Center of Excellence Manuela Pichler Learn how organizations have established a Center of Excellence (CoE) to drive internal adoption of Microsoft Power Apps and Power Automate and handle governance and adoption for hundreds of productio…
	Real World Stories: Coca-Cola United uses Power Automate RPA capabilities to automate legacy processes Allan McDaniel; Bob Means Coca Cola United had a complex back-end process for managing orders for its freestyle beverage vending machines. This involved manually entering data and tracking progress across multiple legacy syste…
	Real World Stories: illimity and Aioi Nissay drive business process automation with Power Automate Francesco Zitelli; Takashi Yano Aioi Nissay Dowa Insurance, Japan’s largest insurance company, has created a virtuous cycle in which Power Automate UI Flows are used to optimize citizen developer training & certification processes.…
	Real World Stories: Ecolab and Microsoft transform sales processes using Microsoft Power Platform Lori Jarchow; Rachel Hart; Thomas Verhasselt In this real world stories session, digital transformation leaders from Ecolab and Microsoft will describe how they leveraged Microsoft Power Platform to integrate with Dynamics 365, Microsoft Azure,…
	Real World Stories: Telstra uses Microsoft Power Platform and Teams to boost field technician productivity Nathan Backers Telstra is Australia’s largest telecommunications company. Nathan Backers started as a communications technician in 2008 and over the years has adopted Microsoft Power Platform and Microsoft Teams to…
	Real World Stories: T-Mobile and Loblaws build rich interactive solutions connected to Common Data Service Brian Hodel; Elena Chevelev T-Mobile is one of the largest mobile service providers in the United States. Managing new customer initiatives from inception to launch is a complex process involving multiple stages, roles, and reso…
	Real World Stories: Citizen developers at Sterling Bank and Nestlé Waters use Microsoft Power Platform to drive transformation in their organizations Derek Lichtenwalner; Foyin Olajide-Bello Watch this real world stories session to learn how Microsoft Power Platform is helping digitize business processes and impacting careers and lives across multiple industries. Derek Lichtenwalner from…
	Real World Stories: #LessCodeMorePower—and why it helps up-level ANY career Arturo Silis; Dona Sarkar; Georgia Tsoraklidou; Mark Colbert Think the Power Platform is only for “Citizen Devs”? Think again. Come hear from a Citizen Dev who’s made over 70 production business critical apps, a traditional “ProDev,” and a self-proclaimed “Ops…
	Real World Stories: Why did EY pick Microsoft Power Platform to digitize complex enterprise scenarios Gregory Dupan; Sheheryar. Qadir EY is one of the largest professional services organizations in the world with over 270K employees. In this session, digital transformation leaders from the Enterprise Workplace Technologie…
	Real World Stories: Coca-Cola and DWF Law LLP share their Power Virtual Agents and AI Builder stories Daniel Pollick; Lokeshwar Vangala; Mike Walker Coca Cola is rapidly embracing Power Virtual Agents, Power Automate RPA, and Power Apps to re-imagine employee experiences and automate several business processes. Watch this interview to learn about…
	The Power Platform journey through the lens of a digital technology manager Eric Mckinney Take a journey through the birth and adoption of the Power Platform at G&J Pepsi over four years ago. Walk through the past four years to learn more about the breadth of applications, automation, and…
	Secret recipes for building a record breaking adoption app in under three hours Alan Chai Enabling a multitude of makers in an enterprise to rapidly solve real business problems with Microsoft Power Platform. We discuss a real use case where Schlumberger leverages low-code/no-code Power Pl…

Power Apps

	Power Apps in 2020: What you should already be using and what’s still to come in 2020 Clay Wesener; Ryan Cunningham Come and hear directly from the Microsoft Power Apps team about new features recently released, and our plans for the rest of 2020. This session provides an overview of our big investments as well as…
	Leverage Power Apps to customize Microsoft Teams to empower your frontline workers Arun Ulagaratchagan; Efesa Origbo; Matthew Bolanos; Pete Daderko Microsoft Teams is becoming the central place for workplace collaboration, and with Microsoft Power Apps, Teams can be further customized to bring everything a frontline worker needs under one roof. I…
	Managing and governing the ​ Power Platform at scale Abigail Rappoport Sharan; Darya Mazandarany; Julie Strauss This session provides an overview of our big investments as well as some awesome demos of our latest features in Power Apps.
	Power Platform emergency response solutions Deanna Sparks; Gary Bird; Pankaj Arora; Sangya Singh As organizations around the world are getting challenged with managing the COVID-19 pandemic, learn how Microsoft is helping customers respond to the public health crisis with Power Platform. We demo…
	Learn how AI Builder can help create insights from your business data Gautam Thapar; Norah Liu; Raj Virk Enhance your apps and business processes with AI that’s easy to build into apps and configure within Microsoft Power Apps. In this session we provide an overview of AI Builder and show you how to get…
	What’s new in the common data service Maya Dumesh; Ryan Jones; Srikumar Nair; Sunil Garg The Common Data Service connects Microsoft Power Apps, Power Automate, Power BI, AI Builder, and Power Virtual Agents with data. In this session, we cover new capabilities in the April release.
	Demystifying model-driven apps Clay Wesener; Adrian Orth How do you build apps which will support tens or hundreds of thousands of users? We cover common patterns and antipatterns in this session.
	Power Platform adoption, enterprise management, and governance Andrew Welch; Manuela Pichler More and more large organizations with complex missions are connecting siloed data, engaging customers, and driving ROI with amazing custom solutions on Microsoft Power Platform — Power Apps, Power BI…
	Power Apps 101: From “Hello, World!” to Power App champ Keith Whatling How does a bus driver get from behind the wheel to a Microsoft Power Apps champ? You’re going to hear exactly how that happens. In this session, we dispel the three most common myths people hold about…
	Mixed Reality in Power Apps Michael O’Connor Just recently announced and now in public preview, our new capabilities allow citizen developers to incorporate mixed reality experiences like visualizing 3D objects in the real world right into their…
	Amplify your pro developer skills with the Power Platform Hailey Huber; Per Mikkelsen; Rohit Puri Are you a pro developer wondering what the Microsoft Power Platform can do for you? Attend this session to learn how you can help accelerate the digital transformation and app modernization efforts in…
	Data Loss Prevention for Power Apps and Power Automate explained Anupma Sharma; Julie Strauss Data Loss Prevention is key for governing and protecting your organizations data assets. In this session, we explain the ins and outs of Data Loss Prevention as it applies to Microsoft Power Apps and…
	Automating Invoice Processing with AI Builder Cedrick Bellarosa Join us to learn how to create a fully automated invoice process using AI Builder, Power Apps and Power Automate.
	Marrying Dynamics 365 Finance and Operations and the Common Data Service Sunil Garg Want to build Power Apps over both Microsoft Dynamics 365 Finance and Operations and Dynamics 365 Customer Engagement? In this session, we show how the Common Data Service allows you to build applicat…
	Common Data Model: Learn core concepts of the CDM metadata system and how to use CDM to build actionable insights and analytics for your business data Jeff Bernhardt; Oleg Ovanesyan; Robert Bruckner The Common Data Model (CDM) is the shared data language used by business and analytics applications to provide semantic consistency and facilitate interoperability. It is an open-sourced metadata syst…
	Advanced CDM: Learn the benefits of CDM SDK Jeff Bernhardt; Oleg Ovanesyan Come and learn how to use new Common Data Model (CDM) SDK for core developer scenarios to read and write CDM metadata.
	Geospatial / Maps in Power Apps Michael O’Connor Just recently announced and now in private preview, citizen developers can now add geospatial capabilities like maps and address search components to their apps. In this session we’ll cover what’s ava…
	Use Power BI with Common Data Service and Power Apps Adrian Orth; Maya Dumesh Join us to learn about improvements in Common Data Service and Power Apps to better integrate with Power BI. Common Data Service will provide CDS security through a Direct Query connection. Power App…
	Power Apps portals: An overview and what’s new. Dileep Singh Learn about the latest capabilities in Power Apps portals to securely enable external interaction with your data. Bring data from the apps you use—including Power BI and Power Automate—together with C…
	Advanced Application Lifecycle Management (ALM) capabilities Evan Chaki; Per Mikkelsen; Shan McArthur Get hands-on with the full set of Application Lifecycle Management (ALM) capabilities for the Microsoft Power Platform. Learn how to use the key concepts to automatically manage and deploy application…
	Building ISV solutions on the Power Platform Julie Strauss; Per Mikkelsen Imagine if you, as an ISV, could build an app in hours instead of months. Imagine you could do it without writing a single line of code and as you gather feedback from customers you could augment that…
	A tour of Common Data Service (CDS) in the Power Platform with Doctor Flow serge luca In this session, Doctor Flow, a.k.a. Serge Luca, illustrated why CDS really matters in the Microsoft Power Platform. He demos the role of CDS in Microsoft Power Automate, Power Apps (Canvas, Model Dri…
	Introduction to AI Builder Benoit Fabre Join us for an overview of AI Builder: allow your subject matter experts to build AI Models without the need for code or AI expertise.
	SAP Surround options with the Power Platform Apostolis Papaioannou; Sameer Chabungbam Does your enterprise use SAP and want to benefit from the Microsoft Power Platform? Join us in this session where we introduce the new SAP ERP connector for Microsoft Power Apps and Power Automate, an…

Power Automate/RPA

	Unlocking seamless automation across your enterprise​ Chris Garty; Rajya Lakshmi Priyadarsini Kodukula; Stephen Siciliano; Tulsi Keshkamat Power Automate is Microsoft’s workflow and business process management platform, and recently introduced new Robotic Process Automation capabilities, with a new capability called UI flows. Power Autom…
	Learn how robotic process automation can expedite your digital transformation Ashvini Sharma; Debraj Ghosh; Gautier Chastan; Lan Li ; Matt Townsend; Tulsi Keshkamat Learn how to put both attended and unattended UI flows to use in building a practice around robotic process automation (RPA) with best practices, tips, and tricks!
	Power Automate in 2020: What you should already be using and what’s still to come Stephen Siciliano You spoke, we listened! Come and hear directly from the Microsoft Power Automate team about new features recently released, and our plans for the rest of 2020. This session provides an overview of our…
	Why Microsoft’s RPA? Ashvini Sharma Learn how Microsoft’s robotic process automation (RPA) offering, UI Flows, combines the strengths of API automation, intelligence, and legacy automation to achieve broad and deep scenarios with ease.…
	Connect legacy web apps with RPA Suvarna Darapu See how to use Microsoft Power Automate UI flow robotic process automation (RPA) capabilities for browser automation of legacy web applications that don’t support API automation through Selenium IDE.
	Simplify your work by automating routine tasks across Microsoft 365 Harysh Menon Learn how to use Microsoft Power Automate to set up automated business workflows across multiple Microsoft 365 products like Microsoft Teams, SharePoint, Outlook, Word, Excel, and more!
	Introduction to digital transformation with Power Automate Jonathon Levesque Join this session for an introduction covering UI flows, automated and business process flows in Microsoft Power Automate.
	Business process automation that helps teams do more Praveen Kumar Singh Learn how to create goal-driven Business Process Flows that streamline human processes and help your teams stay focused; combine them with Instant Flows to run background automation, and send approval…
	Industry specific applications of Power Automate, including Microsoft’s internal use Tulsi Keshkamat Take a look at some of our favorite stories of business transformation achieved by Microsoft Power Automate. Check out how an organization the size of Microsoft has benefitted from applying Power Auto…
	Power Automate and Azure Integration Services Jon Fancey, Matt Farmer Microsoft Azure opens up a whole world of possibilities to the Microsoft Power Platform with Azure Integration Services. In this session, understand how you can leverage the capabilities available in…

Power Virtual Agents

	Empower subject matter experts to drive engagement in your business using Power Virtual Agents Cleber Mori; Emma Archer; Omar Aftab; Pawan Taparia Learn more about how customers are improving engagement and productivity and reducing costs through personalized conversational intelligent virtual agents. In this session, get an overview of all new…
	Build a bot that integrates with your backend systems with Power Virtual Agent​ Marina Kolomiets; Pawan Taparia; Salem Bacha Learn how to integrate Microsoft Power Virtual Agents with your backend systems to enable bots to act on behalf of your users. As part of this session, we cover invoking Power Automate flows and call…
	Best practices for building an intelligent bot with Power Virtual Agents Murali Kumanduri Learn more about best practices that our customers follow to build successful virtual agents. This session covers what it takes to build a virtual agent that provides the best business outcomes, and h…

Power BI – Customer stories

	A Large Pet Hospital – Creating successful user centered reporting Kelsey. Wiggin; Lauren Faber; Rebecca McCarthy A Large Pet Hospital implemented Microsoft Power BI from the ground up. Their success with Power BI has been because of our presenters focus on creating user centered reports.
	Avanade – Experience Insights with Power BI Cem Urfalioglu; Lauren Faber; Mahima Bedi; Simon Windell Avanade uses Power BI and advanced analytics to understand client experiences and to grow and retain company talent.
	Humana – From disparate sources to one centralized data platform with Power BI Andrew Renda; Lauren Faber; Melissa Hooper; Sean Chandler Humana leveraged Azure services to combine 47 disparate data sources and BI tools into an analytics as a platform as a service solution. Using Power BI as the business intelligence tool, Humana has se…
	Electrolux AB – Unleashing the power of cloud scale analytics for business efficiency Lauren Faber; Meha Saxena Electrolux, an appliance company, created an innovative solution to siloed and inconsistent data using Azure and Power BI to transform the business by democratizing and embedding AI into key finance p…
	Enabling Arla Foods with Big Data and Self-Service Analytics Kasper Hansen; Lauren Faber Kasper Pors Hansen from Arla Foods walks through the journey Arla Foods took from siloed systems to one data foundation enabling successful self-service BI across the organization.
	The Nokia People Analytics Journey with Microsoft & Power BI David Shontz; Lauren Faber HR at Nokia went through a four-phase process of their people journey to consolidate and visualize data, expand the use of analytics, and develop advanced analytics. This process has enabled them to c…
	PCL – Creating a scalable pipeline to process incoming IoT data and generate new insights using Power BI. Danny Brunsch; Lauren Faber; Nathan Wong PCL, a construction company, is using Azure services, including Azure Synapse, to create an effective pipeline to get data from IoT devices all the way to being visualized in Power BI.
	The Wonderful Company – Finding a single source of truth Dhiraj Chhajer; Lauren Faber The Wonderful Company had the challenge of siloed data and systems but has used Power BI and Azure to create reports from a single source of truth from sales and financials to manufacturing and farmin…
	Standard Bank: BI+ Johannes Kleynhans; Lauren Faber Because of the foundation of Power BI that Standard Bank has in place they are able to expand on their Power BI capabilities by implementing more features and growing the user base within their compan…
	T-Mobile – Strategic Design and Deployment of Business Intelligence Reporting Lauren Faber; Shane McFarland Shane McFarland from T-Mobile has designed an innovative pre-assembled template containing a post-modeled dataset to deliver to report authors as part of Shane’s push for unification, collaboration, a…
	Rockwell Automation: Building a world-class Power BI center of excellence Chris Wagner; Lauren Faber Join us to hear how Rockwell Automation has delivered a Center of Excellence to Microsoft Power BI business users in a remarkable way.

Power BI

	Unlock insights: Power BI vision and roadmap Amir Netz; Arun Ulagaratchagan; Kim Manis; Miguel Martinez; Patrick Baumgartner; Priya Sathy This session covers the vision and future roadmap for Microsoft Power BI. Power BI is on a journey to transform how organizations work with data. Join us to learn how Power BI will continue to create…
	Create amazing data experiences with Power BI ​ Amir Netz; Bogdan Crivat; Justyna Lucznik; Kim Manis; Miguel Martinez; Priya Sathy; Vijay Gopalakrishnan Join us for demos and a discussion on creating amazing data exploration experience in Microsoft Power BI. We showcase the roadmap and demos of AI infused experiences that are instantly familiar.
	Modern Enterprise BI Amir Netz; Bogdan Crivat; Christian Wade; Miguel Martinez; Priya Sathy; Vijay Gopalakrishnan Microsoft Power BI continues to evolve its roadmap and vision on modern enterprise BI. Join us for demos and discussion on future looking capabilities that will meet the most demanding enterprise need…
	How to accelerate a data culture with pervasive BI throughout your organization Amir Netz; Kim Manis; Miguel Martinez; Priya Sathy; Sujata Narayana; Tessa Hurr; Vijay Gopalakrishnan; Will Thompson In order to build an organizational data culture, BI needs to be woven into the fabric of the organization. Join us for demos and discussion on the roadmap for how Microsoft Power BI will deeply integ…
	Bring insights to where the work gets done with Power BI and Microsoft Office Kim Manis; LUKASZ PAWLOWSKI BI is inherently a collaborative process. Learn how to bring Microsoft Power BI and Microsoft Office together to get insights to where people work and collaborate. This session covers how Power BI is…
	What’s new and coming in Power BI for enterprise-scale deployments Christian Wade Microsoft Power BI enables you to build comprehensive, enterprise-scale analytic solutions that deliver actionable insights. This session focuses on enterprise deployments requiring scalability, manag…
	Three ways that AI is changing BI Justyna Lucznik Business demands have evolved from executives asking what and when something happened, to asking why it happened—and what will occur in the future. In this session we look at three market trends where…
	What’s new in Paginated Reports Chris Finlan Experience the benefits of Paginated Reports available in Microsoft Power BI Premium. Paginated reports, long the standard report format in SQL Server Reporting Services, are now available in the Powe…
	What’s new this month in Power BI Desktop Sujata Narayana Get a lightning tour around the latest release of Microsoft Power BI Desktop! Come and see the features that we’ll be shipping in the May release of Desktop.
	Real-time reporting with Power BI Miguel Martinez; Peter Myers Want to report on data from your systems as it happens? Microsoft Power BI supports a variety of methods to get insights on data in near-real time, and in this session we show you a variety of techniq…
	Designing a Power BI Paginated Report Peter Myers In this presentation, learn about Power BI paginated reports, and see an end-to-end demonstration showing you how to design and publish one. You’ll also learn how they’re different from Power BI repor…
	Authentication patterns for Power BI embedding Ted Pattison The session examines common development scenarios with Power BI embedding and the different ways in which an application developer can interact with Azure Active Directory to authenticate users and to…
	Big data analytics with Power BI and Azure Synapse Analytics Vijay Gopalakrishnan In this session, we will walk-through the Power BI experiences in Azure Synapse Analytics and our vision in this space.
	Creating accessible reports in Power BI Meagan Longoria; Tessa Hurr According to the US Census Bureau, 19 percent of the population had a disability in 2010. Do you know if your reports are designed in an inclusive way such that everyone in your intended audience can…
	Business insights on the go with Power BI Mobile Maya Shenhav; Michal Foster Microsoft Power BI Mobile is the leading mobile BI app in the market. Join this session to learn all about the new look of Power BI Mobile and see what’s coming with building mobile optimized reports…
	Introducing deployment pipelines: The future of content lifecycle management in Power BI Nimrod Shalit BI professionals continuously improve datasets, reports, and dashboards to provide their users with the best analytics experience, but managing all those content updates can be a challenge. In this se…
	Power BI marketplace template apps Teddy Bercovitz With Power BI marketplace template apps, customers can explore and gain insights from first and third party data sources with a few clicks. Come to this session to understand what template apps are av…
	Power BI: Roadmap for enterprise information management – data protection, data lineage and impact analysis, and data discovery and catalog Adi Regev; Yaron Canari BI professionals use Microsoft Power BI today to build complex analytical projects spanning multiple data sources, artifacts, and dependencies. This session covers some of the new experiences we’re in…
	Power BI and Microsoft Information Protection: The game changer for secure BI Adi Regev; Anton Fritz BI professionals use Microsoft Power BI today to build complex analytical projects spanning multiple data sources, artifacts, and dependencies. This session covers some of the new experiences we’re in…
	Learn how to govern Power BI visuals inside your organization Ranin Salameh With the large variety of visuals and related options, learn how to govern and manage Microsoft Power BI visuals inside your organization, and learn what’s coming soon!
	What’s new and what’s next in Power BI embedded analytics Alon Baram; Amit Shuster Until recently, embedding Power BI analytics into applications was primarily associated with ISVs quickly and easily providing customer-facing reports and dashboards in their own SaaS offerings, using…
	Learn about our data connector ecosystem in Microsoft Power Apps, Power Automate, and Azure Logic Apps Bob Zhang In this session, learn all our data connectors for Microsoft Power Apps and Microsoft Power Automate. Connectors are essential in empowering users to do more with their data in the Power Platform, and…
	Power Platform and Excel: Connect and transform data from hundreds of data sources using Power Query Dharini Sundaram; Miguel Llopis Business users spend a significant amount of their time working on data preparation before the data is ready to be used. Power Query and M are Microsoft’s data connectivity and data preparation techno…
	Power BI Premium and how to get the most out of it David Magar Learn about new features and techniques to manage Microsoft Power BI Premium. This session is recommended for anyone who is responsible for the management of their Power BI Premium deployment.
	Gaining insights on Common Data Service data by continuously exporting to Azure Data Lake Mudit Mittal; Sabin Nair Export to data lake service simplifies the technical and administrative complexity of operationalizing entities for analytics and managing schema and data. In this session, learn how to link your Comm…
	Best practices to install and manage on-premises data gateway Arthi Ramasubramanian Iyer In this session, learn best practices for setup and configuration of the on-premises data gateway along with troubleshooting tips and tricks, investigate bottlenecks, and resolve your common gateway e…
	Power Platform: Enterprise-grade ETL and data preparation using dataflows Ben Sack; Miguel Llopis Preparing and defining ETL for business intelligence, app development, and process automation is a significant challenge for businesses today — ingestion, cleansing, transformation, and enrichment are…

Relevant sessions from the Dynamics 365 FastTrack team

	Embracing citizen developer adoption in a customer engagement world using Power Platform John Estrada Share best practices for challenges and opportunities of utilizing both citizen developer adoption and customer engagement models within the same organization. Deployment of customer engagement with i…
	Re-imagining end user experience on Dynamics 365 and Power Platform Danielle Aronson Microsoft Dynamics 365 Customer Engagement customers will need to transition from use of Classic UI to Unified Interface. It’s an opportunity for our customers to deliver a world-class UI to their end…
	Data management strategies with Dynamics 365: How to turn data into insight for your users Kuntal Ghoshal With the desire to extract insights from increasingly large data sets, what Microsoft Power Platform strategies should be used to best bring impact to your users? Learn how throttling is intended to d…
	Dynamics 365 CE Application Lifecyle Management Best Practices: A key factor to successful implementation Gregg Barker Learn how to fully automate the entire application lifecyle management process on Dynamics 365 customer engagement.
	Using classic Workflow? There is a better way to automate our business process Dean Hardy Share the best practice in using Microsoft Power Automate to automate your business process to improve productivity in your day-to-day activities.
	Rethink your configuration and customization strategy on Power Platform Vinoth Balaubramanian With innovations and investments in Microsoft Power Platform, how should we rethink our configuration and customization approaches to take advantage of new and future investments.

Certification

Certification and Training for Power Platform Margo Crandall Join this session to get an update on our recent investments in self-paced and instructor led training and certifications for critical roles to enable adoption in your organization like App Maker, Dat…

Industry Accelerators

	Industry panel: How business applications offerings align to drive impact for customers and partners Kim Mathisen; Lorraine Bardeen; Sara Nagy Hear from Microsoft executives in the Business Applications Industry and Customer Success team on how we are approaching the development of industry solutions, with custom data models and templates, b…
	Manufacturing & Supply Chain Accelerator Omar Choudhry Manufacturing companies are innovating to to be more predictable, agile, and provide more personalized experiences. At the core of this transformation is the ability to tap into the volumes of availab…
	Future of enhanced care coordination with Dynamics and Power Platform in healthcare Edgar Wilson II The Healthcare CDM is the foundational component within the Microsoft Power Platform and Microsoft Dynamics 365 that enables partners and customers to quickly build vertical healthcare solutions. The…
	Future of customer experience through the Financial Services Accelerator James Galvin Financial services organizations are innovating to provide differentiated and personalized experiences. At the core of this transformation is the ability to tap into the volumes of available data—from…
	Healthcare industry update Edgar Wilson II How can technology be used to help the healthcare industry during the current COVID-19 crisis? How is a Microsoft Dynamics 365 application for healthcare is at the core of Microsoft’s strategy? Join u…
	Drive expanded fan engagement through the Media Accelerator Martin Wahl Successful media and entertainment providers know the key to success is understanding your audience and then personalizing that experience. From sports arenas and teams, tourist attractions and theme…
	Building education solutions for the 21st century and beyond Meenoo Rami Industry Accelerators are foundational components within the Microsoft Power Platform and Dynamics 365 that enable partners and customers to quickly build industry vertical solutions. The Dynamics 365…
	View the future of the automotive business Ilan Ostfeld Industry Accelerators are foundational components within the Microsoft Power Platform and Dynamics 365 that enable partners and customers to quickly build industry vertical solutions. Automotive Showc…
	Partner interview: Nonprofit and healthcare Edgar Wilson II; Greg Teich The nonprofit and healthcare industries are using technology to adjust to the rapid global changes from COVID-19. Join us for an interview of nonprofit and healthcare partners to learn how they are ut…
	Driving social impact with Power Platform apps: Nonprofit Toolkit and Program Design Erin Mchugh Saif; Meenoo Rami No-code and low-code solutions can be a game-changer for nonprofit and humanitarian organizations where IT resources are limited, but the commitment to the mission is ubiquitous. Learn about the late…
	Driving nonprofit sector interoperability with the Common Data Model for Nonprofits and Nonprofit Accelerator Erin Mchugh Saif From program delivery to fundraising to beneficiary management, nonprofits are under tremendous pressure to expand their programming to meet new needs, operate efficiently, and demonstrate measurable…

The post Microsoft Business Applications Summit 2020 – Power Platform sessions quick reference appeared first on Microsoft Power Platform Blog.

This blog post attempts to provide a ready list of all the sessions for quick reference.

Additionally, a PowerApps canvas app version of this list is available in the Community Apps Gallery for easy viewing of the sessions and sharing it broadly with your colleagues.

Click the image below to download the canvas app and use the Browse Files option in the PowerApps Studio to upload this app in your tenant.

The shortcut for this blog for easy reference is https://aka.ms/pa/mbas2019

This blog was updated on 7/11/2019 and the hyperlinks were updated to point to respective sessions in the Microsoft Business Applications Summit Gallery.

• Keynote – 1 Session
• Real world stories – 7 Sessions
• PowerApps – 26 Sessions
• Microsoft Flow – 19 Sessions
• Common Data Service – 6 Sessions
• Data Integration – 4 Sessions
• Admin & Governance – 9 Sessions
• AI Builder – 2 Sessions
• Azure – 2 Sessions
• Power BI – 6 Sessions
• Dynamics 365 – 11 Sessions
• ISV Solutions – 4 Sessions
• Other Sessions – 2 Sessions

Total – 99 Sessions

Keynote

Opening keynote Opening keynote | James Phillips James Phillips, Corporate Vice President, Business Applications Group, and business leaders from across industries give you a preview of what’s next in the 2019 release wave 2 for Dynam…

Real world stories

	Real World Stories: The rise of citizen development Citizen developers | Sameer Bhangar, Lauren Taylor, Keith Whatling, Rebecca Sackett, Nick Gill, Ladd Laird Lauren Taylor is a vice principal at an elementary school who built apps, flows and dashboards to improve student reading skills. Rebecca Sackett used Microsoft Flow to automate generat…
	Real World Stories: Perspectives from IT executives on bottom-up innovation and the Microsoft Power Platform IT executives & bottom-up innovation | Nipa Chakravarti, Sameer Bhangar, Ian Doyle, Kent Weare Nipa Chakravarti leads digital transformation at Inter Pipeline and has bet on the Microsoft Power Platform to fuel bottom-up innovation as a core pillar of the transformation strategy.…
	Real World Stories: Citizen developers and enterprise IT find success with Microsoft Flow Microsoft Flow | Sameer Bhangar, Kent Weare, Scott Stanley, Luise Freese, Eric McKinney, Keith Whatling The Calgary Public Library uses Microsoft Flow to provide quicker responses for customers needing assistance. G&J Pepsi and Inter Pipeline use several flows every day to speed up busine…
	Real World Stories: Global energy companies power digital transformation with Microsoft PowerApps Energy | Sameer Bhangar, Warren Bryant, Wei Jerry Wu, Ladd Laird, Kenric Auguillard, Alan KL Chai, Pratap Ladhani Global organizations in the oil and gas sector are using the Microsoft Power Platform to optimize business processes faster than ever before. Central IT teams have established a Center…
	Real World Stories: Manufacturing companies embrace lean development with Microsoft PowerApps Manufacturing | Sameer Bhangar, Simon Owen, Rebecca Sackett, Vivek Bavishi Simon Owen’s IT team at GSK, a global consumer healthcare manufacturing company, embraced the Power Platform to shed old ways of working in favor of a lean mindset. They’ve inspired a r…
	Real World Stories: Non-profits use Microsoft PowerApps to drive meaningful impact Nonprofits | Kathy Joachim, Deepash Shah, Jarid Siegel, Nick Gill, Sameer Bhangar, Matt Vardy Kathy Joachim is a volunteer at the American Red Cross who built several PowerApps to help volunteers get better organized and save time during disasters. Jarid Siegel created a PowerAp…
	Real World Stories: Global transportation companies move faster with Microsoft PowerApps Transportation | Sameer Bhangar, Martin Zandegiacomo, Manuela Pichler, Ludovic Malondra, Mélanie Angibaud Martin Zandegiacomo led the effort at the Swiss Federal Railway (SBB) to migrate over 200 legacy SharePoint forms to PowerApps. Manuela Pichler manages an “”IT lite”” team at Virgin Atlan…

PowerApps

	Microsoft PowerApps: Vision and roadmap Vision & Roadmap | Charles Lamanna, Ryan Cunningham See what’s new and what’s coming in the next release for Microsoft PowerApps. Learn all the details about the rapid pace of innovation and strategic trajectory of PowerApps.
	Microsoft PowerApps: Run one UI – the future of canvas, model-driven, and Unified Interface in PowerApps Convergence of Canvas & Model-driven apps | Clay Wesener, Rick Prologo Microsoft PowerApps is converging on a single, powerful platform for building and customizing app user experiences. See what’s new and what’s coming next for Unified Interface, the mode…
	Microsoft PowerApps: Building and extending applications Build & extend apps | Matt Barbour Learn about the capabilities Microsoft PowerApps has for the application developer. In this session we focus on the core extensibility areas; starting with an overview and demonstration…
	Microsoft PowerApps: Introducing PowerApps portal for external users PowerApps Portals | Dileep Singh, Sandeep Dhanrajani Learn how PowerApps customers can create websites over data stored in Common Data Service that can be accessed by external users with a wide variety of identities including personal acc…
	Microsoft PowerApps: Building custom components using PowerApps component framework PowerApps component framework | Hemant Gaur Build with Microsoft PowerApps! The PowerApps component framework (PCF) provides a powerful way to create reusable and unified controls across both model and canvas applications. Learn…
	Microsoft PowerApps and SharePoint: Better together SharePoint | Chris McNulty SharePoint lists and libraries are already home to a wealth of business data. Take a deep dive into how to build immersive applications and tailored forms that integrate multiple data s…
	Microsoft PowerApps: The master class on building performant apps Performant Apps | Mehdi Slaoui Andaloussi Your app is slow? See how we take an existing poorly performing app and apply various performance optimizations and tricks to drastically improve its performance and responsiveness.
	Microsoft PowerApps: Introduction to PowerApps and integration with Power BI Power BI Integration | Prathy Kamasani, Charles Sterling PowerApps is a service that lets you build business apps that run in a browser or on a phone or tablet, with no coding experience required. PowerApps combines visual drag-and-drop conce…
	Microsoft PowerApps: Enabling disconnected model apps Offline Model-driven apps | Balakrishnan Shanmugam, Kavishi Agarwal In this session, we explore how to leverage PowerApps Mobile offline in model driven apps to enable productivity for intermittently connected mobile employees.
	Great data-driven experiences over the Common Data Service Data-driven experiences | Sid Gundavarapu New to model-driven forms and views? Learn how to quickly generate powerful screens over CDS data that bring together sophisticated user experiences with ease.
	Great data-driven experiences over the Common Data Service (Repeat) Data-driven experiences (repeat) | Sid Gundavarapu New to model-driven forms and views? Learn how to quickly generate powerful screens over CDS data that bring together sophisticated user experiences with ease.
	Microsoft PowerApps: What’s new with Microsoft Power BI integration with PowerApps Power BI Integration | Daniel Christian With the deep integration between PowerApps and Power BI you can now go above and beyond just viewing the data. This theater session demonstrates how live data can be entered in a Power…
	Microsoft PowerApps: What’s new with Microsoft Power BI integration with PowerApps (Repeat) Power BI Integration (repeat) | Daniel Christian With the deep integration between PowerApps and Power BI you can now go above and beyond just viewing the data. This theater session demonstrates how live data can be entered in a Power…
	Microsoft PowerApps: Deliver higher quality apps with PowerApps checkers PowerApps Checkers | Evan Chaki See how you can use the PowerApps checker to pinpoint performance and stability risks in your apps, entities, and business logic – with in-depth guidance on how to fix issues to make fa…
	Microsoft PowerApps: Deliver higher quality apps with PowerApps checkers (Repeat) PowerApps Checkers (repeat) | Evan Chaki See how you can use the PowerApps checker to pinpoint performance and stability risks in your apps, entities, and business logic – with in-depth guidance on how to fix issues to make fa…
	Microsoft PowerApps: What’s new with PowerApps controls? Controls | Filip Karadzic Get hands on with the latest PowerApps controls for canvas and model-driven apps, and get a peek at what’s coming next.
	Microsoft PowerApps: Migrating your legacy InfoPath and Access forms and apps to PowerApps Infopath migration | David Chennault, Greg Lindhorst, Andrew Welch, Martin Zandegiacomo You want to modernize and your business and productivity processes using PowerApps and Microsoft Flow, but with myriad legacy InfoPath forms and Microsoft Access apps, you don’t know wh…
	Microsoft PowerApps: Moving InfoPath forms to PowerApps Infopath migration | Shane Young Do you have a million InfoPath forms that you would like to move to PowerApps? If so, this is the quick session for you. We talk about how to start thinking about all of those forms and…
	Microsoft PowerApps: Top 10 tips and tricks from building over 200 PowerApps Canvas apps – Top 10 tips | Shane Young Boost your Microsoft PowerApps skills with lessons learned from working on hundreds of PowerApps with people across the globe. Learn things like building focused apps, common processes…
	Microsoft PowerApps: Make responsive canvas apps that work with any screen size Responsive Canvas apps | Emma Cooper Canvas apps can now respond to any screen width! Learn tips and tricks for how to take advantage of these new capabilities in your apps.
	Microsoft PowerApps: The future of maker experiences in PowerApps Future of maker experiences | Matthew Bolanos Make.PowerApps.com is here – see how we’re improving usability across PowerApps with a fast, cohesive experience for app makers and admins.
	Build a model-driven app in 10 minutes Build a Model-driven app in 10 mins | Praveen Kumar Singh New to model-driven apps? Learn how to quickly build powerful apps from CDS data, that make business simple and delightful for end users.
	Build amazing model-driven forms, including embedded canvas components Embed canvas apps in model-driven apps | Anees Ansari Learn how to take your authoring experience to the next level with the new model-driven form designer. It provides a modern, clean, and productive interface with a live WYSIWYG preview…
	Common Data Service: Use the Mail app to bring Common Data Service into Outlook Model-driven apps in Outlook | Srihari Srinivasa See how the Mail app for Outlook can bring Common Data Service (CDS) data right into the email experience for higher productivity where users are working.
	Microsoft Power BI: Integrate interactive Power BI reports in your portal Portals + Power BI | Sandeep Dhanrajani Learn how to integrate Power BI reports/charts in your portal and make it dynamic, based on the logged in user.
	Microsoft PowerApps and Microsoft Flow: Let AI, ML, and Microsoft Flow take content moderation to the next level Flow, AI & ML | Daniel Christian The options for storing content and for social collaboration are abundant, and now with Microsoft Flow you can do even more. However, with more power comes more responsibility and this…

Microsoft Flow

	Microsoft Flow: Vision and feature roadmap Vision & Roadmap | Stephen Siciliano Microsoft is modernizing business processes across productivity and business applications – and it is now easier for every business to transform the way they work. Microsoft Flow is Mic…
	Microsoft Flow: Advanced expressions for Microsoft Flow Advanced Expressions | Stephen Siciliano Get a deep look into advanced techniques and expressions used to build complex workflows with Microsoft Flow.
	Microsoft Flow: Approvals in 60 minutes Approvals | Scott Shearer In this demo rich session, learn how to create a simple Microsoft Flow approval. First, see how you can leverage Office 365 features to determine to whom an approval should be submitted…
	Microsoft Flow: Digitally transform your business Bottom-up innovation | Jonathon Levesque, Kent Weare Discover how to digitally transform with Microsoft experts. In this demo-heavy session, learn about bottom-up innovation with Microsoft Flow and its potential meaning for your organizat…
	Microsoft Flow: Digitize human-driven processes with Microsoft Flow Business Process Flows | Karan Srivastava Discover how to digitize human-driven processes with Microsoft Flow. In this session, we cover working with business process flows and approvals to deliver guidance on tasks, getting si…
	Microsoft Flow: Automate the Common Data Service with Microsoft Flow Common Data Service | Stephen Siciliano, Karan Srivastava Modern flows are the successor to the classic Microsoft Dynamics 365 workflow engine. In this session we walk through common scenarios that classic workflow is used for and how those pa…
	Microsoft Flow and SharePoint: Tips and tricks from the masters SharePoint – Tips and tricks | Audrie Gordon, Chris McNulty Microsoft 365 provides a rich toolkit for empowering teamwork in your organization. Process automation with Microsoft Flow can be a game changer. Join us for a deep dive into best prac…
	Microsoft Excel: How I leveraged Excel, Microsoft Flow, Power Query, and Power BI to optimize business processes in operations and supply chain Excel, PowerQuery & Power BI | David Monroy All businesses are striving to make better decisions in a faster way. When coupled with quickly increasing volumes of data, and tools that don’t scale at the same pace, it is common to…
	Microsoft Flow: Embedding Microsoft Flow in your own application Embed Flow in your apps | Sunay Vaishnav See how to build Microsoft Flow directly into your SaaS application. Microsoft Flow can be used to provide native business process and workflow capabilities for any SaaS application. Jo…
	Microsoft Excel: Automate processes inside of Excel Excel | Ashvini Sharma You can now use Microsoft Flow to build automation inside of Excel. Learn how the Flow Excel add-on lets you author flows right in the context of a workbook and then select any amount o…
	How Microsoft Flow makes bots and cards easy for everyone Bots & cards | Audrie Gordon Learn how Microsoft Teams leverages Microsoft Flow so any user can easily create a bot that responds to messages. Anyone can now create a bot that does everything from simple messages t…
	How Microsoft Flow makes bots and cards easy for everyone (Repeat) Bots & cards | Audrie Gordon Learn how Microsoft Teams leverages Microsoft Flow so any user can easily create a bot that responds to messages. Anyone can now create a bot that does everything from simple messages t…
	Microsoft Flow: Conquer data performance challenges with Microsoft Flow as your query engine Data performance | Audrie Gordon Learn the secrets to retrieving data queries directly from Microsoft Flow into your PowerApps applications as part of OnStart and OnVisible screen loads. Master precise filtered data qu…
	Microsoft Flow: Approvals in 20 minutes Approvals | Scott Shearer In this demo rich session, learn how to create a simple Microsoft Flow approval. First, see how you can leverage Office 365 features to determine to whom an approval should be submitted…
	Microsoft Flow: Using Microsoft Flow to drive Dynamics 365 Marketing List Communications Dynamics 365 + Marketing List communications | Jerry Weinstock In this session, you will see a demonstration of several different Flows that a Marketing Specialist can use in Dynamics 365 Customer Engagement to complement their other communication…
	Microsoft Flow: Building out Service Case Management Dynamics 365 + Service Case Management | Jerry Weinstock In this session, learn how to build out a fully functional case processing system using Microsoft Flow and Dynamics 365. This system will use these features, connectors and processes in…
	Design and create business workflows automatically using Microsoft Excel, Flow, and Visio Excel & Visio | Shashank Gandhi As business process owners, have you ever wanted to turn a complex business process diagram into an automated workflow seamlessly? With Microsoft Flow, business owners can already build…
	Design and create business workflows automatically using Microsoft Excel, Flow, and Visio (Repeat) Excel & Visio | Shashank Gandhi As business process owners, have you ever wanted to turn a complex business process diagram into an automated workflow seamlessly? With Microsoft Flow, business owners can already build…
	Microsoft Flow for SharePoint SharePoint | Scott Shearer Now’s the time to begin using Microsoft Flow for your SharePoint automation tasks. In this session, see how Flow compares to SharePoint Designer workflows. Learn how to use Flow for the…

Common Data Service

	Microsoft PowerApps: What’s new in the Common Data Service for Apps What’s new | Ryan Jones Understand and learn the latest capabilities and innovations in the Common Data Service for Apps. We discuss what’s important, Microsoft Dynamics customizers, and standalone PowerApps m…
	Microsoft PowerApps and Common Data Service: Heterogeneous storage in the Common Data Service Heterogenous Storage | Nathan Helgren, Andreas Muenzinger, Maya Dumesh Learn how to leverage the new storage capabilities of the Common Data Service to support a wide variety of new data types.
	Microsoft PowerApps and Common Data Service: Identity and sharing with the Common Data Service CDS & Identity | Paul Liew The Common Data Service integrates more deeply with Azure Active Directory than ever before! In this session, explore how you can leverage CDS and AAD to improve the security and compli…
	Microsoft PowerApps: Optimizing custom code and plugins in the Common Data Service Optimizing custom code & Plug-ins | Jim Daly Plugins are used to implement custom logic in the Common Data Service. In this session, we discuss how plugins work as well as common pitfalls to avoid.
	Common Data Service: Seamlessly enable CDS entities for analytics with out-of-the-box Azure Data Lake integration Azure Data Lake | Sabin Nair, Mudit Mittal Our vision is to empower our customers to gain comprehensive insights and drive business actions based on their data in the Common Data Service. Learn how Athena effectively builds a da…
	Microsoft PowerApps: Planning your enterprise deployment – Capacity Management Capacity management | Varun Dewan This will cover the details for how to plan and manage the environments & resources necessary for an enterprise deployment of PowerApps.

Data Integration

	Microsoft Power BI, Flow, and PowerApps: Working with data in the Power Platform Working with Data | Mahesh Prakriya, Sameer Chabungbam Data is critical for the success of every organization. The Microsoft Power Platform (Power BI, PowerApps and Flow) provides a suite of tools to measure, act and automate processes arou…
	Microsoft Power BI, Flow, and PowerApps: Connecting to data using the on-premises data gateway Data Gateway | Arthi Ramasubramanian Iyer, Naveen Sivaraj Hybrid data landscapes are common for our enterprise customers. The on-premises data gateway enables connecting to data sources “behind a firewall” from online services (like Power BI,…
	Microsoft Flow and PowerApps: Building data connectors Connectors | Sameer Chabungbam, Kelli Waiss In this session, learn all about building connectors for Microsoft PowerApps and Microsoft Flow. Connectors are essential to get you the data you want. This session provides an overview…
	Microsoft Flow and PowerApps: An open sourced connector development Connectors | Sameer Chabungbam A growing connector ecosystem plays an important part in the strategy of Microsoft PowerApps and Flow.  In this session, we will talk about this strategy – particularly focusing on open…

Admin & Governance

	Microsoft PowerApps and Microsoft Flow: Top 10 tips to securely rolling out Microsoft PowerApps and Microsoft Flow to your organization Secure, Monitor and Govern | Austin Laugesen, James Oleinik Get ahead of common issues with broader enterprise adoption of Microsoft PowerApps and Microsoft Flow. We cover the enterprise governance vision and roadmap; sharing the top tips to com…
	Microsoft PowerApps and Microsoft Dynamics 365: What’s new for PowerApps and Microsoft Dynamics 365 admins What’s new for Admins | James Oleinik As your company’s internal adoption of PowerApps, Microsoft Flow and the Common Data Service for Apps grows, so does your need to protect your company’s data, control access, and monito…
	Microsoft PowerApps and Microsoft Flow: Best practices for managing and automating Managing & Automating | James Oleinik, Mehdi Slaoui Andaloussi, Evan Chaki New apps, flows, and custom connectors are built, shared, and used in your company every day. Join this session to learn how you can automate the administration and governance of all of…
	Microsoft PowerApps: Tried and tested techniques for establishing a Center of Excellence Center of Excellence | Saurabh Pant, Pratap Ladhani Learn how enterprise IT departments have established a Center of Excellence (CoE) to drive internal adoption of Microsoft PowerApps and handle governance for hundreds of production apps…
	Microsoft PowerApps: How to get the best support for PowerApps, Flow, and Dynamics 365 How to get best Support | Varun Dewan You’ve hit an issue building a canvas app, or a user in your org can no longer sign-in to their Dynamics 365 application – what do you do next? In this session we’ll explore the best pr…
	Microsoft PowerApps: Monitoring and supporting PowerApps at scale Monitoring & Support | Brandon Simons, Varun Dewan Come learn about recent enhancements that help administrators, makers, and developers ensure their PowerApps environments are running smoothly. Understand key tools that are available,…
	Microsoft PowerApps: Five must-have governance controls when using PowerApps in enterprise organizations 5 Governance controls | Alex Fagundes, Venkat Rao Did you know your organization’s data could be at risk, and may already have a data leak? Did you know that a savvy user can easily bypass database controls and access your confidential…
	Microsoft PowerApps and Microsoft Dynamics 365: Modernizing the way we update Dynamics 365, PowerApps, and CDS Modernizing updates | Manas Maheshwari We constantly improve Dynamics 365 and PowerApps to maximize functionality, availability, and performance. In this session, we will discuss how to plan for your solutions to leverage t…
	Microsoft PowerApps and Microsoft Dynamics 365: Best practices for setting up security and environments in the Power Platform Admin Center Set up security & environments for CDS | Nikitha Gajula Do you find yourself dealing with ongoing escalations from your business team around access, sign-in, and data quality issues? In this session targeted to central IT, department admins,…

AI Builder

	Microsoft PowerApps and Microsoft Flow: Introduction and Roadmap for AI Builder, the no-code AI experience of the Power Platform Vision & Roadmap | Gautam Thapar, Jamel Gafsi See what’s new and what’s coming next in the Power Platform and AI Builder.
	Microsoft PowerApps and Microsoft Flow: Learn how to create AI Builder models and use them across the Power Platform AI Builder models | Benoit Fabre, Christine Jefson Learn about the functionalities and best practices to achieve your digital transformation through the Power Platform and AI Builder. AI Builder provides AI templates (Binary Classificat…

Azure

	Microsoft PowerApps and Microsoft Flow: Leveraging Azure Integration Services from the Power Platform Azure Integration Services | Jon Fancey Microsoft Azure opens up a whole world of possibilities to the Power Platform with Azure Integration Services. In this session, understand how you can leverage the capabilities availabl…
	Microsoft PowerApps and Microsoft Flow: Building end-to-end Blockchain solutions Using Azure Blockchain Service Azure Blockchain Service | Marc Mercuri, Jason Anderson, Chris Segura In this session, learn how to bring together Azure Blockchain Service with PowerApps and Microsoft Flow to build an end-to-end blockchain solution. Discover how you can easily leverage…

Power BI

	Microsoft Power BI: Democratizing self-service data prep with dataflows Dataflows | Miguel Llopis, Ben Sack Preparing and defining ETL for insights is a significant challenge for businesses today — ingestion, cleansing, transformation, and enrichment are labor-intensive and time-consuming tas…
	Microsoft Power BI: Connect and transform data from hundreds of data sources using Power Query PowerQuery | Miguel Llopis, Mahesh Prakriya, Matt Masson Business users spend a significant amount of their time working on data preparation before the data is ready to be used. Power Query and M are Microsoft’s data connectivity and data pre…
	Microsoft Power BI: Using the Power platform to radically change your business Power BI + PowerApps + Flow | Adam Saxton, Patrick LeBlanc Follow us on a journey through the Power platform. This session uses business scenarios that span across Microsoft Flow and PowerApps, and then uses Microsoft Power BI to bring it all t…
	Customer stories with Atrium Health and JCI Customer Stories – Atrium Health & JCI | Beth Schwenzfeier Griffith, Bradley Allen, Adam Harper, Christopher Haas, Gurmanik Grover In this session, see the scorecard evolution of Atrium Health from Tableau to Microsoft Power BI, with a wide range of applications from physicians scorecard to transplant and opioid pr…
	Microsoft Flow and Power BI: Build a real-time dashboard in 20 minutes Flow + Real time dashboard | Will Thompson Want to get started using real-time data with Microsoft Power BI? Learn how Microsoft Flow and Power BI can be used together to push data captured from a form into a real-time dashboard…
	Microsoft Power BI: Cash flow in Power BI and PowerApps Cash flow with PowerApps | Belinda Allen, MARIANO GOMEZ One of the first things we all learn in Business 101 is that cash is needed to operate a business. We also learn that being profitable does not mean you have cash in the bank. Have you…

Dynamics 365

	Implementation Best Practices for Dynamics 365: Making the move to modern Unified Interface Move to UCI | Nikita Polyakov Dynamics 365 Customer Engagement customers will need to transition from use of Classic UI to Unified Interface and we want customers to find that transition as seamless and rich as it c…
	Microsoft Dynamics 365 for Talent: Extending the solution Extending Talent | Harsh Chandra Match the uniqueness of your people and company with a talent solution that can flex to match. Join us to learn how Dynamics 365 for Talent can extend from OOTB best-practice capabiliti…
	Microsoft Dynamics 365 Project Services Automation (PSA): New Project Service and PSA experience Project Service Automation | Gurkan Salk, Russel Hercules Join this session to get a glimpse of the enhanced project management capabilities coming to Microsoft Dynamics 365 for Project Service Automation through seamless integration of the ne…
	Microsoft Forms Pro: Build a more engaged and data-driven culture with surveys from Forms Pro Forms Pro | Welly Lee, stephanie whitaker Come learn about Forms Pro and see how to integrate your survey data with your existing data and drive deeper engagement with this new survey tool. During this session we offer a live d…
	Microsoft Dynamics 365 for Finance and Operations and Common Data Service Dynamics 365 F&O + CDS | Manali Dongre, Rama Krishnamoorthy During this session, learn the approach being taken for how Microsoft Dynamics 365 for Finance and Operations will integrate with CDS. Learn how you can leverage this data for your Dyna…
	Microsoft Dynamics 365 for Finance and Operations: How Dual Write enables F&O customers to natively get data into CDS Dynamics 365 F&O + Dual-write | Sabin Nair, Mudit Mittal Learn how Microsoft Dynamics 365 for Finance and Operations customers can use Dual Write to seamlessly connect and natively get their data in Common Data Service. With a few clicks, cus…
	Microsoft Dynamics 365 for Finance and Operations: Workflow to Flow Dynamics 365 F&O + Flow | Chris Garty This fast-paced session walks you through updates being planned for workflow and how to you can leverage Microsoft Flow for your business processes.
	Microsoft Dynamics 365 for Finance and Operations: Business Events framework Dynamics 365 F&O + Business Events | SUNIL GARG, Chris Garty Join this session to learn about Microsoft Dynamics 365 for Finance and Operations Business Events framework. We provide the roadmap for Business Events, Workflow Business Events, and D…
	Microsoft Dynamics 365: Automating the enterprise with Dynamics 365, Microsoft Flow, and the InRule Decision Platform InRule Decision Platform | Mark Lonsway Looking to make the most of your Microsoft Dynamics 365 investment? Empowering Dynamics apps with InRule’s Decision Management platform alleviates the need for complex plug-ins and Java…
	Microsoft Dynamics 365 Business Central: Building connect apps Business Central | Hunter Feltman Explore how to use exposed APIs to connect to a Microsoft Dynamics 365 Business Central tenant from any programming language/environment. Learn how to replicate data to Common Data Stor…
	Microsoft Dynamics 365 Business Central: A unified solution Business Central | Errol Schoenfish Microsoft Dynamics 365 Business Central is a unified solution with many other Microsoft services. Come to this session to better understand the unification points and how to get started…

ISV Solutions

	Microsoft PowerApps: Accelerate your journey for building and managing ISV solutions on the Power Platform ISV Solutions | Omar Choudhry, Julie Strauss Making ISVs more effective and enabling app developers to bring high quality solutions to market faster are key priorities for us! Join this session to learn about all the new investmen…
	Microsoft PowerApps and Power BI: The future of Business Apps through Industry Accelerators using the Power Platform Banking & Automotive Solutions | Smith Codio, James Galvin, Steven Guggenheimer Demands to create impactful business apps continues to increase faster than resources become available and managing data, creating apps and getting them to where your users are is alway…
	Microsoft Dynamics 365 Common Data Model and Accelerator: Industry momentum Nonprofit Solutions | Erik Arnold, Steven Guggenheimer Microsoft’s commitment to open source computing is at the core of our approach to common data models and accelerators that drive out of the box functionality through sample apps, data s…
	Microsoft PowerApps and Power BI: Driving global impact through industry Accelerators CDM for Nonprofits | Erik Arnold, Daniel Lammot How can technology be used to drive global good and how is a Dynamics 365 Accelerator at the core of Microsoft’s strategy? Join Erik Arnold, Chief Technology Offer Microsoft Tech for So…

Other Sessions

Return to Top

	Microsoft PowerApps: Streamline business processes using SharePoint with PowerApps Custom Views and Microsoft Flow SharePoint | Christina Wheeler PowerApps is a very powerful Software as a service (SaaS) tool used to build powerful data-driven business applications using a WYSIWYG drag and drop designer and Excel-like formulas. I…
	Accelerate business transactions, using AI-powered e-signature and document technologies from Adobe integrated into Microsoft Dynamics, Flow and PowerApps Adobe Sign, Acrobat & Sensei | Garrett Schwartz Find out how Adobe is using Microsoft and Adobe technologies to automate enrollment, on-boarding and contracting processes across Sales, human resources, and Procurement. Adobe’s techno…

The post Microsoft Business Applications Summit 2019 – session list quick reference appeared first on Microsoft Power Platform Blog.

This blog post is applicable to you, only if you see a “Upgrade Now” link in the Admin Center as shown in the screenshots of this blog post.

We also want to ensure that everyone understands that the data stored for the Flow Approvals feature is stored in the CDS instance in the Default Environment, and if their Default Environment has a previous version CDS instance, the tenant admin must upgrade this instance to preserve that data (Pending Approval Requests and Approval History). See the Flow Approvals documentation for more details.

Motivation

There are two main reasons to consider if your previous version of CDS instance needs to be upgraded:

1. Users are using the Flow Approvals feature

   If the organization uses the Flow Approvals feature, the data related to Flow Approvals is stored in the CDS instance of the organization’s Default Environment.  If the organization wants to preserve Flow Approvals history and Approvals currently in transit, they will need to upgrade the previous version of CDS instance in their Default Environment.

2. Users in the tenant need to preserve data in their previous version CDS instance

   If there are previous version of CDS instances with data the organization needs to preserve, these instances should be upgraded. This will usually only be possible if the users that created the database or custom tables in the database had the paid licenses or a trial paid license to use the premium CDS feature.

Understanding the role of CDS in the Default Environment

Approvals data are stored in the Default Environment’s CDS instance

It is important to understand that the Default Environment’s CDS instance is the database that stores the Flow Approvals data used throughout the entire tenant. When the first Approval request is sent on a tenant, a CDS instance is automatically provisioned in the Default Environment if one did not already exist. This is important to know because many might not have been aware of this change when using the Approvals feature, as it happens behind the scenes. If the Approvals feature is being used anywhere in the tenant, all Approvals history or currently pending Approvals data is stored in the CDS instance in the Default Environment.

If the Default Environment has a previous version of CDS instance with Approvals data and is not upgraded by the deadline, the Approvals data (history and pending Approvals data) will be deleted when the instance is deleted.

If the tenant admin decides to upgrade the Default Environment, he or she should be aware that Approvals functionality will stop during the downtime expected in step 3. Approvals history and pending Approvals will not be accessible by anyone until the migration step has completed.

Other Environments with a CDS instance do not store Approval data. Only the data that was added by the contributors will be in those instances.

Flow Approvals and licensing

Upgrade to CDS has no impact on licensing for Flow Approvals

Expectations for the Default Environment after upgrading

All users of the organization will get access to Model-driven app capabilities besides Canvas apps and Flow after upgrading the Default Environment to CDS for Apps. This does not necessarily mean they will be able to build Model-driven apps because a P2 license is required, but they can start a P2 in order to create Model-driven apps.

How Security Roles are impacted after upgrading the CDS in the Default Environment

The way database and environment permissions are managed in previous version of CDS is different than in the new CDS for Apps, so the upgrade will change how the roles are expressed. The security roles are managed in the CDS for Apps database, and requires configuration in the portal.

Here is how the security settings will migrate as part of the upgrade process:

1. In the Default Environment, all Global Tenant Admins for the Tenant will automatically have System Administrator role to the CDS for Apps database as well – see this documentation for the details about these predefined roles
2. Any Users configured as Environment Makers will be granted the following Security roles: Environment Maker & Common Data Service User roles – see this documentation for the details about these predefined roles
3. Any Users configured as Environment Admins in the Environment will be granted the System Administrator role – see the Environment permissions topic for more details
4. We don’t have the ability to configure security roles for Security Groups Hence we cannot automatically grant permissions to Security Groups in the new environment, so the administrator has to manually assign security roles to the users belonging to those security groups.

In the previous version of CDS we had the concept of Open database, where the data stored in the common data service was open to all users. For that setting, one could share apps and view data without having to worry about managing permissions to the data.

In the new CDS for Apps database, it uses role-based security model by default to secure access to the database and there is no concept similar to OPEN which everyone has access to. The Environment Maker role has no permissions to the database by default. The CDS User role can run an app in the environment and perform common tasks for the records they own (only for non-custom entities). One has to create or configure a custom security role to explicitly grant privileges to custom entities.

Deadlines and extension

If you intend to upgrade your previous version CDS database you must start the first step before March 15, 2019.

If you begin Step 1 of the upgrade before March 15, 2019 you can continue to complete the upgrade until the service is discontinued. We intend to continue the service until April 15, 2019.

If you do not begin Step 1 of the upgrade before March 15, 2019, we will disconnect your database and store your data for 30 days before deleting it. If you wish to reconnect a database, you must contact support before March 29, 2019.

If this data does not need to be preserved past the migration deadline, it’s safe to ignore the upgrade warnings and let the CDS instance get deleted automatically.

Once the database is migrated (or deleted automatically), Flow Approvals will work normally. When the first Approval request is sent on a tenant, a new CDS for Apps instance will be automatically provisioned in the Default Environment if one did not already exist.

Other resources

For more detailed information on how to upgrade a previous version of CDS instance, see the documentation here.

The post Remember to upgrade your previous version CDS database to preserve Flow Approvals history or entity data appeared first on Microsoft Power Platform Blog.

The shortcut for this blog for easy reference is https://aka.ms/pa/ignite2018.

Keynotes & General Session
	Vision Keynote Join us to kick off Microsoft Ignite & Microsoft Envision at the Vision Keynote, where Microsoft CEO Satya Nadella takes the stage and highlights the need of Tech Intensity and outline Microsoft’s company strategy to empower every person and every organization on the planet to achieve more.
	Powering digital transformation with business applications: Microsoft Dynamics 365, Power BI, PowerApps, and Microsoft Flow Businesses need software driven by data and powered by AI and cognitive services to help them fundamentally reimagine how they engage customers, empower employees, transform operations, and reimagine products and services. Join James Phillips and Alysa Taylor to hear how intelligent business applications from Microsoft work together seamlessly on a connected data platform threaded with intelligence and leverage the power of the complete Microsoft cloud. Be the first to see the October 2018 release of Dynamics 365 and the Power platform, including the use of AI, mixed reality, security, and compliance. Learn how to integrate new technology with existing systems to transform customer experiences with the flexibility to rapidly innovate.
	Microsoft PowerApps, Power BI, and Flow: Power platform vision and roadmap Turn insight into action when you build business apps with PowerApps, Microsoft Power BI, and Microsoft Flow. This session gives you an overview of the power platform and how you can empower everyone to build apps that transform your business. We cover what we have in market today along with our roadmap and vision for the future.
PowerApps Related Sessions
	PowerApps: The top 10 new features that will help you build apps with ease The way we build apps is fundamentally changing and PowerApps is leading the way. Hear from real customers including LEGO about how they are dramatically accelerating the way they build apps on a unified platform across Microsoft Office 365, Microsoft Dynamics 365, and standalone apps. Be the first to check out the top 10 latest capabilities that will help you go even faster pulling in your data, wherever it lives, leveraging over 200 connectors to cloud services, on-premises data, or even your custom-built connectors. The Common Data Service for Apps will make it even easier to bring it all together in a standard format through the extensible Common Data Model. All with the enterprise-grade security and manageability of PowerApps.
	PowerApps: Take your skills to the next level Take your PowerApps capabilities to the next level with the latest in server-side logic on the Common Data Service for Apps, advanced expressions in canvas apps, using Flow to return values to apps, and more. Get inspired by this tour-de-force of hands-on demos and handy tips you can use to build business apps that will wow your users.
	Common Data Service for Apps: Building enterprise-ready apps with ease This session will dive deep into the concepts needed to build applications on Common Data Service for Apps. Whether you leverage it for model-driven PowerApps solutions or in your custom built apps, we cover all the fundamentals like entity modelling, business rules, business processes, and include an introduction to extensibility options like Plugins, Virtual Entities, and more.
	PowerApps: Extending custom code with custom Azure Functions Microsoft PowerApps provides a robust set of capabilities to build your business applications. However, if you reach the limits of in-box capabilities, what do you do next? ?In this session, we explore how to extend PowerApps with custom code using Azure Functions.
	PowerApps: Build a full business?app in 10 minutes Join this fast-paced overview and hear how to use Microsoft PowerApps and the Common Data Service for Apps to create rich and comprehensive apps, leveraging a custom data model, forms, and tools to guide users through your business processes.
Microsoft Flow Related Sessions
	Microsoft Flow: Modernizing SharePoint Designer workflows with Microsoft Flow and approvals This session will take a deep dive into how you can modernize and enhance SharePoint Designer workflows with Microsoft Flow and approvals. We?ll take an up-close look at Microsoft Flow capabilities and how they map to SharePoint workflows, showcase real-life customer scenarios on Microsoft Flow, and discuss where the Flow + SharePoint integration is headed.
	Microsoft Flow: Digitally transform your business Microsoft is modernizing business processes across productivity and business applications ? and now it’s easier for every business to transform the way they work. Microsoft Flow is Microsoft?s workflow and business process management platform. It is the connective glue that helps end-users and developers alike for digital transformation, no matter what application they are using. In this session we cover this vision in detail, both in terms of what is available today, and a roadmap of what is coming in the future.
	Microsoft Flow and PowerApps: Advanced workflow and business process management Get a deep look into advanced techniques and expressions used to build complex and robust workflows with Microsoft Flow.?This intermediate session will cover a number of topics such as error handling, working with complex types and lists, and looping. Finally, discover how you can take it up to Azure Logic Apps when it makes sense.
	Design and automate business workflows using Excel, Microsoft Flow, and Visio Microsoft Visio, the leading diagramming application, enables enterprises to capture their business processes using its rich modelling capabilities. Create process diagrams from data or draw them on canvas and with a single click export the workflow to Microsoft Flow and automate it. With Visio?s sharing and commenting capabilities, collaborate with multiple stakeholders and arrive at a complete workflow in little time.
	Microsoft Flow: Build a workflow in 10 minutes See how we build a workflow in 10 minutes and take advantage of key capabilities of Microsoft Flow, including virtual buttons,?integration with Azure Cognitive Services, and more. Learn how you can build a solution in minutes that wouldn?t have been possible just a few years ago.
Sessions common to both PowerApps and Microsoft Flow
	PowerApps and Microsoft Flow: Best Practices for managing these two applications As your company’s adoption of PowerApps, Microsoft Flow and Common Data Service for Apps grows, so does your need?to protect your company’s data, control access and monitor usage. In this presentation targeted at central IT, departmental and team admins, learn best practices for managing PowerApps and Microsoft Flow in your organization.?Also discover our roadmap for administrative capabilities.
	Microsoft Flow and PowerApps: How pros extend the Power platform with custom logic, connectors, controls, and more PowerApps and Microsoft Flow make it possible to quickly customize Microsoft Office 365, Dynamics 365, and standalone apps without writing code ? but that doesn?t mean you?re limited to point and click. Learn how to go beyond the tooling to solve more sophisticated scenarios and empower citizen developers at every step of app development: build custom connectors to integrate directly with your own services; extend the server-side logic of the Common Data Service with code plugins, web hooks, and more; extend the user experience of model-driven apps with web resources and the new PowerApps Control Framework.
	Microsoft Power BI, Flow, and PowerApps: Connecting to data using the on-premises data gateway The on-premises data gateway enables hybrid connectivity to on-premises data sources from a wide range of Microsoft services, including Power BI, PowerApps, Logic Apps, Microsoft Flow, Azure Analysis Services and Power Query Online. In this session we will provide an overview of the on-premises data gateway and tips and tricks for how to effectively use, troubleshoot and manage your gateways. We will also show demos of recently released Gateway capabilities as well as a sneak preview of features coming over the next few months.
	Office 365 business apps (SharePoint, PowerApps, Flow, forms): What’s new and what’s coming No-code and low-code applications have been essential tools in Microsoft SharePoint for a long time, but we?ve added many other new tools to your palette. We review the roadmap and best practices in our platform for creating business apps solutions (lists, Microsoft PowerApps, forms, Microsoft Flow). We also discuss the patterns to help transform customer solutions that still remain on premises and/or in legacy tool sets like InfoPath, SharePoint Designer or Access web apps.
	Microsoft Common Data Model (CDM): An introductory session Join this session to learn about the Common Data Model (CDM). The CDM is an open-sourced definition of standard entities that represent commonly used concepts and activities across a variety of business and application domains. It provides unified data and semantics over a variety of entities spanning multiple industries including sales, service, and more. Data loaded into the common model can benefit from applications built on top of the platform without additional customization, including out-of-box insights and intelligent action. If needed, the CDM can be extended by partners and customers, ensuring custom entities and concepts can live and benefit alongside the standard schema. Join us for this intermediate, introductory session on the CDM to learn how.
	Microsoft Flow and PowerApps: Microsoft Power platform app in a day This day has it all, with two tracks running in parallel; from introductory to intermediate app building. The introductory track is an all-day hands-on lab that walks through: building a canvas-based PowerApp and a model-based PowerApp; creating and writing to a Common Data Service entity; and building a Microsoft Flow for approvals. In the intermediate/advanced track, a series of challenges are handed out that you can solve at your own pace. Proctors and product team experts guide the lab and are available to provide help.
Sessions from other teams at Microsoft
	No coding required: Build a mobile-ready news service with Microsoft PowerApps In this fast-paced session, we show you how our IT experts (and citizen developers too) built a simple, accessible, mobile-first news service that relays news, events, and important updates in a timely, streamlined manner to our worldwide field sellers. The news mobile app comes equipped with calendar integration, in-app feedback capability, and a search function too. This example showcases the ease and power of Microsoft PowerApps and how it allows for anyone?even those without coding experience?to create useful, impactful mobile apps easily.
	New ways to create ‘no code’ solutions with SharePoint This is a session for SharePoint ?makers?. We?ll walk through the creation process of making one full-fledged solution using SharePoint. This will be a deep dive, including tips and tricks for building composite applications and solutions based on SharePoint?s numerous no-code extensibility mechanisms and will include Flows, PowerApps, WebParts, list-view row formatters and more.
	Using Microsoft Flow to simplify employee collaboration at Microsoft Learn how Microsoft Core Services Engineering & Operations (CSEO)?the experts who run the critical products and services that power Microsoft?are using Microsoft Flow to automate daily employee meeting and calendar management tasks at Microsoft.
	Microsoft Dynamics 365 for Talent: Building your end-to-end experience by extending your solution Match the uniqueness of your people and company with a talent solution that can flex to fit. Join us to learn how Microsoft Dynamics 365 for Talent can extend from OOTB best-practice capabilities, to a tailored fit using low-code custom built applications with PowerApps and the Common Data Service.
PowerApps Sessions from the community and MVPs
	PowerApps: Building PowerApps from scratch? Use Patch! Microsoft PowerApps does provide the out-of-box flexibility to build your own View and Edit forms which directly connect to your SharePoint list. While most of the time using the existing form design can be sufficient, however, sometimes you have the need to customize the form design from scratch. Thanks to the Patch function you can do just that. This session walks you through several examples of how a custom form can be built and, based on the controls selected, which formula is used to save the data back to SharePoint.
	Best practices for using logic in your PowerApps Has your organization started embracing Microsoft PowerApps as the new standard for creating custom business forms and apps? PowerApps provides an easy interface that allows forms and apps to be customized for your requirements. When a solution demands advanced functionality, formulas can be utilized to conditionally hide or show fields, change colors, and perform a myriad of other dynamic tasks. In this session, learn how to get the most out of PowerApps, by mastering controls like Forms, Data Cards, and Galleries. By learning the properties, functions, and interactions of these controls, you will gain an understanding of the best way to customize your forms and apps to meet your business needs.
	Improve Firstline workforce collaboration with Office 365 Firstline workers?colleagues in manufacturing, retail, hospitality, and construction that are often mobile and first to engage with your customers?are critically important to an organization?s success. However, many of these employees can feel disconnected, underinformed, and disengaged from the rest of the company. Additionally, their productivity can be hampered by manually intensive and outdated tools from paper punch cards for clocking in to phone trees for trading shifts. In this interactive session, learn how you can deliver digital transformation solutions to your Firstline workforce by leveraging Office 365 technologies like Yammer, Microsoft Teams, Staffhub, and PowerApps.
	Real-world digital transformation case study: University of Oulu University of Oulu in Finland is creating innovation for the future, not only through science and study, but also by renewing its own internal processes. To start the digital transformation, they decided to take a few sample processes such as salary bonus requests, student presence tracking and student counseling services and try out how these processes can be transformed into modern digital counterparts using Microsoft Flow and PowerApps. Learn what went well, what didn?t work, the pitfalls to avoid and best practices to follow in order to renew processes for the modern workplace. Learn the limits and boundaries of Microsoft Flow and PowerApps and be prepared to excel in the digital transformation ahead.
	Creating iOT solutions with Microsoft Azure and PowerApps In this session we show how to use Azure to intake, process, analyze and store iOT data then visualize it in a PowerApp. Learn how to seamlessly combine the technologies to provide insights into data instantly.
	Canvas- vs. model-driven PowerApps When building your PowerApp, you have the choice of building a canvas app or a model-driven app. In this session, we cover rules of thumb to use when deciding between model-driven or canvas apps, when you should use each, and how they can work together.
	Step aside InfoPath Designer, here comes PowerApps Still not sure if Microsoft PowerApps and Flow are suitable successors for InfoPath Designer and SharePoint Designer? Then attend this session to see how an advanced InfoPath Designer form and SharePoint Designer workflow has not only been rebuilt but enhanced using PowerApps and Flow. In addition, see how PowerApps has made it easier than ever to leverage data from other platforms.
	Moving from InfoPath to PowerApps: Introduction to terminology For 13 years, InfoPath has been Microsoft’s official method of creating business forms in SharePoint. Now that InfoPath has been phased out, PowerApps is the new way of creating no-code forms. In this session, Laura Rogers introduces how to create PowerApps, and specifically how to translate your common InfoPath form terminology into the new way in PowerApps.
	Be a no-code rock star: Do your SharePoint web parts and Microsoft Teams tabs with PowerApps Through demos, this session gives you a solid understanding of how to build SharePoint web parts and Microsoft Teams tabs to meet your organization’s various needs. Learn the easy steps to design your Microsoft PowerApps web part or tab, or mobile application, to follow company branding guidelines. Build a nice feedback app that works on mobile, in SharePoint as a web part, or in Teams as a tab. After the session you’ll be in a much better position to answer questions like ?Can this-and-this be done with PowerApps?? or ?We need an Idea Vault web part to our SharePoint intranet front page. Is it going to be expensive?? Even if you are familiar with PowerApps, you’ll learn great tips you can go and utilize after the session.
Microsoft Flow Sessions from the community and MVPs
	Level up the day-to-day business with Microsoft Flow Microsoft Flow is a service for automating workflow across the growing number of apps and SaaS services business users rely on that connect to data and work cross platform, and it?s sitting at the heart of the business process transformation in the modern workplace. Microsoft is investing enormously into Flow, making it the first inline tool for digital transformation and modernizing workplaces. Flow now has seamless integration and connectivity with the other stack of tools and services, whether they are from Microsoft or not, making it a vital tool for customizing and digitizing your modern workplace. Explore modern business applications using Microsoft Flow along with practical demos, the latest announcements, and updates.
	Microsoft Flow: Energize your application developments by using Microsoft Flow Microsoft Flow can be seen as a tool for power users but it can also be used by developers. This session illustrates how Flow is becoming an essential tool for developers by allowing them to shorten their development lifecycle and how they can extend existing applications in order to leverage tons of new features that Flow provides out of the box. See how to extend Flow by using the Microsoft Graph and by calling Azure functions, by creating custom connectors, how to implement advanced Flow approvals from your application, JSON and Flow, the new Common Data Services 2.0 integration, how to optimize your flow performance, how to make services flow and much more. Several patterns are also described.
	Microsoft Azure Logic Apps vs. Microsoft Flow: When, how, and where Logic Apps is an Azure cloud-based service that enables us to develop and deliver integration solutions with ease. It also helps us build, schedule, and automate processes as workflows so we can integrate apps, data, systems, and services across enterprises or organizations. However, Microsoft Flow is a SaaS offering, for automating workflows across the growing number of applications and SaaS services that business users rely on. We will help you chose the right product given that Flow was built using Logic Apps itself. We will illustrate the similarities between Logic Apps and Flow, and define the differences on the Whens, Hows and Wheres.
	Quick wins are the new currency in Microsoft 365 By focusing on solving small problems that affect all users, you will not only save time and money, but more importantly, change negative users into positive evangelists. In this session Tracy and Loryan provide examples on how to use Microsoft Flow together with Teams, Planner, OneNote, OneDrive, SharePoint, Forms, Kaizala, and Outlook to truly realize business value. Scenarios covered include: ? Bringing communication methods together ? Managing your contacts, leads, and ideas ? Automating mundane tasks to save lots of time Once you understand how all the apps and services can work together to help you reach your full potential, you will wonder how you ever managed before.
Other Sessions from the community and MVPs
	New out-of-box approvals in SharePoint Do your business users need a way to easily run approval processes for documents or forms in SharePoint? Microsoft Flow presents a great opportunity to modernize and increase the capabilities of your automated business processes. The requirements of your workflows may range from simple to complex, and they all vary when it comes to flexibility and functionality. In this session, learn the capabilities of Microsoft Flow and how to successfully build your next process automation in SharePoint. Learn how to transition from workflows with SharePoint 2010 out-of-box workflows or SharePoint Designer task actions, to the new way with Microsoft Flow.
	From start to finish: How to create your modern SharePoint site provisioning solution Creating modern SharePoint sites only takes a second but what if you want to customize or control that process? It can be a challenge to keep up with all the sites in an organization and can affect support and governance of a SharePoint environment. In this session, learn how to use Microsoft?s latest tools such as Site Designs, Site Scripts, PnP Site Provisioning, PowerApps and Flow to create a full site provisioning system with custom templates, custom branding, and easy approval before creation!
	Modern business apps: There are none without Microsoft SharePoint, PowerApps and Flow Digital transformation is a necessity rather than a facility, and it’s a result of changing the culture of work by making things easier and simpler. Office 365, including SharePoint Online provides digital tools that enable people in organizations to do their best work easily and efficiently, empowering teamwork and collaboration! Join Ahmad Najjar to see how you can leverage Microsoft Flow and PowerApps with powerful capabilities in SharePoint Online to level up your day-to-day work. Learn about creating automated workflows between a variety of Office 365 apps and services to get notifications, collect data, approvals, and more!
	Enhancing SharePoint content management using Microsoft Flow The SharePoint Document ID service is great for adding a unique, trackable references to content. Engineers, information architects, knowledge managers, and process authors love metadata and often have a requirement for a specific structured naming convention. This session demonstrates how Microsoft Flow can be used to create an automatic document numbering system that applies a structured convention. In the session, learn how to combine managed metadata with user generated terms using switch cases, expressions and actions. Learn how to deal with trigger idiosyncrasies and simple error handling. You might not need an automatic numbering service but the principles you learn can be applied in other scenarios.
	Creating custom connectors for Microsoft Graph and using them in PowerApps and Flows In this session we show how existing Microsoft PowerApps and Microsoft Flow connectors use the Microsoft Graph and how to create your own. Learn how to make your own custom connector to access the Microsoft Graph from PowerApps and Flows.

The post Microsoft Ignite 2018 Event Recap – PowerApps & Microsoft Flow sessions appeared first on Microsoft Power Platform Blog.

Pre-Day Workshop content – Microsoft Flow and PowerApps: Microsoft Power platform app in a day

Earlier this weekend, on 23rd Sept 2018, we ran a Pre-Day Power platform workshop at the Ignite event in Orlando. During this workshop, we provided attendees with an à la carte menu of options to choose from a range of introductory to intermediate labs and challenges. The workshop was attended by more than 150 attendees and we got a lot of encouraging feedback from the attendees:

• “I was skeptical of having multiple ‘levels’  in the same session, but it worked out very well. Thanks!”
• “opened up a huge world of possibilities.”
• “This session was best of show so far for me. I learned a ton of info.”

We want to share the content out broadly and encourage everyone to reuse the content from the workshop for conducting workshops and trainings internally within your organization, community & user groups.

Download Link: https://aka.ms/PowerPlatformChallenges

If you haven’t done the App-in-a-Day lab yet, we recommend you to start with it first, which has been updated just before the Ignite event and an additional Power BI module has been added.

Power Platform Labs and Challenges

The Labs and Challenges are packaged in a PowerApp (canvas app) that contains links to several Labs and Challenges to learn more about the Power Platform, which includes PowerApps, Power BI, Microsoft Flow & Common Data Service for Apps.

There are two types of contents linked from in the app, Labs & Challenges.

Labs: Each Lab contains step-by-step guidance with screenshots for users to follow along

Challenges: Each challenge describes a specific task to complete or problem to solve. Users won’t be provided detailed instructions for how to solve the problem, however most challenges have Solution Hints and / or links to important blogs, documentation articles or videos.

The content is structured in the following 6 scenarios:

Hands-on-Labs

• App in a Day Lab
• Dashboard in a Day Lab
• Flow in a Day Lab

Challenges

• Conference App Challenge
• Photo App Challenge
• SharePoint Challenges

Installing Instructions

Task 1: Download the Lab Files – https://aka.ms/PowerPlatformChallenges

1. Save a local copy of the lab contents: Download the ChallengesApp.zip file for the lab from https://aka.ms/PowerPlatformChallenges. Save it to a local folder, such as C:\PowerPlatformChallenges. Extract the ZIP package. This package contains a PowerApp file (MSAPP file), an Excel file – ChallengesAppData.xlsx (which contains the static data used in this app) & soft copy of this document.
   Note: The data required for the app is already included in the app, you might need to use the ChallengesAppData.xlsx only to customize the labs & challenges that you want to share with your audience.

Task 2: Sign-in to PowerApps

1. Confirm that you are licensed to use PowerApps: Go to https://web.powerapps.com and sign-in with your business or school account. This is the same as your Office 365 or Dynamics 365 login.

Task 3: Open the PowerApps app

1. Open PowerApps Studio: When logged in on https://web.powerapps.com, click on Apps. Then click on Create an app. PowerApps Studio (https://create.powerapps.com) will open up in a new Tab. See screenshot below.

1. Open PowerApps : Click on Open on the left navigation. Then click on Browse. Select the Challenges App.msapp file from the folder where you unzipped the contents of the zip file.

Content – Hands-on-Labs

App in a Day Lab

The App in a Day Lab is a beginner level lab for you to get hands on experience with Microsoft Business Application Platform technologies – PowerApps, Microsoft Flow, Power BI and Common Data Service for Apps. The lab includes step-by-step instructions for someone new to these technologies to build a device ordering solution in less than a day. If you haven’t done the App-in-a-Day lab yet, we recommend you to start with it first, which has been updated just before the Ignite event and an additional Power BI module has been added.

Technologies covered:

• PowerApps: A software as a service application platform that enables power users in line of business roles to easily build and deploy custom business apps. There are dedicated modules to both canvas and Model-driven apps.
• Common Data Service (CDS): Make it easier to bring your data together and quickly create powerful apps using a compliant and scalable data service and app platform that’s integrated into PowerApps.
• Microsoft Flow: A business service for line of business specialists and IT pros to build automated workflows intuitively.
• Power BI (new): Self-service business intelligence capabilities, where end users can create reports and dashboards by themselves, without having to depend on information technology staff or database administrators.

Make sure to follow all the pre-requisite steps listed in Module 0 before starting the labs.

Additional Challenges in the App in a Day Lab scenario

In addition to the 5 modules for App in a Day, this scenario also contains a PowerApps Training app which use a PowerApps canvas app to train on various PowerApps canvas apps concepts and several other challenges that are related to the Device Ordering App. Feel free to check them out.

Dashboard in a Day Lab

The Dashboard in a Day Lab is a beginner level lab for you to get hands on experience with Power BI. The lab has two main sections:

• Power BI Desktop: This section highlights the features available in Power BI Desktop and walks the user through the process of bringing in data from the data source, modeling and creating visualizations.
• Power BI Service: This section highlights the features available in Power BI Service including the ability to publish the Power BI Desktop model to the web, creating and sharing dashboard and Power Q & A.

Flow in a Day Lab

The Flow in a Day Lab is a beginner level lab for you to get hands on experience with Microsoft Flow. The lab has 6 Labs & 5 Hackathon themes. The Labs contain step-by-step guidance for 6 different scenarios and the themes are like challenges which contain links to blogs or videos – but are not detailed out like the labs.

• Lab 1. Building a time tracking flow
• Lab 2. Approvals (Part 1) – Travel Approval
• Lab 3. Flow Notifications and Conditions
• Lab 4. Flow control, variables, expressions
• Lab 5. Dynamically add a person’s manager as an approver (Approval Part 2)
• Lab 6. Task overdue

Additional Challenges in the Flow in a Day Lab scenario

In addition to the 5 modules for App in a Day, this scenario also contains several other Flow challenges. Feel free to check them out.

Content-Challenges

SharePoint Challenges

This scenario contains 10 challenges for SharePoint & Microsoft Flow & 5 challenges for SharePoint & PowerApps, which includes integration scenarios between PowerApps, Microsoft Flow & SharePoint.

Photo App Challenge

The Photo app challenge revolves around a fictitious Photo Central app.

The Scenario The marketing managers at Contoso Inc. want a single location to manage image assets for marketing campaigns. They’ve created an app called “Photo Central” to store these images that can be uploaded and managed by members of the marketing team.

Conference App Challenge

The Conference app challenge revolves creating a Conference app to be used by employees for attending an internal conference. All the data for the app is to be stored in Common Data Service. Each of the challenge in the scenario involves the various steps that have to be done for building the app.

Content – Slide decks

The zip file also contains a “PowerPlatformPreDaySlides.zip” file containing a couple of slide decks that were presented during the Pre-Day Workshop. You may choose to reuse them for any internal workshops or trainings that you conduct.

• PRE26_PowerPlatform_AppInADay.pptx : Presentation to walk through the agenda of the day and introduce the various lab and challenges options.

• Power Platform Intro – Ignite 2018 Pre-Day.pptx: An introduction to the technologies that constitutes the Power Platform – PowerApps, Microsoft Flow, Power BI

The post Power Platform Labs and Challenges appeared first on Microsoft Power Platform Blog.

There were also several amazing customer sessions including the session by London Heathrow Airport which was showcased in the Inspire 2018 corenote by Satya. Also available now are the October 2018 release notes, which details hundreds of new capabilities and features across all our Dynamics 365 applications and the Power Platform, which includes PowerApps, Microsoft Flow & Power BI.

The shortcut for this blog for easy reference is https://aka.ms/pa/mbas2018.

The post Microsoft Business Applications Summit 2018 – Event recap appeared first on Microsoft Power Platform Blog.

We have many more sessions lined up for you at the Microsoft Business Applications Summit from July 22-24 in Seattle. So register today, if you haven’t registered already.

The shortcut for this blog is https://aka.ms/pa/build2018. There is also a playlist: Building with PowerApps and Microsoft Flow, if you prefer to view these on the Microsoft Build Live site.

Navigate quickly to individual sessions below:

• PowerApps related sessions
• Advanced app building with PowerApps expressions and rules
• PowerApps + Microsoft Graph
• Real-World Solutions with PowerApps: Performance and optimization tips when building apps
• Real-World Solutions with PowerApps: Tips & tricks to manage your app complexity
• Real-World Solutions with PowerApps: Building Composite Controls
• Common Data Service for Apps related sessions
• Deep dive into building apps on Common Data Service for Apps
• Extending PowerApps and the Common Data Service for Apps with custom controls and server side logic
• Distribute your apps to millions of users via AppSource
• Microsoft Flow related sessions
• Automating business processes and approvals with Microsoft Flow
• Build a workflow in 10 minutes
• PowerApps & Microsoft Flow related sessions
• Build and extend applications for Office 365 with PowerApps and Flow
• Developing custom connectors for Microsoft Flow and PowerApps
• PowerApps ALM via Microsoft Flow & PowerShell
• Accelerate your SaaS App development using the power of the Business Application Platform

PowerApps related sessions

Advanced app building with PowerApps expressions and rules

Join us to learn how you can leverage advanced expressions and new enhancements for PowerApps canvas based apps that improve readability of expressions, enable deep customization and provide tools to build apps more quickly.

Channel 9 URL for session

Download deck for the session

Back to Top

PowerApps + Microsoft Graph

Learn how to quickly build custom business apps leveraging Microsoft Graph inside the PowerApps studio.

Channel 9 URL for session

Download deck for the session

Back to Top

Real-World Solutions with PowerApps: Performance and optimization tips when building apps

Learn approaches and best practices from real apps built with PowerApps. In this session we will go over data loading patterns, asset optimizations, formula optimizations, and more.

Channel 9 URL for session

Download deck for the Session

Back to Top

Real-World Solutions with PowerApps: Tips & tricks to manage your app complexity

Learn approaches and best practices from real apps built with PowerApps. We’ll look into a set of best practices to ensure your app is maintainable, extensible and easy to debug.

Channel 9 URL for session

Download deck for this Session

Back to Top

Real-World Solutions with PowerApps: Building Composite Controls

Learn approaches and best practices from real apps built with PowerApps. In this session we will review how to build composite controls for PowerApps, such as Accordion, Flyout menu, and Tab control, using basic built-in controls.

Channel 9 URL for session

Download deck for the session

Back to Top

Common Data Service for Apps related sessions

Deep dive into building apps on Common Data Service for Apps

In this session, we’ll deep dive into the concepts needed to build applications on CDS for Apps, whether you leverage it PowerApps or in your custom built solutions. We’ll cover all the fundamentals like entity modelling, business rules, business processes, and include an introduction to extensibility options like Plugins, Virtual Entities, and more.

Channel 9 URL for session

Download deck for the session

Back to Top

Extending PowerApps and the Common Data Service for Apps with custom controls and server side logic

Professional developer extensibility is a key capability to the Business Application Platform. We’ll focus on enriching model-driven PowerApps solutions with server-side code and custom controls on the Common Data Service for Apps. We’ll utilize the developer toolkit and write code for native plugin development, use of functions and logic apps, Web API, Administration API, and the Virtual Entity subsystem.

Channel 9 URL for session

Back to Top

Distribute your apps to millions of users via AppSource

Learn how to package apps and custom extensions for PowerApps and distribute them via AppSource within your organization or to over 120M monthly active users across Office 365 and Dynamics 365. Ready your custom solutions for everyone to leverage.

Channel 9 URL for session

Back to Top

Microsoft Flow related sessions

Automating business processes and approvals with Microsoft Flow

Use Microsoft Flow to easily add business process automation and approval processes to your solutions. You’ll learn to build Flows with a few simple clicks and extend your learnings to more advanced techniques and expressions used to build complex workflows. Finally discover how you can take it up to Azure Logic Apps when it makes sense.

Channel 9 URL for session

Download deck for the session

Back to Top

Build a workflow in 10 minutes

Channel 9 URL for session

Download deck for the session

Back to Top

PowerApps & Microsoft Flow related sessions

Build and extend applications for Office 365 with PowerApps and Flow

Come discover the capabilities of PowerApps and Flow as the unified high productivity application development and workflow platform across Office 365 and Dynamics 365. As the successor to InfoPath and Access Web Apps, PowerApps enables users to build both simple forms to advanced, feature-rich apps, while Flow as the successor to SharePoint Designer Workflow, enables users to build automated workflows for a range of scenarios from notifications to approvals. In this session, we’ll cover integrations with SharePoint, Dynamics 365, Microsoft Teams, Microsoft Graph, Excel, and more. Start extending and building apps and workflows for Office 365 and Dynamics 365 today!

Channel 9 URL for session

Download deck for the session

Back to Top

Developing custom connectors for Microsoft Flow and PowerApps

PowerApps already provides over 200 connectors -to Microsoft as well as to 3d party services- for app makers to use and combine into their apps. Learn how you can build custom connectors and make them available to app makers around the world.

Channel 9 URL for session

Download deck for the session

Back to Top

PowerApps ALM via Microsoft Flow & PowerShell

Learn approaches and best practices from real apps built with PowerApps. Learn how to managing apps in large organizations using PowerShell and Microsoft Flow.

Channel 9 URL for session

Download deck for the session

Back to Top

Accelerate your SaaS App development using the power of the Business Application Platform

Join this session to learn how the Business Application Platform can accelerate the time to market for your next Line of Business SaaS app. Through the lens of an ISV/software developer, we will walk you through the entire application development process showcasing what it takes to build a new, composite app from the ground up using out of the box no-code/no-code tooling, to extending with custom code and connectors through to packaging and publishing to AppSource allowing you to reach 120M+ monthly active users. During this session we will also touch upon the value of the Common Data Ser
vice for Apps as it applies specifically to you as an ISV, how you can extend and contribute to the ISV ecosystem flywheel and greatly reduce both cost and time to market for new SaaS apps.

Channel 9 URL for session

Download deck for the session

Back to Top

The post Build 2018 Event Recap – Business Application Platform appeared first on Microsoft Power Platform Blog.

There is an out-of-the-box Computer Vision API connector, however the API uses dynamic types, which are not supported in PowerApps yet. There is also an out-of-the-box Face API connector, however it isn’t much useful in enterprise scenarios yet, as it’s an API Key based connector and when a PowerApps app created using this connector is shared with other users, each user has to bring in their own API keys for using the app.

About this blog

In the approach described in this blog, the cognitive services APIs are called from an Azure API App, using the client libraries which are just a C# client wrapper for the APIs. We shall be using the Microsoft.ProjectOxford.Face and Microsoft.ProjectOxford.Vision Nuget packages in our API app. I have shared the complete source code for the API App for download as well as the PowerApps app file to use & test the APIs as well. I have also combined the code for uploading an image to Azure Blob storage in this new API app – ImageUtilities, so that one can use all these functions together in an app if needed.

First we shall create the necessary Azure Services (App Service, Blob Storage, Computer Vision API & Face API), then publish the API App to Azure.

Then, we shall register a new custom connector in PowerApps using the swagger definition from the API App. 

Finally, we shall create the PowerApps app using this new custom connector.

In PowerApps, when a maker shares an app created using a custom connector, the connector is automatically shared and hence other users can use the app (without needing to type in an API key). In the blog below, we shall also protect our API app endpoint with AAD and also register an app in Azure AD for the custom connector, so that other users can use their own AAD credentials to authenticate and get access to the APIs.

Let’s get started.

Here are the steps :

1. Create the API App project
2. Publish the API to Azure
3. Protect with the API with Azure AD authentication (optional but highly recommended)
4. Register another app in Azure AD for the custom connector (optional but highly recommended)
5. Register a new custom connector in PowerApps
6. Create a PowerApps App to use the connector
7. Save, Publish and Test the App

Create the API App project

I have chosen to use an API App for the custom connector versus Azure Functions primarily as API apps can generate the Swagger document for use with PowerApps using the Swashbuckle Nuget package. This auto generates the definitions for all the reference classes like AnalysisResult and others used by the APIs in the swagger document. Since I have used the Swashbuckle feature to include XML Comments from my assembly to generate Summary and Description tags in swagger, it becomes quite handy for both the API registration and also for providing intelli-sense when authoring the functions from the PowerApps app.

You will need the following Azure Services setup before you can complete this step:

• Azure Subscription (you can setup your free azure account with a $200 credit to use in any Azure product for 30 days)
• Azure Blob Storage
• Create blob storage container named “images” to store the Images that you may upload
• Create a Computer Vision API service and obtain subscription keys (It is free to signup). Note down the subscription key and the address of the endpoint – for e.g. : https://westus.api.cognitive.microsoft.com/vision/v1.0/
• Create a Face API service and obtain subscription keys (It is free to signup). Note down the subscription key and the address of the endpoint – for e.g. : https://westus.api.cognitive.microsoft.com/face/v1.0/

Download the code for the API App from this location: https://aka.ms/ImageUtilitiesCode 

If you haven’t created an API App for use with PowerApps, I recommend reading this tutorial to familiarize with the basic concepts. I have used Visual Studio 2017 for the code used in this app.  Extract the contents of the zip file and open the ImageUtilities.sln file to launch the project in Visual Studio.  We have added the following Controllers to correspond to the respective APIs from Azure Cognitive Services. The list of APIs for reference is given below:

• AnalyzeController –> Analyze Image
• DescribeController –> Describe Image
• HandwrittenTextController –> Recognize Handwritten Text
• OCRController –> OCR
• ImageTagsController –> Tag Image
• ThumbnailController –> Get Thumbnail 

Open the Web.config file and modify the highlighted values in the Web.Config file with corresponding values from your Azure services.

For the StorageConnectionString – use the format DefaultEndpointsProtocol=https;AccountName=myAccount;AccountKey=myKey;

Use the API keys for the Computer Vision and Face APIs that you had noted down earlier. Also populate the root end points for both the services as well.

  <appSettings>
    <!--<add key="StorageConnectionString" value="UseDevelopmentStorage=true" />-->
    <add key="StorageConnectionString" value="DummyValue" />
    <add key="VisionAPIKey" value="DummyValue" />
    <add key="FaceAPIKey" value="DummyValue" />
    <add key="VisionAPIRoot" value="https://westus.api.cognitive.microsoft.com/vision/v1.0"/>
    <add key="FaceAPIRoot" value="https://westus.api.cognitive.microsoft.com/face/v1.0"/>
  </appSettings>

Compile & test the APIs locally using the SwaggerUI (CTRL + F5 and navigating to http://localhost:64279/swagger).

Publish the API to Azure

Once satisfied, publish the app to Azure. Refer to this article for a good tutorial for Publishing to Azure with Visual Studio.  Test your API end point by browsing to https://<yoursitename>.azurewebsites.net/swagger/.

Download the swagger document. Browse to the Swagger URL mentioned in the Swagger UI of your API (https://<yoursitename>.azurewebsites.net/swagger/docs/v1) in IE and download the json file onto your disk and name it ImageUtilitiesSwaggerv1.json

Protect the API with Azure AD Authentication

Follow the steps mentioned in this article to secure your API with Azure Active Directory. If your Azure Subscription is in a different directory than your organizational Azure AD (like I had), follow the steps mentioned in the Alternative Method but make sure that you do the app registration in your organization’s Active Directory (Tip: you can open the AAD specific https://aad.portal.azure.com portal in another browser tab or window).  I have registered my app as ImageUtilitiesAPI in my active directory.

Register another app in Azure AD for the PowerApps custom connector

We now need to register a second application in AAD for the PowerApps connector. This is required to secure the PowerApps custom connector with AAD so that other users within the organization can use their own AAD credentials to authenticate against the connector for the app.  I have registered this app as ImageUtilities_PAConnector in my Azure Active Directory.

The second AAD application is used to secure the custom connector registration and acquire delegated access to the ImageUtilitiesAPI app protected by the first application. Name this one ImageUtilities_PAConnector.

• Sign-on URL: https://login.windows.net
• Reply URL: https://msmanaged-na.consent.azure-apim.net/redirect
• Add permissions to have delegated access to ImageUtilitiesAPI.
• You need the application ID of this application later as well, so note it.
• Generate a client key and store is somewhere safe. We need this key later.

Register a new Custom Connector in PowerApps

Browse to the PowerApps portal, and add a custom connector as described in this article: Register and use custom connectors. Note down the Environment name where you are creating the Custom connector.

Once you have uploaded the OpenAPI (Swagger) file, the wizard auto-detects that you are using the AAD authentication for your web API.  (If you are curious how, we have already added a security definitions in the SwaggerConfig file itself, using the c.OAuth2(“oauth2”) method)

Configure the AAD authentication for the custom connector.

• Client ID: Client ID of ImageUtilities_PAConnector
• Secret: Client key of ImageUtilities_PAConnector
• Login URL: https://login.windows.net
• ResourceUri: Application ID of ImageUtilitiesAPI

You should be able to see all the actions and References imported from the swagger file in the Definition section as per screenshot below.

Click Create Connector to create the custom connector.

Create a PowerApps App to use the custom connector

Open the PowerApps Portal.  Make sure that you have the same Environment selected as the one in which you created the Custom connector in the previous step.

Click on Apps from the left nav bar. 

Download the PowerApps app resources from this location: https://aka.ms/CognitiveServicesPowerAppsDemo.  Right click the downloaded zip file (on windows) and select Properties to unblock the contents by checking the Unblock checkbox, before extracting the contents of the zip file.

Then click on Create an App from the top right. This will navigate you to the PowerApps web authoring site. Click on Open from the left nav, then click on Browse.

Then select the CognitiveDemos.msapp file that you extracted from the downloaded zip file. This will load the PowerApps app in edit mode.

Click on View > DataSources

Click on + Add data source

Click on + New connection, and select the ImageUtilitiesAPI (custom connector that you created earlier). Authenticate using your AAD credentials to add it to your application.  In case you are wondering the other two connections already present in the app, they are static data files imported from Excel. The source of the file is shared along with the PowerApps app file AppData.xlsx.

Save, Publish and Test the app

Click on File > Save > The cloud (Save to PowerApps) > Provide a unique name to your app and click on Save. For every subsequent saves, you will have to Publish your app. 

Let’s run the app in Preview mode to test the app by click on F5 or the Preview the app button.  There are 6 options to choose for the API that you want to call and 4 choices for selecting an image.

Select Analyze Image & Select from sample Image. This will display a gallery of sample images below for you to select. Select any one from the Gallery and click on Next to display the results.

There are a lot of hidden nuggets in the app for you to discover and enjoy! Share the app with your colleagues by click on the Share button. 

Please share your comments in the section below for any feedback.

The post Cognitive Services with PowerApps using Custom Connectors appeared first on Microsoft Power Platform Blog.

There have been a lot of requests from the community about the ability to display a map in PowerApps. While we don’t yet have a Maps Control in PowerApps, we can use the Image Control to display maps – thankfully to Bing Maps OR Google Maps via the Bing Maps Imagery API & Google Static Maps API respectively.

Map scenarios

Here are the scenarios that we will build today using the Image Control:

1. Display a map for a given named location or address
2. Display a map for the current GPS location of the device
3. Zoom In / Zoom Out using a Slider
4. Navigate to the Maps app or Web Page when clicked

Preparation

Get the Bing Maps API Key by visiting this URL OR the Google Static Maps API Key by visiting this URL. Note down the Key for use later in the tutorial.

In the PowerApps Studio or Web, Create a New Blank app (pick either Phone or Tablet layout as per your need).

Add a Configuration Screen

We’ll first create a Configuration Screen to store some information which can be used by other screens in the app. Rename the Screen1 to ConfigurationScreen from the Tree view on the left side.

Insert a Text input control from the Insert Tab > Text > Text input

Rename the control from TextInput1 to txtBingMapsKey (If you want to use the Bing Maps API) or txtGoogleMapsKey (if you want to use Google Maps API). Change HintText to “Enter Maps Key here” and the Default to the ACTUAL KEY value from the Bing Maps or the Google Maps site from the first step of this tutorial.

Insert another Text input control from the Insert tab > Text > Text input. Rename this control to txtImageWidth, change Hint Text to “Enter Maps Image Width here”, change Default to “600” (if phone layout) or “1200” (if tablet layout), change Format to Number from the Properties pane on the right.

Copy the txtImageWidth (CTRL + C) and Paste (CTRL + V) in the same screen to create a copy. Rename the control to txtImageHeight, change the Hint Text to “Enter Maps Image Height here”, change Default to “300” (for phone layout) and “600” (for tablet layout).

Add the Main Screen

Insert > New Screen > Blank layout.
Rename the Screen2 to MainScreen.
Move the MainScreen Up by clicking on the Move Up icon in the context menu

Insert > Media > Image control to add a new Image to the screen.

Rename the control from Image1 to imgMapControl. Set the Width to txtImageWidth and Height to txtImageHeight.

Scenario 1: Display a map for a given named location or address

Let’s insert a Text input control to enter the location or address for the map: Insert Tab > Text > Text input. Rename the control to txtLocation. Move it to a location in the screen where appropriate.

Change Hint Text as “Enter a location or address” and keep Default as an empty string “” or your favorite location – for e.g. Times Square, New York, Seattle etc…

For rendering the Map, use the following formula in the Image property of the imgMapControl :

For Bing Maps Use:

"https://dev.virtualearth.net/REST/V1/Imagery/Map/Road/" & EncodeUrl(txtLocation.Text) & "?mapSize=" & txtImageWidth & "," & txtImageHeight & "&key="&txtBingMapsKey.Text

Bing Maps: Refer to the Get a Static Map article for examples and other parameters.

For Google Maps Use:

"https://maps.googleapis.com/maps/api/staticmap?center=" & EncodeUrl(txtLocation.Text) & "&size=" & txtImageWidth & "x" & txtImageHeight & "&key="&txtGoogleMapsKey.Text

Google Maps: Refer to examples and parameters in the Google Static Maps Developer Guide.

Here are the screenshots for the Location: Space Needle, Seattle using Bing Maps:

And here is the same location using Google Maps (note the size is restricted to 640×640 in Google Maps, as I am using a Free version of the API):

Playing with some of the options

Changing ImagerySets (Bing Maps) and Map Types (Google Maps):

Bing Maps supports multiple imagerySets. Lets add a dropdown to see the effect of changing these imagerySets.

Insert > Controls > Dropdown to add a dropdown. Rename the control to drpBingImagerySets. Set the Items property to the following:

["Road","Aerial", "AerialWithLabels", "AerialWithLabelsOnDemand", "CanvasDark", "CanvasLight", "CanvasGray"]

Change the formula in the Image property of the imgMapControl to include the imagerySet option :

"https://dev.virtualearth.net/REST/V1/Imagery/Map/" & drpBingImagerySets.Selected.Value & "/" & EncodeUrl(txtLocation.Text) & "?mapSize=" & txtImageWidth & "," & txtImageHeight & "&key="&txtBingMapsKey.Text

Google Maps supports four types of maptypes. Lets add a dropdown to see the effect of changing these types.

Insert > Controls > Dropdown to add a dropdown. Rename the control to drpGoogleMaptypes. Set the Items property to the following:

["roadmap","terrain", "satellite", "hybrid"]

Change the formula in the Image property of the imgMapControl to include the maptype option :

"https://maps.googleapis.com/maps/api/staticmap?center=" & EncodeUrl(txtLocation.Text) & "&&size=" & txtImageWidth & "x" & txtImageHeight & "&maptype=" & drpGoogleMaptypes.Selected.Value & "&key="&txtGoogleMapsKey.Text

These Map APIs are pretty powerful and I am sure, you will be tempted to try out other options available for customization. For now let’s move on to the next scenario:

Scenario 2: Display a map for the current GPS location of the device

PowerApps provides native access to Device Signals such as Location (GPS), Acceleration, Compass, etc. Let’s use the Location signal to show the current location on a map.

For that, we shall use the same txtLocation Text input to display the GPS coordinates if we select a Toggle to use GPS Location.

Insert > Controls > Toggle to insert a Toggle control on the screen. Rename it to tglGPSLocation.

Insert > Label to insert a Label control on the screen. Move it next to the Toggle and rename it to lblGPSLocation. Change the Text to “Use GPS Location:”.

Change the Default of the txtLocation Input text to this formula:

If(tglGPSLocation.Value, Location.Latitude & ","& Location.Longitude ,"")

For Bing Maps, change the formula in the Image property of the imgMapControl to include the centerpoint & pushpin options (Note we have to add the zoomLevel as well):

"https://dev.virtualearth.net/REST/V1/Imagery/Map/"&drpBingImagerySets.Selected.Value&"/" & EncodeUrl(txtLocation.Text) & "/15?mapSize=" & txtImageWidth & "," & txtImageHeight & "&pp=" & txtLocation.Text & ";21;I+am+here&key="&txtBingMapsKey.Text

For Google Maps, change the formula in the Image property of the imgMapControl to include the center & markers options (Note we have to add the zoomLevel as well):

"https://maps.googleapis.com/maps/api/staticmap?center=" & EncodeUrl(txtLocation.Text) & "&zoom=15&size=" & txtImageWidth & "x" & txtImageHeight & "&maptype=" & drpGoogleMaptypes.Selected.Value & "&markers=color:blue%7Clabel:M%7C"& EncodeUrl(txtLocation.Text)& "&key="&txtGoogleMapsKey.Text

Scenario 3: Zoom In / Zoom Out using a Slider

Moving the final scenario, lets add a Slider control to control the Zoom level. Insert > Controls > Slider. Rename the Slider1 to slZoom. Change Default to 15, Min to 1 & Max to 21.

Add a Label next to the slider to denote the zoom level. Insert > Label. Rename the Label to lbZoom. Change Text to : “Zoom (1-21):”.

For Bing Maps, change the formula in the Image property of the imgMapControl to include the  zoomLevel from the slider.

"https://dev.virtualearth.net/REST/V1/Imagery/Map/"&drpBingImagerySets.Selected.Value&"/" & EncodeUrl(txtLocation.Text) & "/"& slZoom.Value &"?mapSize=" & txtImageWidth & "," & txtImageHeight & "&pp=" & txtLocation.Text & ";21;I+am+here&key="&txtBingMapsKey.Text

For Google Maps, change the formula in the Image property of the imgMapControl to include the  zoomLevel from the slider.

"https://maps.googleapis.com/maps/api/staticmap?center=" & EncodeUrl(txtLocation.Text) & "&zoom="& slZoom.Value & "&size=" & txtImageWidth & "x" & txtImageHeight & "&maptype=" & drpGoogleMaptypes.Selected.Value & "&markers=color:blue%7Clabel:M%7C"& EncodeUrl(txtLocation.Text)& "&key="&txtGoogleMapsKey.Text

Scenario 4: Navigate to the Maps app or Web Page when clicked

Lastly, lets add the navigation step when clicked on the image to open up the respective web page or app.

For Bing Maps,  add the following Formula in the OnSelect for the imgMapControl:

If(tglGPSLocation.Value, Launch("bingmaps:?cp=" & EncodeUrl(Substitute(txtLocation.Text,",","~"))&"&lvl="&slZoom.Value), Launch("bingmaps:?q=" & EncodeUrl(txtLocation.Text)&"&lvl="&slZoom.Value))

Refer to this article for details: https://docs.microsoft.com/en-us/windows/uwp/launch-resume/launch-maps-app

For Google Maps, add the following Formula in the OnSelect for the imgMapControl:

Launch("http://maps.google.com/?q="&EncodeUrl(txtLocation.Text))

Refer to this article for details: https://developers.google.com/maps/documentation/urls/guide

Download the Sample App

Download the Sample App from here. Rename the downloaded zip file to SampleMapsApp.msapp and open using PowerApps Studio. Enjoy !

The post Displaying a Map using an Image Control in PowerApps and Bing Maps or Google Maps API appeared first on Microsoft Power Platform Blog.

Thanks Tsuyoshi, on behalf of the PowerApps team!

———————————————————————————————-

The custom api enables you to connect your own web api (REST api) in Microsoft Flow (including SharePoint workflow) and PowerApps. You can connect Microsoft Flow and PowerApps with your in-house applications or unknown 3rd party (ISV) applications.

In this post I show you how to build and use the custom api, and in most cases the authentication is needed, then I also explain with real authentication scenario. (First I explain using Azure AD, and next I show you the other cases, such as Google account.)

Build your own web api

In the first example, we use the Azure Active Directory (Azure AD)  as the authentication provider with custom api.
In this case, your web api must handle the OAuth access token.

I don’t describe how to build the web api secured by the Azure AD, but if you’re using ASP.NET Web API, you just click [Change Authentication] button in the project creation wizard and set-up the Azure AD information. (See the following screen.)

If you’re using other programming language, see “How to build API secured by Azure AD” (Japanese) in my previous post.

Note : You can also use the Azure App Service (API App) and [Authentication / Authorization] settings (so called “Easy Auth”) for every programming languages.
See “Authentication and authorization in Azure App Service” for details.

Next you must prepare the swagger specification file (json file).
If you use ASP.NET Web API, you can insert “Swashbuckle” Nuget package and download this json by accessing http://{your root URL}/swagger/docs/v1.

The next is one of the swagger specification example. Especially, you must remember operationId value (the following “Values_Get”), because we use this operation in the PowerApps later.

In the swagger specification, you must add the following “securityDefinitions” section, and set Azure AD authentication information as follows.

{
  "swagger": "2.0",
  "info": {
    "version": "v1",
    "title": "TestApi01"
  },
  "host": "demo.azurewebsites.net",
  "schemes": [
    "https"
  ],
  "paths": {
    "/api/Values/{id}": {
      "get": {
        "tags": [
          "Values"
        ],
        "operationId": "Values_Get",
        "consumes": [
        ],
        "produces": [
          "applicationhttps://www.microsoft.com/json",
          "texthttps://www.microsoft.com/json",
          "application/xml",
          "text/xml"
        ],
        "parameters": [
          {
            "name": "id",
            "in": "path",
            "required": true,
            "type": "integer",
            "format": "int32"
          }
        ],
        "responses": {
          "200": {
            "description": "OK",
            "schema": {
              "type": "string"
            }
          }
        }
      },
      . . .
    }
  },
  "definitions": {
  },
  "securityDefinitions": {
    "oauth2": {
      "type": "oauth2",
      "flow": "implicit",
      "authorizationUrl": "https://login.windows.net/common/oauth2/authorize",
      "scopes": {
      }
    }
  }
}

If you use Swashbuckle in your ASP.NET Web API project, you just insert the following code (bold font) in App_Start\SwaggerConfig.cs.

public class SwaggerConfig
{
  public static void Register()
  {
    var thisAssembly = typeof(SwaggerConfig).Assembly;
    GlobalConfiguration.Configuration
      .EnableSwagger(c =>
        {
          c.SingleApiVersion("v1", "TestApi01");
          . . .
          c.OAuth2("oauth2")
            .AuthorizationUrl("https://login.windows.net/common/oauth2/authorize")
            .Flow("implicit")
            .Scopes(scopes =>
            {
              //scopes.Add("xxxxx", "Some access to protected resources");
            });
        })
      .EnableSwaggerUi(c =>
        {
          . . .
        });
  }
}

Register APIs in Azure AD

In the case of Azure AD, the custom api proxy in the Microsoft Flow or PowerApps retrieves the access token for your web api resource, and calls your web api by setting this token in the http header.
i.e, you must register both the custom api proxy app and your web api app in the Azure AD, and set the permission between custom api proxy and your web api.

Note : If you have used the previous [Change Authentication] button in ASP.NET Web API, the web api app is already registered in Azure AD.

The following illustrates this.

When you register the custom api proxy (Azure AD app of Microsoft Flow or PowerApps side), you must add the following url (fixed value) as the redirect url. Both Microsoft Flow and PowerApps uses this redirect url, when processing OAuth.

https://msmanaged-na.consent.azure-apim.net/redirect

Currently (in Nov 2016), the Azure AD v2 endpoint is not supported (but v1 only) for this scenario, and you must use the Azure Classic Portal (https://manage.windowsazure.com/), not Azure Ibiza Portal (https://portal.azure.com).
And you must set the custom api proxy’s permissions for accessing your web api in the Azure Classic Portal. (You cannot set this permission and cannot see the resource id in the Ibiza portal today.)

See the following screenshot.

Note : Strictly speaking, v2.0 endpoint (Azure AD v2 endpoint) is supported in the custom api. But, this proxy and web api flow (see the illustration above) is not supported for v2.0 endpoint.
Please refer the next Google scenario (flow) for the v2.0 endpoint.

How to work (or use) in PowerApps

Now you’re ready to use the custom api in Microsoft Flow and PowerApps. Here I show you the step of setting PowerApps.

Note : For the details of this procedure, please refer the official document “Register Custom APIs in PowerApps“.

First you login to PowerApps (https://web.powerapps.com/), and select [Connections] in the navigation, and click [New connection].

Select [Custom] tab and click [New custom API].

In the next window, upload the swagger specification file (json) previously created.

The swagger specification is parsed and the identity provider is auto-detected by the PowerApps.
You must set some api information in the next window like the following screenshot. Note that this client id and secret is for the previous custom api proxy, not your web api. The Resource URL (the accessing scopes) is the ID/URI of your web api, not the custom api proxy.

The connection settings of the custom api has done. Next you start to create the app in the PowerApps.

Click [New App] button, and select [Phone layout] in the [Blank app].

In the design window, select [Content] – [Data sources] menu.

The data source window is displayed in the right pane, and click [Add data source] button, and [New connection] button.
You can find the previously created custom api, and select (connect) that.

Then the Azure AD sign-in UI is displayed, and you must enter your credential.

The custom api is inserted as the data source.

Let’s test this custom api !

Please insert the button control into your app, and input the following expression as the button “OnSelect” function (fx).
This is calling the “ValuesGet” method (see the previous “operationId” in the swagger file) in the custom api named “TestApi01”, and setting the string result in the context variable named “ResultValue”.

UpdateContext( { ResultValue : TestApi01.ValuesGet(3) } )

Note : You can use auto-correct or suggestions when you’re writing functions.

Next you insert the text box, and set “ResultValue” (the context variable previously created) in the text box function.

Push run button, and this app is launched in the web browser.
When you push the button in the app, your web api is called by the PowerApps and the returned value is displayed in the text box.

In the backend, the following http request is called against your web api.
Then your web api can verify the token (the following “Authorization” header value) and retrieve the claims. Please see  “Protect a Web API using Bearer tokens from Azure AD” for this programming when you’re using ASP.NET Web API..

GET /api/Values/3
Accept: */*
Authorization: Bearer eyJ0eXAiOi...
Origin: https://us.create.powerapps.com
X-Ms-Apim-Tokens: ew0KICAidG...

HTTP/1.1 200 OK
Content-Type: applicationhttps://www.microsoft.com/json; charset=utf-8
"you entered 3"

Note : The “X-Ms-Apim-Tokens” header is also important, and I explain this later. (In the case of Azure AD, there’s no need to use this token.)

This token (“Authorization” header value) is the Azure AD access token itself. Then you can also get the access token for another resources in your web api by calling the following OAuth on_behalf_of flow.
That is, your web api can collaborate another Azure AD resources like Office 365 API, Azure ARM REST, Power BI REST, etc.

POST https://login.microsoftonline.com/common/oauth2/token
Content-Type: application/x-www-form-urlencoded
grant_type=urn%3Aietf%3Aparams%3Aoauth%3Agrant-type%3Ajwt-bearer&assertion={received access token}&requested_token_use=on_behalf_of&resource={resource id that your api wants to access}&scope=openid&client_id={client id of your web api}&client_secret={client secret of your web api}

You can share your app to other people in the same organization.
The sign-in for this custom api, i.e, Azure AD sign-in is needed, when the user launch this app for the first time.  (see the following screenshot)

Other Providers (the case of Google)

You can also use the OAuth 2.0 of Google, Facebook, Salesforce and other SaaS applications including the generic OAuth 2.0 providers. (see the official document “Register Custom APIs in Microsoft Flow“. The flow by API Key and Basic Authentication are also supported.)

Let’s see the case of Google account.

Google and most providers are not having api registration, only client registration. (Except for the app context like api key.)
Therefore, you register only the custom api proxy as OAuth client into Google Developer Console, get access token for pre-defined Google scopes only (profile, email, etc), and pass this token to your web api. (Or you could use the api key instead.)

Next is the swagger example for Google account settings. (see the bold font)

{
  "swagger": "2.0",
  "info": {
    "version": "v1",
    "title": "TestApi01"
  },
  "host": "demo.azurewebsites.net",
  "schemes": [
    "https"
  ],
  "paths": {
    "/api/Values/{id}": {
      "get": {
        "tags": [
          "Values"
        ],
        "operationId": "Values_Get",
        "consumes": [
        ],
        "produces": [
          "applicationhttps://www.microsoft.com/json",
          "texthttps://www.microsoft.com/json",
          "application/xml",
          "text/xml"
        ],
        "parameters": [
          {
            "name": "id",
            "in": "path",
            "required": true,
            "type": "integer",
            "format": "int32"
          }
        ],
        "responses": {
          "200": {
            "description": "OK",
            "schema": {
              "type": "string"
            }
          }
        }
      },
      . . .
    }
  },
  "definitions": {
  },
  "securityDefinitions": {
    "oauth2": {
      "type": "oauth2",
      "flow": "accessCode",
      "authorizationUrl": "https://accounts.google.com/o/oauth2/auth",
      "tokenUrl": "https://www.googleapis.com/oauth2/v4/token",
      "scopes": {
      }
    }
  }
}

PowerApps (or Microsoft Flow) automatically detects Google account, and when you connect to the custom api, the Google account login is displayed as the following screenshot.

Next is the http request for your web api.
It is the same like Azure AD, but not. The “Authorization” header value is the access token for Google scopes, not for your web api.

GET /api/Values/3
Accept: */*
Authorization: Bearer ya29.Ci-aAy...
Origin: https://us.create.powerapps.com
X-Ms-Apim-Tokens: ew0KICAidG...

Therefore you cannot verify this access token in your web api, but you can verify the login user instead of using X-Ms-Apim-Tokens. This token (X-Ms-Apim-Tokens) is the Base64 Url encoded value (see RFC 4648) of the following json string, and as you can see, the value includes the refresh token and id token of Google account. As a result, you can decode the id token value, and retrieve the user claims, verify the digital signature.

{
  "token": {
    "AccessToken": "ya29.Ci-aAy...",
    "ExpiresIn": "3600",
    "IdToken": "eyJhbGciOi...",
    "RefreshToken": "1/udVjULwb...",
    "TokenType": "Bearer",
    "OAuth2TokenEndPointCredentialLocation": "Body",
    "ExpiresOn": "636150505441694110",
    "LoginSettingId": "msmanaged-na_customapidemo02.5f989...",
    "TokenAcquireTime": "11/18/2016 6:22:24 AM"
  },
  "sku": "Enterprise",
  "$connectionCreator": {
    "objectId": "cf258756-2623-47cb-be46-c85d436265bb",
    "tenantId": "3c839350-a414-442a-9585-8db0b0f5f300",
    "userPrincipalName": "tsmatsuz@o365directory.onmicrosoft.com"
  },
  "$ConnectionKey": "Key eyJ0eXAiOi...",
  "$callerIdentity": {
    "objectid": "cf258756-2623-47cb-be46-c85d436265bb",
    "prinicipaltype": "ActiveDirectory",
    "tenantid": "3c839350-a414-442a-9585-8db0b0f5f300",
    "email": "tsmatsuz@o365directory.onmicrosoft.com"
  }
}

If your web api doesn’t need the login user, you could use the api key instead.

———————————————————————————————-

The post Guest Blog: Build Custom API on Microsoft Flow and PowerApps with Authentication appeared first on Microsoft Power Platform Blog.