Forum Discussion
How can I add the department to the evaluation of a Forms survey in Excel?
Hello, I conducted a survey using Forms and generated a corresponding dataset. For the evaluation, I also need the respective department of the participants as additional information for sorting in...
ElisaL94 as Forms cannot connect to Active Directory or anything else your best approach is to create a flow in Power that gets each response as it comes in. Then you'd have a Office 365 Users Get User Profile (v2) action based on the responder's email:
After that that you will be able to select Department from the dynamic content box to save into your Department column as well as the other data.
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)