Forum Discussion

pmthompson_55's avatar
pmthompson_55
New Member
1 year ago

Extracting name from form

Hi there, 

 

This is my first post and try to explain as clearly as I can :).

 

- I have built a form using MS Forms. In the settings, I have selected that only people from my organisation can respond and the 'Record Name' box is ticked.

- I have built a workflow in PowerAutomate, which takes the form answers and inserts the answers into a row in a spreadsheet.

- I cannot find how to add the name in (without manually asking someone's name in the form). The form allows me to add respondants email address but not name? (see screenshot attached).

 

So how can I add the respondand's name from the form into excel, without explictly asking for their name in the form?

 

Huge thanks in advance!!

 

Peter

4 Replies

  • Hello
    You are on Microsoft Fabric forum, but I could help you

    You have to use the Office 365 Users  connector  with the Get user profile (V2) action, you can pass the mail adress and it will retrieve the user name

     

    If you need more help, do not hesitate to ask 

     

    • pmthompson_55's avatar
      pmthompson_55
      New Member

      Hi Cookistador 🙂

       

      Thanks for your reply and sorry I've posted this in the wrong place!

       

      I've read the thread you sent over and am a little confused how I would add this code into my excel command. What code would I add in here?

       

      thanks

       

      peter