Forum Discussion

Power12344's avatar
Power12344
Copper Contributor
Jun 17, 2024

MS Form Pre fill user name and email in text field

Is it possible to pre fill the text fields in MS form with logged in user name and email at the time of form filling.

3 Replies

  • Monion1295's avatar
    Monion1295
    Copper Contributor

    Power12344 

     

    I have managed to get around this feature using a power automate. 

     

    1. set up a SharePoint list with all the users you want to send the form to and all of the information you hold for them (name, department , email ect)

    2. generate a pre filled form with "#####" or any easily identifiable string. 

    3. Use dynamic content in power automate to replace the string.

     

    Then you can set up a flow that emails individual users with their dynamic link for completing the form. 

  • Rob_Elliott's avatar
    Rob_Elliott
    Bronze Contributor

    Power12344 if your responders are all internal to your organisation then Forms knows what their email address is. You can have a flow in Power Automate that gets each response and with the Office 365 Users Get Profile (v2) action with the input as the responder's email can get the rest of their details. We always do this for internal forms at my company and never have to ask the user for their name or email address and the details and form responses get saved by the flow into a SharePoint list for audit & backup reasons.

     

    Rob
    Los Gallardos
    Microsoft Power Automate Community Super User.
    Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)

  • Currently, there is no such support in MS Forms with the existing prefill feature.

Resources