Get up to speed with expert tips, techniques, and the latest insights to confidently take the PL-200 exam Key FeaturesLearn effectively with the help of self-assessment questions, mock tests, and detailed explanations in this up-to-date study guideAddress the challenges faced by a functional consultant in day-to-day activitiesUnderstand how to configure, customize, and implement solutions based on Power PlatformBook Description The Power Platform Functional Consultant Associate (PL-200) exam tests and validates the practical skills of Power Platform users who are proficient in developing solutions by combining the tools in Power Platform and the Microsoft 365 ecosystem based on business needs. This certification guide offers complete, up-to-date coverage of the PL-200 exam so you can prepare effectively for the exam. Written in a clear, succinct way with self-assessment questions, exam tips, and mock exams with detailed explanations of solutions, this book covers common day-to-day activities involved in configuring Power Platform, such as managing entities, creating apps, implementing security, and managing system change. You'll also explore the role of a functional consultant in creating a data model in the Microsoft Dataverse (formerly Common Data Service). Moving ahead, you'll learn how to design the user experience and even build model-driven and canvas apps. As you progress, the book will show you how to manage automation and create chatbots. Finally, you'll understand how to display your data with Power BI and integrate Power Platform with Microsoft 365 and Microsoft Teams. By the end of this book, you'll be well-versed with the essential concepts and techniques required to prepare for the PL-200 certification exam. What you will learnUnderstand how to build apps that meet customer needsExtend the schema for Dataverse with entities, fields, and relationshipsCreate and configure automations to simplify user activitiesExplore various security features in Power Platform and learn how to implement themUse multiple data sources to create task- or role-based web and mobile applications for usersAutomate business processes and enhance the user experience with Power Automate and UI FlowsIntegrate various applications within the Microsoft ecosystem with Power PlatformWho this book is for This book is for functional consultants and business analysts who are involved in implementing solutions based on Power Platform or Dynamics 365. As the PL-200 exam is a pre-requisite for other role-based certifications in Power Platform and Microsoft Dynamics 365, individuals pursuing their careers in these domains will also find this book helpful. Basic knowledge of Power Platform and access to a Power Platform environment are required to get started with this book.

Get up to speed with expert tips, techniques, and the latest insights to confidently take the PL-200 exam Key Features Learn effectively with the help of self-assessment questions, mock tests, and detailed explanations in this up-to-date study guide Address the challenges faced by a functional consultant in day-to-day activities Understand how to configure, customize, and implement solutions based on Power Platform Book Description The Power Platform Functional Consultant Associate (PL-200) exam tests and validates the practical skills of Power Platform users who are proficient in developing solutions by combining the tools in Power Platform and the Microsoft 365 ecosystem based on business needs. This certification guide offers complete, up-to-date coverage of the PL-200 exam so you can prepare effectively for the exam. Written in a clear, succinct way with self-assessment questions, exam tips, and mock exams with detailed explanations of solutions, this book covers common day-to-day activities involved in configuring Power Platform, such as managing entities, creating apps, implementing security, and managing system change. You'll also explore the role of a functional consultant in creating a data model in the Microsoft Dataverse (formerly Common Data Service). Moving ahead, you'll learn how to design the user experience and even build model-driven and canvas apps. As you progress, the book will show you how to manage automation and create chatbots. Finally, you'll understand how to display your data with Power BI and integrate Power Platform with Microsoft 365 and Microsoft Teams. By the end of this book, you'll be well-versed with the essential concepts and techniques required to prepare for the PL-200 certification exam. What you will learn Understand how to build apps that meet customer needs Extend the schema for Dataverse with entities, fields, and relationships Create and configure automations to simplify user activities Explore various security features in Power Platform and learn how to implement them Use multiple data sources to create task- or role-based web and mobile applications for users Automate business processes and enhance the user experience with Power Automate and UI Flows Integrate various applications within the Microsoft ecosystem with Power Platform Who this book is for This book is for functional consultants and business analysts who are involved in implementing solutions based on Power Platform or Dynamics 365. As the PL-200 exam is a pre-requisite for other role-based certifications in Power Platform and Microsoft Dynamics 365, individuals pursuing their careers in these domains will also find this book helpful. Basic knowledge of Power Platform and access to a Power Platform environment are required to get started with this book.

Publisher's Note: This edition from 2020 is outdated and is not compatible with the new standards of Microsoft Power Platform. A new Second edition has been published to cover the latest patterns, models, and methodologies leveraging the Microsoft ecosystem to create tailor-made enterprise applications. It combines the powers of Power Apps, Power BI, Azure, and Dynamics 365 to create enterprise applications. Who this book is for This book is for enterprise architects and technical decision makers who want to craft complex solutions using Microsoft Power Platform to serve growing business needs and to stay competitive in the modern IT world. A basic understanding of Microsoft Power Platform will help you to get started with this book.

