Forum Discussion

ElisaL94's avatar
ElisaL94
Copper Contributor
Jun 14, 2024

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 Excel.

How can this criterion be integrated into the evaluation?

Thank you and best regards.

forms

1 Reply

  • Rob_Elliott's avatar
    Rob_Elliott
    Silver Contributor
    Jun 14, 2024

    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)