cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Ciarlies
Frequent Visitor

Dynamic Content

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! Expressions.JPG

 

1 ACCEPTED SOLUTION

Accepted Solutions
Expiscornovus
Super User
Super User

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.

 

displayname_userprofile.png

View solution in original post

3 REPLIES 3
Expiscornovus
Super User
Super User

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.

 

displayname_userprofile.png

@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 TimesStart/Completion Times

 

Expiscornovus
Super User
Super User

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...

 

Helpful resources

Announcements
 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Users online (1,592)