Find our new updated edition to get the latest industry knowledge at your disposal Key Features Book DescriptionMicrosoft Power Apps Cookbook is a complete resource filled with meticulously crafted recipes to help you build customized business apps that meet ever-changing enterprise demands. You will learn how to design modern apps with the low-code approach in a rapid application development environment by achieving enterprise-wide business agility.What you will learn Learn to integrate and test canvas apps Design model-driven solutions using various features of Microsoft Dataverse Automate business processes such as triggered events, status change notifications, and approval systems with Power Automate Implement RPA technologies with Power Automate Extend your platform using maps and mixed reality Implement AI Builder s intelligent capabilities in your solutions Extend your business applications capabilities using Power Apps Component Framework Create website experiences for users beyond the organization with Microsoft Power Pages Who this book is for This book is for citizen developers and business users looking to build custom applications as per their organizational needs without depending on professional developers. Traditional app developers will also find this book useful by discovering how to build applications in a rapid application development environment with increased productivity and speed. The book is recommended for Power Apps beginners who have taken a couple of online tutorials but are struggling to implement or create real-world solutions. Basic knowledge of Power Apps is necessary to get the best out of this cookbook.

A step-by-step guide that will help you create, share, and deploy applications across your organization using MS PowerApps Key FeaturesCreate apps with rich user experiences without paying for costly developersImprove productivity with business process automation using Microsoft Power AutomateBuild enterprise-grade apps with MS PowerApps' built-in storage space, Common Data ServiceBook Description Microsoft PowerApps provides a modern approach to building business applications for mobile, tablet, and browser. Learn Microsoft PowerApps will guide you in creating powerful and productive apps that will add value to your organization by helping you transform old and inefficient processes and workflows. Starting with an introduction to PowerApps, this book will help you set up and configure your first application. You'll explore a variety of built-in templates and understand the key difference between types of applications such as canvas and model-driven apps, which are used to create apps for specific business scenarios. In addition to this, you'll learn how to generate and integrate apps directly with SharePoint, and gain an understanding of PowerApps key components such as connectors and formulas. As you advance, you'll be able to use various controls and data sources, including technologies such as GPS, and combine them to create an iterative app. Finally, the book will help you understand how PowerApps can use several Microsoft Power Automate and Azure functionalities to improve your applications. By the end of this PowerApps book, you'll be ready to confidently develop lightweight business applications with minimal code. What you will learnDesign an app by simply dragging and dropping elements onto your canvasUnderstand how to store images within PowerAppsExplore the use of GPS and how you can use GPS data in PowerAppsGet to grips with using barcodes and QR codes in your appsShare your applications with the help of Microsoft Teams and SharePointUse connectors to share data between your app and Microsoft's app ecosystemWho this book is for This book is ideal for business analysts, IT professionals, and both developers and non-developers alike. If you want to meet business needs by creating high productivity apps, this book is for you. Don't worry if you have no experience or knowledge of PowerApps, this book simplifies PowerApps for beginners.

Advance your everyday proficiency with Excel! And earn the credential that proves it! Demonstrate your expertise with Microsoft Excel! Designed to help you practice and prepare for Microsoft Office Specialist: Excel Associate (Excel and Excel 2019) certification, this official Study Guide delivers: In-depth preparation for each MOS objective Detailed procedures to help build the skills measured by the exam Hands-on tasks to practice what you’ve learned Ready-made practice files Sharpen the skills measured by these objectives: Manage Worksheets and Workbooks Manage Data Cells and Ranges Manage Tables and Table Data Perform Operations by Using Formulas and Functions Manage Charts About MOS A Microsoft Office Specialist (MOS) certification validates your proficiency with Microsoft Office programs, demonstrating that you can meet globally recognized performance standards. Hands-on experience with the technology is required to successfully pass Microsoft Certification exams.

Prepare for Microsoft Exam SC-900 and help demonstrate your real-world knowledge of the fundamentals of security, compliance, and identity (SCI) across cloud-based and related Microsoft services. Designed for business stakeholders, new and existing IT professionals, functional consultants, and students, this Exam Ref focuses on the critical thinking and decision-making acumen needed for success at the Microsoft Certified: Security, Compliance, and Identity Fundamentals level. Focus on the expertise measured by these objectives: • Describe the concepts of security, compliance, and identity • Describe the capabilities of Microsoft identity and access management solutions • Describe the capabilities of Microsoft security solutions • Describe the capabilities of Microsoft compliance solutions This Microsoft Exam Ref: • Organizes its coverage by exam objectives • Features strategic, what-if scenarios to challenge you • Assumes you are a business user, stakeholder, consultant, professional, or student who wants to create holistic, end-to-end solutions with Microsoft security, compliance, and identity technologies About the Exam Exam SC-900 focuses on knowledge needed to describe: security and compliance concepts and methods; identity concepts; Azure AD identity services/types, authentication, access management, identity protection, and governance; Azure, Azure Sentinel, and Microsoft 365 security management; Microsoft 365 Defender threat protection and Intune endpoint security; Microsoft 365 compliance management, information protection, governance, insider risk, eDiscovery, and audit capabilities; and Azure resource governance. About Microsoft Certification Passing this exam fulfills your requirements for the Microsoft Certified: Security, Compliance, and Identity Fundamentals certification, helping to demonstrate your understanding of the fundamentals of security, compliance, and identity (SCI) across cloud-based and related Microsoft services. With this certification, you can move on to earn more advanced related Associate-level role-based certifications. See full details at: microsoft.com/learn