Dynamic content not showing in Add a row into a table

[schendelsworld]

Hi there, new to Power Automate so I hope I ask the question correctly.

I am trying to get response data from a MS Form to a Workbook in SharePoint.  I've created this Flow...

When a new response is submitted -> Get response details -> Add a row into a table.

I can successfully get SOME of the data from the Form into the Workbook, but there is some data I can't get to carry over.  As I am adding Dynamic Content, not all of the response details that are in the Form show up.  Specficially, in my case, the data collected in Name and Total Points (as data this is coming from a Quiz Form) and I just can't figure out why those two items are not showing up as Dynamic Content.

 

[trice602]

Hi @schendelsworld ,

Are you asking for the Name in the quiz (as in an actual question) or wanting to dynamically get the person's name?

To get the person's name you use Get User Profile (V2) and the dynamic content here is the responder's email; this will pull back the details of the responder, including first and last name.

The quiz total is going to require some math here.  You will need to create an if statement in an a compose action for each question and assign a score for each question, and add all them together for a score total.  That said, if my reply works to solve your name value question, please mark this as a solution and create a new question specifically based on quiz points/totaling.

[Hyzerberg]

I second the question about where you're getting the Name from. If you have some details showing up in the dynamic content, I would presume that you're expecting the Name to be pulled from the details of the user profile. The details in @trice602's post above will get you far along your way.

[schendelsworld]

That doesn't exactly answer what I'm asking.  The Form *should* (at least with my limited understanding) already have the score data.  When I am in the Form itself, and export results to a spreadsheet, it includes the numerical score.  The problem is, when I pull up this Form in the Flow of Power Automate, the Dynamic content for that field isn't there; but it is for almost all the other data fields.  

(Honestly, I can live without the Name if I had to because the email address IS coming through and that is the record number that I can cross-reference later and retrieve the name from an exiting list.)