Power Platform Community Forum Thread Details

Data from Forms missing or incorrect

I have a few Power BI reports that draw on data from Forms. Since the excel fil connected to Forms now only updates if you open it manually, I am now building a workaround where Power Automate copies the answers into a new excel file (like this article suggestets), but here I run into two issues:

1) Missing data from Forms

In the original excel file there's a time stamp from when the respons was startet and the name of the person who answered, and these two data fields does not appear when I want to map the answers in Power Automate to the new file (see below).

I can still see the email address of the responder and I assume the name comes via that somehow, but I can't choose it as an independent data field. And the timestamp of when the respond was startet is just no where to be found. Is there a way, that I can map this to the new excel file?

2) Submission time 2 hours off

When I compare the submission time in the original excel file with the copy from Power Automate the latter is exactly two hours behind, see below in the third column.

I can't find any settings for timezone or anything that seems to affect this. How can I change this, and preferably in a way that automatically takes daylight saving time into account?

I hope someone can help! :)

Categories:

Business Process Flows

Hello@KS-19051150-0

So for the name, that one is easy. You can use the Get/Search User Profile with a filter on the submitters email using the office 365 user connector.

However, I must worn you that not all forms will have their name anyway as that can be turned off (just saying, not that you did it).

For the time

Run the flow in test mode.

Drop a form.

Open the Run

Go to the outputs of Get Response Details

Grab that and put it into a JSON Editor (so its formatted)

The data should be there, I am just not sure its exposed as a dynamic property so you need to find it, then use Parse JSON or json() to grab that value and you should have it.

now you have both pieces of data :-)

If this helps please mark the answer a such

Quick Links

Leaderboard > Power Automate - Building Flows