Extracting name from form

[pmthompson_55]

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

[Cookistador]

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]

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

[speedramps]

This the Power BI forum.

Not the Power Automate forum.

You will get quick and better answers if you use the correct forum.

This video may help you ...
https://www.youtube.com/watch?v=c599wKDaNEE