Dynamic Content

[Ciarlies]

Hello--I am trying to add a row into a table once a form is submitted. Everything is fine, except my table is not pulling in the start time a user began filling the form, nor the user name...(see image). The option for Start Time and Name are not available as dynamic content. Does anyone know an expression that would work to give me the start time a user began filling a form, and an expression to pull the name of the user filling the form? Or some other way to get this data to populate in the excel spreadsheet. All other data fields populate as expected, thanks to the dynamic content! 

[Expiscornovus · Accepted solution]

Hi @Ciarlies,

As far as I am aware the response details action will only show the responders' email, submitdate and the answers to the different questions. 

{
  "responder": "dennis@contoso.onmicrosoft.com",
  "submitDate": "8/2/2021 2:39:26 PM",
  "r45eaa07074ac43cf9efb797fd51b091d": "A"
}

I believe the start time isn't recorded. That's why you are not seeing it as dynamic content.

Name also doesn't show up because of that reason. However, you can use the e-mail to retrieve that information. This approach will only work for people within your organisation who are submitting the forms. 

You can use a Get user profile action to retrieve the Display Name of the user. Below is a screenshot of that approach.

[Ciarlies]

@Expiscornovus 

Thank you for your response! I did go in and use a Get user profile action to retrieve the Display Name of the user. This solution will be sufficient! The Microsoft form does seem to capture a start time, as well as a completion time, as can be seen in the form responses, excel spreadsheet. (ex below).

I'm marking this question as solved -- might revisit the start time item at a later date. 😊 Start/Completion Times

[Expiscornovus]

Hi @Ciarlies,

Happy to help. And you are right, Microsoft Forms does capture this data and it will also show up in the related Excel sheet.

However, the connector you are using is a bit limited and isn't using all those fields. And that is why it is not showing up as dynamic content.

I have found a Power Automate Idea which you can upvote. Maybe they will include it in a newer version of the action when the idea get enough votes:

https://powerusers.microsoft.com/t5/Power-Automate-Ideas/Get-quot-Name-quot-quot-Start-time-quot-quo...