Tuesday 9:00 AM - 12:30 PM · Room 613:614

SharePoint Data Modeling: From Requirements to Usage

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.

Wednesday 11:30 AM - 12:40 PM · Room 602:603

How to Avoid AI Disasters: Copilot, Data Security, and Unintended Consequences

Say your company rushes in the coming months to implement a Copilot over their Intranet. An employee asks the Copilot, "How much does my co-worker make?" How will it answer?

This scenario becomes plausible as Copilot is connected to data sources for Q&A activities. If the data related to pay, layoffs, and other sensitive topics is accessible by the AI, it's possible that an employee could get an answer to their question. You should take great care before connecting it to your own internal data.

Unfortunately hearing GPT, AI and Machine Learning terms thrown about like doubloons at a Mardi Gras parade in the news is giving many organizations FOMO. We'll discuss what you should know before you jump in.

In this session, we'll address:

• What are these technologies and how they will impact you
• How can these technologies be used in your organization
• Data and security considerations
• Preparing for unintended consequences

Join us to learn about this brave new world and how you could apply it in your own work.

Wednesday 11:30 AM - 12:40 PM · Room 606

React for the SharePoint Developer

For years client-side development in SharePoint was accomplished with jQuery and JavaScript. In the last year the development landscape has changed.

With the introduction of the SharePoint Framework, SharePoint developers were introduced to new ways of developing. With this new paradigm we need to refresh our skills.

React is a library that integrates really well with SharePoint, whether you are currently using the SharePoint Framework or you are prepping your code for the future.

Wednesday 11:30 AM - 12:40 PM · Room 607

Improve your users' productivity with custom Viva Connections cards

Adaptive Card Extensions are a new way to create custom components that can render dynamic and interactive content in SharePoint pages, news, and lists.

In this session, you will learn how to use the SharePoint Framework to create and deploy Adaptive Card Extensions, and how to use them as part of dashboards.

You will also learn how to leverage Viva Connections, a new solution that brings your SharePoint intranet to Microsoft Teams, to enhance the reach and impact of your Adaptive Card Extensions.

You will see how Viva Connections can help you create a unified and personalized employee experience that boosts engagement, productivity, and wellbeing.

Wednesday 11:30 AM - 12:40 PM · Room 608

Bye, Bye Microsoft Syntex, Hello SharePoint Premium!

At the Microsoft Ignite event in November 2023, Microsoft made the official announcement of transitioning Syntex to SharePoint Premium.

Join Joanne Klein and Daniel Christian, Microsoft MVPs as they walk you through the new SharePoint Premium and all the features that come along with it that can help improve the experience, process and governance of all the content that resides in your SharePoint sites.

Wednesday 1:50 PM - 3:00 PM · Room 606

Introduction to JSON to master customizing SharePoint

JSON is EVERYWHERE in SharePoint Online and your ability to take your SharePoint deployments to the next level depend on your ability to understand and create complicated JSON objects.

In this densely demo-packed session, attendees will learn:

• What is JSON and how to understand the structure
• Tips for creating JSON objects and starting with community content as a starting point

Attendees will also learn how to use JSON Objects in SharePoint Online to:

• Customize list columns and list views
• Create Site Designs for creating custom site templates
• Create stunning Quick Views for Viva Connections ACE's
• Post messages in teams as Adaptive Cards
• Process SharePoint REST queries in Power Automate
• and more!!

Wednesday 3:40 PM - 4:50 PM · Room 604

Understanding and Applying AOP to Increase Solution Development Velocity

Despite having been around for the better part of two decades, most developers building compiled .NET and SharePoint solutions (including full-trust SharePoint customization and provider-hosted add-ins, or PHAs) aren’t familiar with Aspect-Oriented Programming, or AOP.

The goal of this session is to introduce developers to AOP, what it is, how it works, and the tools that enable the use of AOP in .NET, JavaScript, and other solution development. We’ll work through a number of code samples that illustrate how AOP greatly simplifies the process of architecting and addressing cross-cutting development concerns like logging, security, exception handling, and more.

If you’re looking for ways to streamline development and reduce boilerplate code in your solutions, this is the session to attend.

Wednesday 3:40 PM - 4:50 PM · Room 606

Building Location Directory using PnP Search Web Part

For many global organizations, keeping track of the different office and department locations can be challenging. I

In this session, you will see how we solved this real-world challenge using out of the box SharePoint components and customizations through the PnP Modern Search Web Parts.

You will leave with an understanding of how to leverage custom Content Types, Lists, and custom templates for the PnP Modern Search Web Parts to create a dynamic directory of locations for your organization.

Thursday 10:30 AM - 11:40 AM · Room 606

Code Once Use Everywhere - Using SPFx to create applications that work in Teams and SharePoint

