PL-200: Microsoft Power Platform Functional Consultant certification video training course by prepaway along with practice test questions and answers, study guide and exam dumps provides the ultimate training package to help you pass.

PL-200 Certification Training: Power Platform Functional Consultant

Course Introduction

The PL-200 Microsoft Power Platform Functional Consultant certification is designed for professionals who want to validate their ability to configure, implement, and manage Microsoft Power Platform solutions. This course provides the knowledge and skills needed to become a trusted functional consultant who can deliver business value through Power Platform applications. The training will give learners a strong foundation in Microsoft Dataverse, Power Apps, Power Automate, Power BI, and Power Virtual Agents.

Why This Course Matters

The demand for Power Platform consultants is growing rapidly as organizations adopt low-code technologies to streamline operations and enable digital transformation. By completing this course, learners will understand how to design solutions that align with business goals, improve productivity, and enhance user experiences. This certification also increases career opportunities across industries.

Learning Approach

The course is divided into five main parts to cover every aspect of the exam in detail. Each part is designed with explanations, examples, and practical applications. This ensures learners not only prepare for the exam but also build the confidence to implement solutions in real business scenarios.

Course Overview

This course begins with an introduction to Microsoft Power Platform and its key components. Learners will explore Microsoft Dataverse as the foundation for storing and managing data. The course then moves to Power Apps, where students will learn to build canvas and model-driven apps. Power Automate is covered to teach workflow automation and integration. Power BI training introduces data visualization and reporting skills. Power Virtual Agents covers building intelligent chatbots. Finally, learners will practice solution design, integration, and governance to prepare for real-world consulting roles.

Core Objectives

The course ensures learners achieve several objectives. Students will be able to configure Microsoft Dataverse to support apps and automation. They will design and implement Power Apps for different business scenarios. They will build automated processes using Power Automate. They will create interactive dashboards and reports with Power BI. They will develop chatbots with Power Virtual Agents. They will also manage security, implement integrations, and design solutions that meet organizational requirements.

Skills Covered

This training builds practical skills for functional consultants. Students will gain proficiency in using Microsoft Dataverse for data modeling and relationship management. They will become skilled in designing responsive Power Apps. They will master creating flows in Power Automate to connect systems. They will understand how to use Power BI for decision-making through data insights. They will gain the ability to develop bots that support customer interaction. They will learn governance, security, and solution deployment best practices.

Requirements of the Course

To succeed in this course, learners should have a basic understanding of Microsoft 365 services, such as SharePoint, Teams, and OneDrive. Familiarity with business processes and requirements gathering is recommended. Some prior exposure to Excel formulas, data models, or simple workflows is helpful. However, this course is designed to support both beginners and intermediate professionals. Learners do not need to be developers, as the focus is on low-code and no-code capabilities.

Who This Course Is For

This course is for individuals who want to become Microsoft Power Platform Functional Consultants. It is suitable for business analysts who work closely with stakeholders to identify business needs. It is valuable for IT professionals who want to specialize in business applications. It is beneficial for project managers who want to understand solution delivery. It is designed for anyone looking to build a career in Microsoft business applications.

Career Benefits

Earning the PL-200 certification demonstrates credibility in the market. Learners who complete this course can work as functional consultants, solution designers, or application specialists. They can contribute to digital transformation projects in industries like healthcare, finance, retail, government, and education. The certification provides opportunities for advancement in roles that require both technical and business skills.

Module Overview

The course is organized into modules that gradually build expertise. The first module introduces Microsoft Power Platform and Dataverse. The second module explores Power Apps in depth. The third module teaches automation with Power Automate. The fourth module covers reporting and analytics with Power BI. The fifth module trains learners in chatbot development with Power Virtual Agents. The final module brings all concepts together through solution design and governance.

Hands-On Experience

Throughout the course, learners will engage in practical exercises. They will design sample apps for specific business problems. They will automate processes that reduce repetitive tasks. They will build dashboards to analyze business data. They will create chatbots to improve customer engagement. These activities will ensure learners develop real-world skills, not just theoretical knowledge.

Preparing for the Exam

This course is aligned with the PL-200 exam objectives. Learners will gain both conceptual understanding and practical application. Practice questions, mock scenarios, and case studies will help learners assess their readiness. The course provides strategies for approaching exam questions and managing time effectively.

