How to Automate Lead Capture from Website to Dataverse Using Power Automate
A small marketing team wants to automate the process of capturing leads from their website into a Dataverse table. Currently, the website sends an email notification when a lead submits a form, and a team member manually enters the data into a Power Apps app. The team wants to eliminate manual data entry. They also want to automatically send a confirmation email to the lead and create a task in Microsoft To Do for the sales representative to follow up. You need to recommend a Power Platform solution. What should you do?
Quick Answer
The correct answer is to use Power Automate to monitor the website's email inbox, parse the lead data, add it to Dataverse, send a confirmation email, and create a task in Microsoft To Do. This solution is correct because it directly eliminates manual data entry by automating the entire lead capture workflow: Power Automate triggers on incoming emails, extracts lead details from the body or attachments, writes them into a Dataverse table, sends an automated confirmation, and creates a follow-up task—all without changing the existing website form. On the PL-900 exam, this scenario tests your understanding of how Power Automate connects disparate systems (email, Dataverse, To Do) to solve a real-world business process, often appearing as a multi-step automation question. A common trap is choosing a Power Apps-only solution, which still requires manual input, or suggesting a custom connector when the built-in email trigger suffices. Memory tip: think “Email in, Dataverse stored, confirmation sent, task created”—that’s the four-step automation chain.
⚠ Common exam trap
It's easy for candidates to assume the website form must be replaced or modified (options B, C, D) rather than realizing that Power Automate can directly consume existing email notifications from the website without any changes to the website itself.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Use Power Automate to monitor the website's email inbox, parse the lead data, add it to Dataverse, send confirmation email, and create a task in Microsoft To Do.
It directly addresses the requirement to eliminate manual data entry by using Power Automate to monitor the website's email inbox (via a trigger like 'When a new email arrives'), parse the lead data from the email body or attachments, add it to a Dataverse table, send a confirmation email, and create a task in Microsoft To Do. This solution automates the entire workflow without requiring changes to the existing website form or manual intervention.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Use Power Automate to monitor the website's email inbox, parse the lead data, add it to Dataverse, send confirmation email, and create a task in Microsoft To Do.
Why this is correct
Power Automate can automate the entire process without manual intervention.
- ✗
Replace the website form with a Power Apps portal form, and use Power Automate for emails and tasks.
Why it's wrong here
A Power Apps portal form captures data directly into Dataverse, but the stem requires the website’s existing form to be replaced, not supplemented—the team wants to automate from the current website, not rebuild it. This option is tempting because portal forms integrate natively with Power Automate for confirmations and tasks, which would be correct if the team were building a new customer-facing site rather than automating an existing third-party form.
- ✗
Use Microsoft Forms to collect leads, and Power Automate to add to Dataverse and send emails.
Why it's wrong here
Using Microsoft Forms is incorrect because the scenario specifies leads originate from an *existing* website form, not a new form created within Microsoft Forms. This option would replace the current website form, rather than integrating with its submissions. It is tempting because Microsoft Forms, combined with Power Automate, is an excellent, low-code solution for *new* lead collection requirements, allowing easy data capture into Dataverse and subsequent automated actions like sending confirmation emails or creating To Do tasks.
- ✗
Create a Power Apps app on the website to capture leads, and use Power Automate to send emails and create tasks.
Why it's wrong here
This still requires building an app; the website already has a form.
Go deeper
Related to this question
About these practice questions
One of 904 original PL-900 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
Same concept, more angles
3 more ways this is tested on PL-900
These questions test the same concept from different angles. Work through them to make sure you can recognise it however the exam phrases it.
Variation 1. A sales team wants to track customer interactions and automate follow-up emails without custom development. What Microsoft Power Platform component should they use?
easy- A.Power BI
- B.Power Apps
- C.Power Virtual Agents
- ✓ D.Power Automate
Why D: Power Automate is the correct choice because it enables the sales team to create automated workflows that trigger follow-up emails based on customer interactions, such as when a new contact is added or a meeting ends. It integrates with common data sources like Dynamics 365, SharePoint, or Outlook, and uses prebuilt connectors to send emails without any custom code.
Variation 2. A non-profit organization wants to automate donation receipt emails and track donor engagement. Which Microsoft Power Platform tool should they use?
easy- ✓ A.Power Automate
- B.Power Virtual Agents
- C.Power BI
- D.Power Apps
Why A: Power Automate is the correct tool because it enables the non-profit to create automated workflows that can trigger donation receipt emails when a new donation is recorded, and it can also update donor engagement metrics in a connected data source like Dataverse or SharePoint. This directly addresses the need for automating email notifications and tracking engagement without manual intervention.
Variation 3. A non-profit organization wants to automate the process of sending thank-you emails to donors after a donation is recorded in a SharePoint list. Which Power Platform tool should they use?
medium- A.Power Apps
- B.Power Virtual Agents
- ✓ C.Power Automate
- D.Power BI
Why C: Power Automate is the correct tool because it is designed to create automated workflows that trigger actions based on events, such as a new item being added to a SharePoint list. In this scenario, a Power Automate flow can be configured to run automatically when a donation is recorded, then send a thank-you email via an email connector (e.g., Outlook or SMTP). This directly addresses the need for process automation without manual intervention.
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This PL-900 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the PL-900 exam.