Users are spending more and more time using Teams. It makes sense to try and reduce the friction of context switching by bringing our custom applications directly into Teams where they are working. We are able to harness the collaborative nature of Teams and SharePoint in one application and render it in many different contexts.

In this introductory developer session we will look at how to create and deploy a SharePoint Framework WebPart and have it be usable in Teams. We will use one code base to make the web part Teams aware in both a Teams Tab and a Personal App. We will look at how to use that app to read and write data into SharePoint using PnPjs.

Users will leave with an understanding of how to leverage SPFx to create applications they can use in Teams and resources on how to explore this further.

Thursday 2:00 PM - 3:10 PM · Room 606

Expanding SharePoint Framework Web Parts in Teams, Office and Outlook

SharePoint Framework is not just a SharePoint development framework as it could seem from the name.

It allows to develop solutions that are available in Teams, Outlook and office.com.

Join me during this session to learn how to easily implement SPFx web part and expose it in all available hosts.

Thursday 3:50 PM - 5:00 PM · Room 612

Automate content processing using AI & SharePoint Premium (Microsoft Syntex)

We'll learn how to use SharePoint Premium (previously known as Microsoft Syntex) that uses advanced AI and machine teaching to amplify human expertise, automate content processing, and transform content into knowledge.

Friday 9:00 AM - 10:10 AM · Room 602:603

Building Engaging Employee Experiences for Viva Connections using SPFx

In this introductory developer session, we will explore ways to develop engaging employee experiences using the extensibility model for Viva Connections. We will learn how to create Adaptive Card Extensions using SPFx. We will talk about some real world use cases and how to get started.

We will explore the technical components of creating your first Adaptive Card Extensions. We will look at more advanced concepts such as geolocation, data binding, as well as layout out options for your cards using the Adaptive Card Framework. You will walk away with a better understanding of how to get started extending Viva Connections and how to avoid some common pitfalls.

Friday 10:20 AM - 11:30 AM · Room 602:603

Get Your Hands Dirty with React.

Maybe you have started with React and what to learn how to apply it in your projects. In this session we will continue your progression with React. We will create reusable components and create an application that users will want to use.

This session will have very few slides but we will take an HTML page that was generated and create a simple application out of it.

Friday 12:30 PM - 1:40 PM · Room 602:603

Viva Connections: Create Bot-powered Adaptive Card Extensions

Adaptive Card Extensions (ACEs) are a SharePoint Framework component type, which enables developers to build rich, native extensions to Viva Connections' Dashboards and SharePoint Pages.

Usually, ACEs are developed using SPFx and front-end development. But what if you have existing service that powers Microsoft Teams bots or Task modules that you want to reuse in ACEs?

During this session we will discuss how to use Bots and Universal Actions Model to create Adaptive Card Extensions for Viva Connections.

Friday 12:30 PM - 1:40 PM · Room 608

Building Copilot experiences in SharePoint Embedded applications

SharePoint Embedded is the fastest way for developers to build Copilot experiences in their applications. Learn how you can build a Copilot-enabled SharePoint Embedded application in minutes, and how you can bring your app's content and experiences to Microsoft Copilot with custom Copilot Plugins.

Friday 1:50 PM - 3:00 PM · Room 602:603

How to Execute JavaScript, TypeScript, and Excel Formulas In Power Automate

Power Automate has become an essential tool for the Microsoft 365 developer. However, all too often executing simple logic can become tedious and painful using Power Automate standard features. Doing math in Power Automate shouldn't be so painful!

Thankfully, Power Automate developers can now create scripts that use JavaScript, TypeScript, or even Excel formulas to execute complicated business logic and bring more power to your Power Automate solutions. Attend this demo-packed session to learn out to take your Power Automate Flows to the next level as we dive into a real-world scenario and build a practical solution step-by-step.

In this session, attendees will learn to use Office Scripts to:

• Execute JavaScript, TypeScript, and Excel Formulas
• Simplify complicated Flows
• How to quickly and easily generate dynamic adaptive cards
• Generate graphs and charts on the fly for real-time updates to SharePoint data

Friday 1:50 PM - 3:00 PM · Room 607

Nailing Down Performance Issues in SharePoint Online Sites (2024 Edition)

SharePoint Online (SPO) has been with us for over a decade, and in that time it has received numerous changes and adjustments intended to optimize performance. Despite the work that has gone into the platform, some organization still find users reporting a poor experience and "bad performance."

In this session, we will look at development and design approaches that will enable SPO to deliver optimal performance when your organization begins using it. We'll review the current state of tooling available for our use (like the Page Diagnostics for SharePoint tool) and how it can be used to guide analysis of performance issues. We will also look at elements in any environment that can negatively impact SPO performance to make it look like the "bad guy" when SPO is actually innocent.

At the conclusion of this session, participants will have the confidence needed to troubleshoot, classify, and possibly resolve performance-based issues in their SPO tenant.