Learning Outcomes

By the end of the course, learners will be able to configure Dataverse environments, design user-friendly apps, implement automated workflows, create data-driven reports, and build intelligent chatbots. They will understand governance, security, and integration requirements. They will have the confidence to work as Microsoft Power Platform Functional Consultants.

Why Choose This Training

This training is structured to combine clarity, depth, and practice. Shorter paragraphs ensure readability. Multiple headings guide learners through the content easily. Each section connects theory with real-world business value. The focus is not only on passing the exam but also on equipping learners for functional consulting roles.

Understanding Microsoft Dataverse

Microsoft Dataverse is the data platform behind Power Platform. It provides secure and scalable storage for business applications. Dataverse is not just a database but a full solution for managing structured data, relationships, and business logic. Functional consultants use Dataverse to store and organize information that feeds Power Apps, Power Automate, Power BI, and Power Virtual Agents.

Benefits of Using Dataverse

Dataverse simplifies data management by offering a standard schema. It provides built-in entities such as contacts, accounts, and activities. It also supports creating custom tables to meet specific business needs. Security is built into Dataverse with role-based access. Integration with Microsoft 365 and Dynamics 365 makes it powerful for enterprise solutions. Using Dataverse reduces the complexity of managing data across different systems.

Core Concepts of Dataverse

To use Dataverse effectively learners must understand its key concepts. Tables are used to store data records. Columns define the type of data each record holds. Relationships connect tables to one another. Option sets provide predefined lists of values. Business rules apply logic directly in the data layer. Functional consultants must design tables carefully to reflect business processes.

Standard Tables in Dataverse

Dataverse includes many standard tables. Examples include accounts for organizations, contacts for individuals, and activities for tasks. These standard tables support common business needs and reduce the effort required to design solutions from scratch. Consultants can extend these tables or create new custom ones. Understanding the existing tables is important before designing custom structures.

Custom Tables and Columns

Consultants often need to create custom tables to meet unique requirements. A custom table can represent anything such as projects, orders, or assets. Columns define the type of information stored in the table such as text, numbers, currency, or dates. Functional consultants must choose the correct column type for performance and usability. They must also design tables with relationships in mind to ensure data integrity.

Relationships in Dataverse

Relationships link different tables to represent real-world connections. There are three types of relationships. One-to-many connects a single record in one table to multiple records in another. Many-to-one connects multiple records to a single record. Many-to-many connects records in both directions. Understanding relationships is vital for creating meaningful applications that reflect business processes.

Business Rules and Logic

Dataverse allows consultants to apply logic directly at the data level. Business rules can enforce conditions such as requiring certain fields or setting default values. Calculated fields can perform automatic calculations. Rollup fields can aggregate data across related records. These features reduce the need for complex coding while ensuring consistency.

Security Model in Dataverse

Security is a critical part of Dataverse. Role-based security allows consultants to control access to tables and records. Field-level security restricts sensitive information. Business units can be used to group users and data. Security roles define what actions users can perform such as create, read, update, or delete. Consultants must balance usability with security when configuring environments.

Integrating Dataverse with Microsoft Services

Dataverse integrates seamlessly with Microsoft 365 services. It connects with Outlook to track emails and appointments. It integrates with Teams to enable collaboration within apps. It connects with SharePoint for document management. It works with Dynamics 365 to extend enterprise solutions. This integration ensures business processes are streamlined without duplicating data.

Power Apps Overview

Power Apps is the application development tool within Power Platform. It allows functional consultants to build applications without traditional coding. There are two main types of apps. Canvas apps give complete design flexibility. Model-driven apps are structured and built on data models. Power Apps also supports portals for external access.

Canvas Apps Introduction

Canvas apps allow consultants to design apps by placing controls on a blank canvas. They are highly customizable and give freedom in layout. Consultants can connect canvas apps to multiple data sources including Dataverse, SharePoint, and SQL. Canvas apps are ideal for apps with unique user experiences or mobile-first requirements.

Designing Canvas Apps

Designing a canvas app involves selecting a layout, adding screens, and configuring controls. Consultants can add text boxes, buttons, galleries, and forms. They can apply logic using formulas similar to Excel. Themes and styles ensure consistent design. Testing across devices ensures usability. Canvas apps must be designed with both functionality and user experience in mind.

