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
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

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

MPA Licensing.jpg

Ask your licensing questions at the Power Automate AMA!

Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.

Users online (1,605)