SPO + Power Apps = Better Together SharePoint Data and Power Apps: Better Together Aroh Shukla, MVP. – Technical Consultant , Insight Singapore 

Thank You to our Global SQLSaturday Sponsors 

Thank You to our Local SQLSaturday Sponsors 

About Aroh Technical Consultant, Microsoft MVP, MCT & Nintex vTE Experience: Office 365, SharePoint Online, Data Platform Office 365 Consultant & Power Platform Trainer LinkedIn: https://www.linkedin.com/in/arohshukla/ Blog: aarohblah.blogspot.com @aaroh_bits Aroh Shukla 

AGENDA SLIDE SPO + Power Apps = BETTER Together DEMOS SPO + Power Platform +Teams How these services give better user experience . SPO + Power Platform How SPO fits into Power Platform . Why Power Platform All services of Power Platform . SharePoint Online Innovations Why, What & How. 

Transforming your business is challenging 

SharePoint Online Roadmap 

No content

SharePoint Sites Roadmap Recently Released End of 2020 Site Experiences SharePoint home sites Site navigation - extended site footer, Hubs – hub permissions, hub analytics More ways to upgrade classic sites into modern sites Content Management System Audience targeting for navigation Multilingual pages and news Site analytics updates – download to Excel, hub analytics, Tenant-wide Office templates hosted in SP Org Asset Libraries Pages, Web Parts and News Page authoring updates – default page templates, Stock images, more drag and drop authoring Web parts – save for later web part SharePoint News - auto news digest Even More Microsoft Fluent design Performance improvements and diagnostic tools Site performance page for owners and editors Page diagnostic tool for SharePoint - multilingual support SharePoint spaces preview and 360° virtual tours App Source store support for SharePoint Framework solutions Site Experiences SharePoint app bar with global navigation Site templates Site header updates - extended & minimal headers, additional config Associated hubs Content Management System Audience targeting for quick links and events web parts Scheduling for pages and news Multilingual navigation editing Pages, Web Parts and News Page authoring – first run experience for authors, collapsible sections Web parts - org chart web part, my feed web part SharePoint News - Boost for corporate communicators, news page analytics, faster news loading in SharePoint mobile, company branded news digest Even More SharePoint spaces GA, touch support, transparent image and video support PowerShell portal launch scheduler Improved ‘Teamify’ experience Q1 2021 SharePoint Home site app in Teams SharePoint spaces web part 

SharePoint sites, files, news, lists, pages, apps & spaces 

Turbocharged SharePoint file storage Fast, phenomenal and fluid faster downloads performance file types faster indexing 

Empower line of business Build modern business apps—fast Enable developers to extend Sites Pages Lists and libraries Web parts Microsoft Forms Conditional formatting Automate using Power Automate Connected web parts Power BI Power Apps Adaptive cards List formatters Microsoft Graph SharePoint Framework Azure AI + Machine Learning Azure Containers Azure Bot Framework Dataverse (formerly knows as CDS ) Compose analytics, user experiences, and automation using an integrated set of services from Microsoft. Power users best understand their business needs, and can now build solutions quickly without writing code. Professional developers can now easily extend capabilities for power users and take advantage of rich platform services with the full ​power of Azure. Flexible solutions for everyone Authors Pro developers Solutionists Low-code developers 

How Does Dataverse Fits with Power Platform 

No content

Microsoft Teams 

No content

Data + Microsoft Teams Microsoft Dataverse for Teams = Empowers users to build custom apps, bots, and flows 

Dataverse for Teams Built-in low code data platform within Microsoft Teams SUBSET of capabilities (Dynamics 365 + Power Platform) Built-in common data storage for Teams Rich data types with enterprise capabilities. 1 click deployment 

Built on core of Dataverse SQLSaturday#893 – Singapore Dataverse delivers relational database, image & file data support 2 GB per Teams, up to 1 M rows Data shared across multiple apps, flows & chatbots Can be promoted to full CDS if required 

Microsoft Dataverse for Teams - Tech Specs • Each Microsoft Dataverse for Teams environment has 1:1 to Teams team • Up to 500 Teams • 2 GB for each Team with 1 M rows • Teams Governs who can create & use the apps • General Available 

Dataverse for Teams vs SharePoint Queries Dataverse with Teams Is your Microsoft 365 license sufficient? Can you use standard connectors? Can you access the outside Teams? In FAQs Out of the box OR Additional confirmation needed? ? SharePoint Online Can you build table relationships? 

Scenario (SPO + Power Apps) B u s i n e s s c a s e Only with Mobile Phone Ordering will only through mobile phone. Business case Users can easily order food delivery service at the comfort of their home due to COVID-19 Data Source SharePoint Online Custom List . 

Demo -Integrate SharePoint Online with Power Apps -Data source - SharePoint Online List) -Integrate Power Apps within Teams - Data Source – Dataverse) 

Evaluation bit.ly/evalaroh 

Thank you