Common Scenarios for Canvas Apps

Canvas apps are often used for field service, inspections, or approvals. They allow workers to capture data on mobile devices. They are also used to create dashboards for managers. Because they can connect to multiple data sources canvas apps support flexible scenarios across industries.

Model-Driven Apps Introduction

Model-driven apps are based on Dataverse data models. Unlike canvas apps their design is driven by data structures and relationships. They provide a consistent layout with forms, views, and dashboards. Model-driven apps are suitable for complex business processes that require structured navigation.

Designing Model-Driven Apps

Consultants design model-driven apps by selecting tables, views, and forms. They configure how users navigate between records. They define business process flows to guide users step by step. They configure dashboards for insights. Model-driven apps ensure standardization and are ideal for scenarios like sales, customer service, or project management.

Common Scenarios for Model-Driven Apps

Model-driven apps are used in industries where processes must be consistent. Sales teams use them to manage opportunities. Customer service teams use them to track cases. Project teams use them to manage tasks and milestones. Model-driven apps support enterprise-grade requirements.

Portals in Power Apps

Portals allow organizations to create websites accessible to external users. These sites can expose Dataverse data securely. Portals are useful for customer self-service or partner collaboration. Consultants configure authentication, security, and data presentation. This expands the reach of Power Apps beyond internal users.

Combining Canvas and Model-Driven Apps

In many scenarios both canvas and model-driven apps are used together. For example, a model-driven app might manage structured data while a canvas app provides a specialized mobile interface. Consultants must know how to integrate both approaches to deliver complete solutions.

App Lifecycle Management

Managing the lifecycle of apps is part of a consultant’s responsibility. Apps must be designed, tested, deployed, and maintained. Solutions in Dataverse allow consultants to package apps, tables, and flows together. This makes it easier to move apps between environments such as development, testing, and production.

Governance and Compliance

Organizations often require governance to ensure apps meet standards. Consultants must configure environments to separate development from production. They must apply data loss prevention policies. They must ensure apps follow compliance rules. Proper governance ensures Power Apps support enterprise reliability.

Best Practices in App Development

There are several best practices consultants should follow. Data should be normalized to avoid redundancy. User experience should be simple and intuitive. Security must always be considered. Apps should be tested across devices and roles. Documentation should be provided for future support. Following best practices ensures apps provide long-term value.

Hands-On Practice with Dataverse and Power Apps

Practical exercises are critical for mastering these concepts. Learners should practice creating custom tables and relationships. They should design both canvas and model-driven apps. They should apply security roles and business rules. They should experiment with integrating apps into Teams. Hands-on practice ensures theoretical learning is applied effectively.

Real-World Use Cases

Dataverse and Power Apps are applied across industries. In healthcare they support patient management apps. In retail they support inventory and sales apps. In finance they support loan processing workflows. In education they support student engagement apps. These real-world examples show the flexibility of Power Platform in solving diverse business challenges.

Preparing for the Exam with Dataverse and Power Apps

The PL-200 exam includes many questions about Dataverse and Power Apps. Learners should be comfortable with data modeling, app types, and business rules. They should know how to configure forms, views, and security. They should understand the differences between canvas and model-driven apps. Practicing these topics will increase confidence during the exam.

What is Power Automate

Power Automate is a cloud-based service that allows users to create automated workflows. These workflows are called flows. A flow connects triggers and actions to perform tasks automatically. For example, a flow can send an email when a new record is created in Dataverse. Power Automate integrates with hundreds of services both within Microsoft and third-party platforms.

Importance of Power Automate

Automation is essential in modern business environments. Manual processes are slow and prone to error. By using Power Automate, organizations can reduce time spent on repetitive work. Consultants help businesses design flows that save resources and improve accuracy. Automation also ensures consistency by applying rules in the same way every time.

Key Components of Power Automate

Power Automate is built around three components: triggers, actions, and connectors. A trigger starts a flow, such as when data is added to a table. Actions are steps that perform tasks like sending a message or updating a record. Connectors link Power Automate to external services like SharePoint, Outlook, or Salesforce. Understanding these components is the foundation of creating useful flows.

Types of Flows

There are several types of flows in Power Automate. Automated flows start based on triggers such as record creation. Instant flows are triggered manually by a user. Scheduled flows run at specific times or intervals. Business process flows guide users through stages of a process. Desktop flows use robotic process automation to automate legacy applications. Each type of flow is useful for different business needs.

