Unveiling The Secrets Of Data Modelling With SharePoint, Power Apps & Power Automate

Watch this SharePoint Data Modelling Masterclass today and set the stage for your mastery in the Power Platform. Your projects deserve it. You deserve it.

Suitable For

Power Users

Duration

3 Hours Recording

Format

Workshop

Presenter

Paul Stork MVP

What you'll learn:

  • Surface data models properly in Power Apps with techniques to avoid common delegation errors and failed dropdowns.
  • Configure flows to interact efficiently with your SharePoint data model using best practices for large datasets.
  • Apply real-world techniques like caching and filtering to address common data issues like slow load times in flows and apps.
  • Translate app requirements into structured data models by identifying data types and creating foundational entities.
  • Mirror data models in SharePoint lists using the right column types like lookups and calculations to match your model.
  • Link SharePoint lists together to create relationships between data entities and approximate a relational database.
Purchase this training only:
Get immediate access to this training content with a one-off purchase.
$197.00 USD
Or
Subscribe to all of the training in the Collab365 Academy:
Get this training plus over 450 hours of training and access to the Collab365 Academy. Learn More.

Agenda:

Working From Requirements

  • How to take a common real world example of a set of application requirements and turn them into data entities
  • Understanding what types of data you are working with and how you should treat each
  • How to create your first Data model that you can build upon as a solid foundation for an App or a Flow.
  • How To Avoid Common Pitfalls in Power Apps

  • How to surface your data model in the right way
  • How your app interacts with your data
  • What techniques can you use to avoid common issues like delegation and failed drop down controls
  • How SharePoint Can Hold a Data Model

  • Using the right kind of column at the right time
  • How to mirror your data model entities in SharePoint lists
  • How to link lists to mirror relationships in your model
  • Real World Techniques to Surface Data In Flows

  • How your flows can interact with your model
  • How to address common flow related problems relating to how your data model is configured
  • Where, when and why you might reach for more sophisticated solutions like the Dataverse and SQL
  • This training includes:

    • 3 hours of training
    • Access to the Collab365 Academy
    • Workshop Resources
    • Watch on Desktop or Mobile

    100% Satisfaction guaranteed

    100% Guaranteed

    We're thrilled to have you explore our content! Like many of our happy customers, we're sure you'll find great value in what we offer. If, for any reason, you're not completely satisfied with a stand-alone purchase, please reach out within 30 days. We're more than happy to process a refund for you.

    As for our Platinum Plan, we invite you to take advantage of our Collab365 Academy with a full-access, 7-day trial. It's a wonderful opportunity to experience all that we have to offer. Please note, due to the nature of this comprehensive trial, we are unable to provide refunds for plan purchases.

    Thoughts from the Collab365 Team:

    When Connor does his live shows and talks about the solutions he builds, he often says that he thinks about data first. This isn't just a step in our BLUE (Build it, Learn it, Use it, enhance it) model. It's a practice that stood him and the other Collab365 coaches in good stead for the past years.

    "Building a solid foundation and laying your data out well for me is a practice that anyone starting out in the Power Platform should learn.

    I see it like building a house. If I don't think where my rooms need to be placed, the flow of traffic between each location, how each room needs to be accessed from other rooms, I'll end up with a mess of a floor plan and a house that's ultimately hard to live in.

    Knocking walls down and moving doors after its all put up and furnished is a waste of time and money. It's why I always begin thinking about the core data (my room plan) and the relationships between the entities (what rooms I need and where the doorways from room to room need to be).

    Description:

    SharePoint Presents An Enormous World – A Complex One.

    Structuring and modeling data might seem daunting, but without it, you're setting yourself up for pitfalls, especially when working with the Power Platform.

    This workshop isn’t just a step; it’s the foundation for virtually every Power Platform you build.

    If you've defined your requirements but are staring blankly at screens, trying to understand how to model data in SharePoint, you're not alone…

    We've had countless Collab365 members and professionals reach out to us, searching for a blueprint on SharePoint Data Modelling. We listened, and we've prepared this Masterclass to guide you.

    Now, you might be thinking…

    "Why The Buzz? I've Used SharePoint Before."

    Well, think of this: efficient Data Modelling in SharePoint is like the blueprint for a skyscraper. Without it, you're building on shaky ground.

    That's where the SharePoint Data Modelling Masterclass comes in - your comprehensive guide to mastering data in SharePoint.

    What's The SharePoint Data Modelling Masterclass?

    It's not just a Masterclass. It's your Power Platform toolkit, your strategy guide, your playbook. Dive deep into 3 hours of comprehensive, actionable content that covers EVERYTHING you need to know about data modelling in SharePoint.

    And the most exciting part? Your guide is none other than Paul Stork, a ten-time Microsoft MVP. With a career spanning three decades, Paul isn’t just a SharePoint expert; he's a seasoned trainer, known for simplifying complex concepts. He’s the go-to for all things SharePoint, and now he’s here to guide you.

    Meet your workshop host:

    Paul Stork MVP

    Paul Stork MVP

    Paul has spoken at many of our Collab365 events and is a fantastic speaker and the Owner/Principal Architect at Don't Pa..Panic Consulting.

    He has worked in the information technology industry for over 30 years and has been awarded the Microsoft Most Valuable Professional (MVP) award for the last ten consecutive years. In addition, he's authored several books and frequently contributed to the Microsoft forums.

    Frequently Asked questions:

    Can I get an invoice?

    As soon as you purchase your pass you will be emailed a receipt. If you'd also like a formal invoice, please send your request to hello@collab365.com.

    Can I get refund?

    We're thrilled to have you explore our content! Like many of our happy customers, we're sure you'll find great value in what we offer. If, for any reason, you're not completely satisfied with a stand-alone purchase, please reach out within 30 days. We're more than happy to process a refund for you.

    As for our Platinum Plan, we invite you to take advantage of our Collab365 Academy with a full-access, 7-day trial. It's a wonderful opportunity to experience all that we have to offer. Please note, due to the nature of this comprehensive trial, we are unable to provide refunds for plan purchases.

    Can I buy a team or multi-user pass?

    Absolutely, we also offer discounts for multiple purchases. To sign-up for a Teams Pass, please visit our Platinum Plan page.

    Can I share the videos and ebooks?

    No, only the person who purchases the pass will be able to watch the videos and will receive the ebooks. We ask that you do not share them.

    Who do I contact if there's a problem?

    Send us an email at hello@collab365.com and we can help. 

    Can I cancel my subscription?

    Of course. The trial lasts for 7-Days and you can cancel anytime before that. If you choose to continue as a paid platinum member you can also cancel at any time.

    How do I get my certifications?

    If the training you purchase also includes a certification, then as soon as you complete, we will automatically email you so you can redeem your badge on Credly. Good luck!

    What is included in the Platinum Plan?

    The Platinum Plan offers a comprehensive suite of resources tailored for Microsoft 365 learners:

    • Complete access to our current library of over 200 hours of detailed Microsoft 365 training and 108 Ebooks.
    • A rich selection of over 30 half-day workshops covering essential Microsoft 365 and Power Platform concepts.
    • Membership in an active community of 10,000 learners for peer support and networking.
    • Continuous updates with all new workshops, challenges, and success paths to keep your skills sharp and current.
    • Lifetime access to all virtual summit session recordings, with insights from top industry experts.
    • As we evolve, so will our content. The Platinum Plan includes all future training that aligns with the core educational content and formats currently offered.

    What is not included in the Platinum Plan?

    While the Platinum Plan is extensive, there are a few exclusives that fall outside its scope:

    • One-on-one coaching sessions and personalized, coached training programs.*
    • Custom software solutions or tools that are not a part of the standard offerings within the Collab365 Academy.
    • Niche training that falls outside of the Power Platform, SharePoint, or Microsoft Teams ecosystem.
    • External certifications or formal accreditation from third-party institutions.

    *Please note that there may be occasional exceptions to the coached training programs. Stay tuned for special announcements or offers that may include these features.

    Tell me more about the "Intranet Maker Certification" Program

    Availability for the 'Intranet Maker Certification Program' is strictly limited and allocation will be determined on a first-come, first-served basis. This promotional offer is exclusively available to purchasers of this All-Access Pass and is subject to the terms and conditions of sale. We reserve the right to modify or withdraw this offer at any time without prior notice.

    I have a Platinum Plan or Lifetime, Should I Buy This?

    If you already have an active Lifetime or Platinum Plan, the event recordings are included as are the bonus items. The BYI Program is being run in partnership with another business so is not included. If you are interested in this, please contact hello@collab365.com for exclusive pricing (places are limited)

    • Personal

    • Teams

    Purchase this training only:
    Get immediate access to this training content with a one-off purchase.
    $197.00 USD
    Or
    Subscribe to all of the training in the Collab365 Academy:
    Get this training plus over 450 hours of training and access to the Collab365 Academy. Learn More.