How to Capture Staff Details from Microsoft Forms with Power Automate
Question details
The user needs a method to retrieve and save detailed employee directory information automatically when a Microsoft Form is submitted.

- Product
- Microsoft Forms, Power Automate, SharePoint
- Device & OS
- not provided
- Scenario
- Collecting data such as staff responses or temperature checks via Microsoft Forms and needing to log the responder's organization details.
- Observed behavior
- Microsoft Forms does not natively pull all Active Directory details like job title; a workflow must be set up to extract and compile this data into a SharePoint list.
Ensure you have active permissions to create Microsoft Forms, edit SharePoint lists, and build Power Automate workflows within your organization's Office 365 environment.
Create a Power Automate Flow to Sync Forms and SharePoint
Use Power Automate to trigger upon form submission, query the Office 365 directory for staff details, and log the complete record into SharePoint.
By integrating Microsoft Forms with the Office 365 Users connector via Power Automate, you can bypass the limitations of Forms and securely pull Active Directory details without requiring the user to type them out manually.
Set up your Microsoft Form to collect the necessary inputs (e.g., temperature). Then, create a SharePoint List with dedicated columns for Name, Email, Job Title, Temperature, and Submission Time.
Log in to Power Automate and click 'Create' > 'Automated cloud flow'. Name your flow, select 'When a new response is submitted' as the trigger, and choose your previously created Microsoft Form from the dropdown.
Click 'New step' and search for 'Get response details'. Select your Form ID again and insert the 'Response Id' using the dynamic content pop-up.
Add another step and select the 'Get user profile (V2)' action from the Office 365 Users connector. In the 'User (UPN)' field, map the 'Responder's Email' dynamic content retrieved from the form.
Add a final step and search for 'Create item' under the SharePoint connector. Enter your Site Address and List Name. Map the dynamic content to your columns: place the Form's output in the Temperature column, and use the Office 365 Users output for Name, Email, and Job Title.

Need a Simpler Way to Manage Form Data? Try WPS Office
While Power Automate and SharePoint offer extensive enterprise features, they can be complex to configure. WPS Office provides a lightweight, highly compatible alternative for everyday data collection and spreadsheet management. Create interactive forms natively with WPS Form and seamlessly sync responses to WPS Spreadsheets without complex workflow coding.
- 1. Download WPS Office: Visit the official WPS website and download the free installer for your operating system.
- 2. Install the Software: Run the setup file and follow the on-screen instructions to install the full suite.
- 3. Use WPS Form and Spreadsheet: Launch WPS Office and explore the Form tool to start collecting data directly into your spreadsheets.

Frequently Asked Questions
Can I retrieve custom Active Directory attributes with Power Automate?
Yes, the standard Office 365 Users connector pulls default fields like Job Title and Department. To retrieve custom attributes configured by your organization, you may need to utilize advanced Azure AD connectors.
Why is the Responder's Email showing up as anonymous in my flow?
If your Microsoft Form settings are set to 'Anyone can respond', it will not capture the logged-in user's email address. To fix this, open your form settings and select 'Only people in my organization can respond', ensuring the 'Record name' box is checked.
How do I format the email address as a clickable mailto link in SharePoint?
Navigate to your SharePoint list settings, select the email column, and change its type to 'Hyperlink or Picture'. When Power Automate populates this field, it will automatically render as a clickable link.




