Tuesday 9:00 AM - 12:30 PM · Room 435-436

Use the SharePoint Framework to develop apps & customize SharePoint & Viva Connections

Andrew Connell

Become an expert developer in the Microsoft 365 ecosystem!

The SharePoint Framework (SPFx) is Microsoft's recommended way to customize and extend your SharePoint site and Viva Connections.

Whether you're an experienced SharePoint developer or new to the platform, this half-day workshop is perfect for you. You'll learn how to set up your development workstation for SPFx and discover how to create web parts, UX extensions, and Adaptive Card Extensions (ACEs) for Viva Connections. We'll also cover working with SharePoint lists, libraries, and Microsoft Graph data.

By the end of the workshop, you'll understand the full range of possibilities for your next SharePoint customization project. And if you're using SharePoint Server on-premises (2016, 2019, or Subscription Edition) rather than SharePoint Online? Don't worry—we'll cover what's possible in each version!

Feel free to sit back and learn or bring your laptop to build your own SPFx solutions. Everyone will walk away with all the resources used and created throughout the workshop!

Tuesday 9:00 AM - 12:30 PM · Room 440-442

SharePoint Data Modeling: From Requirements to Usage

Paul Papanek Stork

Don't Pa..Panic Consulting, Owner

Data modeling is an essential first step in any Power Apps or Power Automate project. Power apps provides a user interface for information stored in a data source and Power Automate creates workflows that manipulate data stored in a data source based on specific events or triggers. Data modeling is difficult enough for professional developers, but it is even harder for citizen developers. Citizen developers usually have little exposure to concepts like data normalization and often can’t use true relational databases like SQL or Dataverse because of the cost of Premium licensing. So, they are left trying to figure out how to build their flows or apps using data stored in SharePoint lists or Excel spreadsheets. In this workshop I will show you some real-world techniques for doing data modeling. I’ll start with a typical project requirements definition and show you how to easily convert it into an Entity Relationship model. Next, I’ll show you how to map that Entity Relationship model onto a set of SharePoint lists. Once I have the lists designed, I’ll show you how to use them in a Power App and a flow. Along the way I’ll walk you through what you need to know about using SharePoint as a data source, including: • What Column types work well and which ones to avoid • When to use (or not use) Lookup columns to create relationships between lists • How to plan for Security in SharePoint • Other Common issues I’ll focus on SharePoint in the workshop but the techniques I teach you are also applicable for other data sources like Excel, SQL or even Dataverse.