Automated Flows

Automated flows are triggered by events. For example, when a new customer record is created in Dataverse an automated flow can notify a sales manager. Automated flows are useful for monitoring data and reacting instantly. They reduce delays and ensure important actions are taken without manual effort.

Instant Flows

Instant flows are triggered by users. For example, a user can click a button in a canvas app to start a flow. Instant flows give users control while still automating tasks. They are often used for approvals or quick actions that need to be executed on demand.

Scheduled Flows

Scheduled flows run at defined intervals. For example, a scheduled flow can run every night to clean up data or generate a report. These flows are useful for recurring tasks that must happen regularly without user intervention.

Business Process Flows

Business process flows guide users through defined stages. For example, in a sales process a business process flow may include stages such as lead qualification, proposal, and closing. Business process flows ensure consistency and standardization. They help users follow best practices and reduce errors in complex processes.

Desktop Flows and RPA

Desktop flows use robotic process automation to interact with applications that do not have modern connectors. Consultants can record steps performed on a desktop and automate them. This is useful for legacy systems or tasks that require manual interaction. RPA expands the reach of Power Automate beyond cloud-based services.

Connectors in Power Automate

Connectors are the bridge between Power Automate and external systems. There are hundreds of connectors available including Microsoft 365 services, Dynamics 365, and third-party tools. Connectors allow consultants to design flows that integrate across platforms. Premium connectors provide advanced integration with enterprise applications like SAP or Oracle.

Common Scenarios for Connectors

Connectors are used in many scenarios. A connector to Outlook can automate email notifications. A connector to SharePoint can update documents. A connector to Twitter can track mentions of a brand. By combining connectors consultants can build powerful automation that spans multiple systems.

Triggers in Power Automate

Triggers start flows when an event occurs. Triggers can be based on data changes such as when a record is updated. They can also be based on system events like receiving an email. Choosing the right trigger ensures flows start at the correct time.

Actions in Power Automate

Actions are steps within a flow. For example, an action can create a task in Planner or send a message in Teams. Actions can include conditions and loops. Conditions allow flows to branch based on data values. Loops allow flows to repeat steps for multiple records. Actions define the logic of a flow.

Approval Processes with Power Automate

Approvals are a common use case for Power Automate. For example, when an expense report is submitted a flow can send an approval request to a manager. The manager can approve or reject the request from email or Teams. Approval flows ensure processes are transparent and auditable.

Integration with Dataverse

Dataverse works seamlessly with Power Automate. Flows can create, update, or delete records in Dataverse. They can react when data changes. For example, a flow can update related records when a status changes. Consultants must understand how to use Dataverse triggers and actions effectively.

Integration with Microsoft 365

Power Automate integrates deeply with Microsoft 365. Flows can manage emails in Outlook, documents in SharePoint, and tasks in Planner. They can post messages in Teams to improve collaboration. These integrations allow consultants to build solutions that fit naturally into the Microsoft ecosystem.

Integration with Dynamics 365

Dynamics 365 applications such as Sales, Customer Service, and Field Service are built on Dataverse. Power Automate extends these applications by adding automation. For example, in Dynamics 365 Sales a flow can notify users when a high-value opportunity is created. Consultants who understand these integrations can deliver significant value to businesses.

Advanced Scenarios with Power Automate

Power Automate supports advanced scenarios such as parallel branches, error handling, and variable management. Consultants can design flows that handle exceptions gracefully. They can use expressions to manipulate data. They can manage state across multiple steps. Advanced skills allow consultants to design robust and scalable flows.

Governance in Power Automate

Governance ensures flows are created and managed responsibly. Administrators can apply data loss prevention policies to control which connectors can be used. Environment management separates development, testing, and production flows. Auditing ensures compliance. Consultants must align their designs with governance policies.

Security Considerations in Power Automate

Flows often access sensitive data. Security must be carefully managed. Service accounts can be used to ensure flows run reliably. Least privilege principles should be applied to connections. Consultants must be aware of how authentication works with connectors. Proper security ensures automation is safe and compliant.

Performance Optimization

Flows must be designed for performance. Excessive loops or inefficient queries can slow down flows. Using batch operations and filters improves efficiency. Consultants should monitor flows to identify bottlenecks. Performance tuning ensures flows run quickly and reliably.

