How to Use Power Apps for Employee Name Selection and Email Workflows
Question details
The user needs to replace manual name entry in Microsoft Forms with a validated directory lookup and automate email notifications upon submission.

- 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.
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.
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.
Set up a SharePoint Online list with the necessary columns (e.g., Employee Name, Email, Department) to store the form responses securely.
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.
Navigate to the Data tab on the left sidebar and add connections for your SharePoint list, 'Office 365 Users', and 'Office 365 Outlook'.
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.

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. Download the Installer: Visit the official WPS website and download the free installation package for your operating system.
- 2. Install WPS Office: Run the setup file and follow the on-screen instructions to complete the fast, lightweight installation.
- 3. Start Creating: Open WPS Office to instantly begin working on your text documents, spreadsheets, and presentations without subscription hurdles.

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.




