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 withi...
developer
Lists
SharePoint Online
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