Monitoring and Troubleshooting

Power Automate provides tools for monitoring. Run history shows details of each execution. Error messages help identify issues. Consultants must know how to troubleshoot flows when they fail. Adding error handling improves resilience. Monitoring ensures flows continue to deliver value after deployment.

Best Practices in Flow Design

There are several best practices to follow. Flows should be named clearly for easy management. They should be documented so others can understand them. Conditions should be used to handle exceptions. Flows should be tested thoroughly before deployment. Following best practices ensures flows remain maintainable.

Hands-On Practice with Power Automate

Practical exercises are critical for mastering Power Automate. Learners should build simple automated flows like sending notifications. They should create instant flows triggered by buttons in apps. They should design scheduled flows for data cleanup. They should practice approval workflows. Real practice helps learners move from theory to application.

Real-World Use Cases

Power Automate is used across industries. In healthcare it automates appointment reminders. In retail it manages order updates. In finance it streamlines approval of loan applications. In government it supports case management. In education it automates student registration. These examples show the wide applicability of Power Automate.

Preparing for the Exam with Power Automate

The PL-200 exam includes many questions about Power Automate. Learners must know the types of flows and when to use them. They must understand connectors, triggers, and actions. They must be familiar with business process flows. They should also understand governance and security. Practicing these topics is key to exam success.

What is Power BI

Power BI is a business intelligence service that enables users to analyze data and share insights. It provides a set of tools for connecting to different data sources, transforming data, and building visualizations. Reports created in Power BI help businesses understand trends, identify opportunities, and solve problems. Consultants use Power BI to deliver value by turning information into action.

Importance of Analytics in Business

Analytics allows organizations to understand what is happening in their business. Without analytics decisions are based on assumptions rather than facts. Power BI gives businesses the ability to track performance and monitor key metrics. Consultants help organizations design dashboards that highlight important data. Analytics ensures strategies are based on evidence rather than guesswork.

Core Components of Power BI

Power BI includes several components. Power BI Desktop is used to design reports. Power BI Service is the cloud platform for publishing and sharing. Power BI Mobile allows users to view reports on devices. Power BI Report Builder is used for paginated reports. Consultants must understand these components to design complete solutions.

Connecting to Data Sources

Power BI connects to hundreds of data sources. These include files like Excel and CSV, databases such as SQL Server, and cloud services like Dataverse and SharePoint. Functional consultants must understand how to choose and configure connections. Choosing the right data source ensures reports are accurate and reliable.

Data Transformation with Power Query

Before data can be analyzed it must be prepared. Power Query is used to transform and clean data. Consultants can remove errors, filter rows, merge tables, and create calculated columns. Data transformation ensures reports are consistent and accurate. Learning Power Query is essential for preparing data effectively.

Data Modeling in Power BI

A strong data model is the foundation of every Power BI report. Data modeling involves defining tables, relationships, and calculations. Consultants must design models that reflect business processes. Relationships connect tables in meaningful ways. Measures are created using DAX formulas to perform calculations. A well-structured data model makes reports easier to use and understand.

Understanding DAX

DAX stands for Data Analysis Expressions. It is the formula language used in Power BI to create calculations. Measures and calculated columns rely on DAX. Consultants use DAX to create metrics such as year-to-date sales or average response times. DAX allows reports to deliver advanced insights beyond simple totals.

Visualizations in Power BI

Power BI provides a wide range of visualizations. These include charts, tables, maps, and gauges. Consultants must choose the right visualization for the data. A bar chart may show comparisons, while a line chart highlights trends. Maps display geographic information. Choosing effective visuals ensures reports communicate insights clearly.

Designing Effective Dashboards

Dashboards bring multiple reports and visuals together. Consultants must design dashboards that are easy to understand. They should highlight key metrics and provide quick access to details. Dashboards should be organized with the user in mind. A good dashboard tells a story and guides decision-makers through the data.

Using Filters and Slicers

Filters and slicers allow users to explore data. They enable users to narrow results by date, region, or category. Consultants should design reports that empower users to ask their own questions. Interactive filtering makes Power BI more powerful than static reports.

Advanced Features in Power BI

