Mastering And Working With Data In Power Apps

This Workshop is ideal for anyone who has a basic grasp of Power Apps but wants to understand further how to manipulate data from multiple data sources.

Suitable For

Beginners

Duration

4 Hours Recording

Format

Workshop

Presenter

Ahmad Najjar MVP

Purchase this training only:
Get immediate access to this training content with a one-off purchase.
$97.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.

What you'll learn:

  • HOW TO WORK WITH THE DATA WITHIN YOUR POWER APP: The skills to understand and work with with your data in complex ways within your Power App.
  • HOW TO CONNECT DATA TO YOUR POWER APPS: The ability to connect to the business data you need from a number of data sources within your Power Apps.
  • THE ABILITY TO CREATE COMPLEX DATA INFUSED POWER APPS: Taking a further step on your Power Apps learning journey your will be able to create complex Apps for your Business.

Agenda:

Getting Your Data

  • Introduction: Power Apps Data.
  • Connecting to data sources including; SharePoint, Dataverse and SQL.
  • Using Collections and Tables for data within your Power App.
  • Binding data to galleries
  • Working with Your Data

  • Slice and dice data: Working with Filter, Search, Lookup, Sort and Distinct functions.
  • Understanding delegation.
  • CRUD operations (data manipulation).
  • Advanced Scenarios

  • Working with Patch, Remove and 'RemoveIf' functions.
  • Using the 'IN' operator.
  • Merging data from multiple sources.
  • Bulk Patch and Remove of records in your data.
  • This training includes:

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

    Thoughts from the Collab365 Team:

    Let’s face it most applications and solutions are nothing without their data, this is also true for your business and business processes.

    To build useful Power Apps, that help with business processes and do not add to the burden of the end user, they have to interact seamlessly with the correct business data sources.

    Data is king, queen, or key to any organization!

    Some examples of data types and data sources you might need to connect to with your Power Apps:

    • Customer Data
    • Sales Data
    • Knowledge Base or Procedures
    • General Office 365 Data e.g. Outlook or OneDrive
    • Data in SharePoint Lists
    • Excel Files
    • SQL or other Databases.

    The list is almost endless! 

    To build useful Power Apps, that help with business processes and do not add to the burden of the end user, they have to interact seamlessly with the correct business data sources.

    Would this workshop benefit me?

    Unsure about any of these?... If so this workshop can help you:

    • Do you know how to connect all your business data in your Power App?
    • Do you know how to work with and update that data once it is connected?
    • Can you slice and dice the data with Filters, search, lookup and many other functions?

    In this workshop you will learn how to build data infused Power Apps, that can help power your business.

    This 5 hour LIVE workshop is ideal for all who have a basic experience with Power Apps and want to take that next step, it will cover the following topics:

    • Getting your data from multiple sources.
    • Working with your data in your UI.
    • Updating your data sources whilst ensuring data integrity is maintained.
    • Performing more advanced functions and operations on your data. 

    Sound good?.. Scroll down below to see more details on what Ahmad will cover in the Workshop.

    Meet your workshop host:

    Ahmad Najjar MVP

    Ahmad Najjar, Microsoft MVP

    Ahmad is an enthusiastic developer heart and soul and a senior consultant based in Oslo at Info worker. He’s also an active co-organizer for events and hackathons. During his 15 years of experience, he has mainly worked with Microsoft based technologies, like ASP.NET, C#, SQL and (of course) SharePoint, which is his main focus area. He has worked with SharePoint since the beta version of MOSS 2007!

    Ahmad is a subject matter expert in Microsoft Power Automate and Power Apps, where "more and more" they are becoming his full-time focus areas! He is always exploring them in many ways from basic to advanced scenarios. He has also delivered countless sessions and workshops on the subject!

    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.

    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 "Build Your Intranet" Program

    Availability for the 'Build Your Intranet 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.
    $97.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.