Forum Discussion

Ttaylor1114's avatar
Ttaylor1114
Copper Contributor
Aug 26, 2021
Solved

Auto-populate a name column based on O365 email address

I have a Microsoft form that stores the information in a Sharepoint list through a power automate flow (new surveys are appended as rows to the list).

 

All the people completing the form are within our organization with a 365 email. Is it possible to auto-populate a Name column based on the email address? 

 

Thank you!!

developer
Lists
SharePoint Online

4 Replies

Sort By
  • RobElliott's avatar
    RobElliott
    Silver Contributor
    Aug 27, 2021

    Ttaylor1114 yes it is; add an Office 365 Users get user profile (v2) action and populate it with responder's email from the dynamic content box. Then in your SharePoint create item  action, for the name column you can either select Display name or given name (then a space then) surname from the get user profile (v2) section of the dynamic content box.

     

    Rob
    Los Gallardos
    Microsoft Power Automate Community Super User

     

     

    • RyhYun's avatar
      RyhYun
      Copper Contributor
      Oct 04, 2022

      Can the person's name & email (who receive the survey link) be auto populated when they take the survey? This person is not in my organization. RobElliott 

      • RobElliott's avatar
        RobElliott
        Silver Contributor
        Oct 04, 2022

        RyhYun no, that is not possible. Nothing can be pre-populated in Forms.

         

        Rob
        Los Gallardos
        Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

Resources