Power BI includes advanced features for consultants. Row-level security restricts data based on user roles. Drill-through allows users to explore details in context. Bookmarks capture different views of a report. AI visuals provide predictive insights. These advanced features help consultants create sophisticated and flexible solutions.

Integration with Dataverse

Power BI integrates directly with Dataverse. Consultants can connect to tables and create reports on business data. For example, reports can analyze customer interactions stored in Dataverse. This integration allows consultants to extend Power Apps and Power Automate with rich analytics. Dataverse and Power BI together provide a complete solution for managing and analyzing business information.

Integration with Microsoft 365

Power BI works seamlessly with Microsoft 365. Reports can be shared in Teams for collaboration. Excel can be used as a data source or for additional analysis. SharePoint can host dashboards for easy access. This integration ensures Power BI fits naturally into business workflows.

Integration with Dynamics 365

Dynamics 365 applications generate large amounts of data. Power BI helps make sense of this data through advanced reporting. For example, Dynamics 365 Sales data can be visualized to track performance. Customer Service cases can be analyzed for response times. Field Service data can be monitored for efficiency. Consultants who understand this integration deliver high-value solutions.

Publishing and Sharing Reports

Once reports are created they must be shared with others. Power BI Service allows consultants to publish reports to the cloud. From there reports can be shared with teams or embedded into applications. Consultants must understand how to configure permissions to ensure the right people have access. Sharing reports effectively is as important as building them.

Power BI Workspaces

Workspaces are collaborative environments in Power BI Service. Consultants use workspaces to organize reports and dashboards. Workspaces can be shared with colleagues for team projects. They also support deployment pipelines for managing development and production. Workspaces ensure reporting solutions are managed efficiently.

Power BI Apps

Apps in Power BI allow organizations to package dashboards and reports together. These apps can be published to groups of users. Apps make it easy for end users to access the reports they need. Consultants often deliver solutions in the form of apps to ensure consistency.

Power BI Security

Security is critical in Power BI. Row-level security restricts access within a dataset. Permissions in the Power BI Service control who can view or edit reports. Data loss prevention policies ensure compliance. Consultants must design solutions that protect sensitive information while still being useful.

Performance Optimization in Power BI

Large datasets can slow reports if not optimized. Consultants must design models with performance in mind. This includes reducing unnecessary columns, using efficient DAX calculations, and aggregating data when possible. Optimized reports run faster and improve the user experience.

Monitoring and Management

Consultants must also monitor Power BI usage. The Power BI admin portal provides usage metrics. Activity logs show how reports are used. Monitoring helps consultants understand adoption and identify areas for improvement. Management ensures solutions continue to deliver value after deployment.

Governance in Power BI

Organizations need governance for reporting. This includes setting policies for workspaces, defining naming standards, and managing access. Governance ensures consistency across reports and prevents duplication. Consultants must align with governance frameworks to deliver reliable solutions.

Real-World Use Cases

Power BI is applied in many industries. In healthcare it monitors patient outcomes. In finance it tracks investments and compliance. In retail it analyzes sales and customer behavior. In government it supports transparency and performance measurement. In education it evaluates student progress. These use cases show the versatility of Power BI in solving complex problems.

Hands-On Practice with Power BI

Practical exercises are critical for mastering Power BI. Learners should practice connecting to different data sources. They should design models with relationships and DAX measures. They should create dashboards with multiple visualizations. They should apply row-level security. Hands-on practice ensures theoretical learning is translated into skill.

Preparing for the Exam with Power BI

The PL-200 exam includes objectives related to Power BI. Learners must understand how to connect to data sources, model data, and create visualizations. They must know how to configure security and share reports. They must be able to integrate Power BI with other Power Platform components. Practicing these areas will increase readiness for the exam.

Best Practices in Power BI

There are best practices consultants should follow. Reports should be designed for the audience and avoid clutter. Models should be kept simple and efficient. Naming conventions should be consistent. Security must be applied carefully. Documentation should be provided to support users. Following best practices ensures solutions remain sustainable.

Challenges in Power BI Projects

Consultants often face challenges with Power BI. Data quality may be poor and require significant transformation. Users may request too many visuals making dashboards complex. Large datasets may require optimization. Consultants must balance user needs with technical limitations. Addressing challenges is part of delivering successful solutions.

Prepaway's PL-200: Microsoft Power Platform Functional Consultant video training course for passing certification exams is the only solution which you need.