Others

How to Use Power Apps for Employee Name Selection and Email Workflows

Tauseeq MagsiTauseeq Magsi Oct 23, 2026 871 views

Question details

The user needs to replace manual name entry in Microsoft Forms with a validated directory lookup and automate email notifications upon submission.

How to Use Power Apps for Employee Name Selection and Email Workflows
Product
Power Apps
Device & OS
not provided
Scenario
Creating an internal company form to capture accurate employee names and trigger automatic confirmation emails.
Observed behavior
Microsoft Forms lacks built-in active directory lookup functionality, resulting in manually typed responses and potentially invalid email addresses.
Before you start

Verify that you have a valid Microsoft 365 license with permissions to create Power Apps canvas apps, access SharePoint, and use the Office 365 Outlook connector.

Solution 1Recommended

Build a Canvas App for Directory Lookup and Email Automation

Use Power Apps to automatically retrieve the logged-in user's details and trigger an Outlook email using the Patch function.

Since Microsoft Forms cannot dynamically search a company directory, building a custom canvas app in Power Apps is the best approach. By leveraging the Office 365 Users connector and SharePoint integration, you can ensure precise data entry and automated messaging without manual typos.

1
Create a SharePoint List

Set up a SharePoint Online list with the necessary columns (e.g., Employee Name, Email, Department) to store the form responses securely.

2
Design the Power App

Create a new Canvas App from blank. Insert text input fields and labels. Set the default value of the email label to 'User().Email' to automatically capture the current user's email address.

3
Add Data Connections

Navigate to the Data tab on the left sidebar and add connections for your SharePoint list, 'Office 365 Users', and 'Office 365 Outlook'.

4
Configure the Submit Button

Insert a button and modify its 'OnSelect' property to use the Patch function to save the record to SharePoint. Add the 'Office365Outlook.SendEmailV2' function in the same formula to send an automated notification simultaneously.

Build a Canvas App for Directory Lookup and Email Automation
Formula Tip: Separate your Patch and SendEmailV2 commands with a semicolon in the OnSelect property to ensure both actions execute sequentially without errors.
Free Microsoft Office alternative

Looking for an easier way to handle everyday documents?

While Power Apps handles complex custom application development, managing everyday documents, spreadsheets, and basic data collection shouldn't require advanced coding. WPS Office is a free, lightweight suite that serves as an excellent alternative to Microsoft Office.

  1. 1. Download the Installer: Visit the official WPS website and download the free installation package for your operating system.
  2. 2. Install WPS Office: Run the setup file and follow the on-screen instructions to complete the fast, lightweight installation.
  3. 3. Start Creating: Open WPS Office to instantly begin working on your text documents, spreadsheets, and presentations without subscription hurdles.
Seamlessly compatible with Microsoft Excel, Word, and PowerPoint formats.Lightweight installation and familiar interface with zero learning curve.Includes straightforward tools for creating and editing daily office documents.Completely free to download and use for essential productivity tasks.
microsoft office alternative - wps office

Frequently Asked Questions

Can I link Microsoft Forms to an active directory for name lookup?

No, Microsoft Forms does not natively support dynamic directory lookups. For validated staff lookup against your organization's directory, transitioning the form to Power Apps is highly recommended.

How do I automatically populate the user's name in Power Apps?

You can use the formula 'User().FullName' in the Default property of a text input or label to automatically display the logged-in user's full name based on their Active Directory profile.

Do I need Power Automate to send emails from Power Apps?

No, while Power Automate can handle complex workflows, you can send simple email notifications directly from Power Apps by utilizing the Office 365 Outlook connector and the SendEmailV2 function.