MS Forms into SPO List (people column) using Power Automate

[Kmmille25]

Hi Everyone, 

I'm new here, so please pardon my lack of proper terminology.

We are using an MS flow to automate the entry of information in an MS Form into an MS List. Everything works pretty well, but we encountered an issue that caused the Flow to fail multiple times yesterday. The form has a section to enter your name:

This information is mapped to the list here - specifically a 'people' column.

In our test runs, everything was fine - but we notice an odd issue.

Since the 'people' column references people within our o365 Tenant, if someone enters their name and it's slightly off from what's in AD, then the flow fails. For example, User Robert Williams enters his name, email address, phone - etc. The flow will fail because he's actually Robert R Williams in AD. Second example: Pete McDude enters his name, but it fails again because he's actually 'Peter McDude'. 

I'm sure I could just delete this column, format it to a single line of text, and avoid the issue altogether - but I like using the people column and for this application, it's a nice thing to have. The other thing I considered is that MS Flow automatically records the name of the user who submits the form. Is it possible to use that in the Flow instead of having the user type their name entirely?

Here's what the flow looks like:

[Caspar_Rubin · Accepted solution]

Hey,

you can simply use the dynamic value "Responders' Email" in the Person Claims Field.

SharePoint Person/Group fields Claims accept email values. 

Responders' Email is an automatic field and exists in every MS Form. You don't need those text fields that people have to fill out with their name, email or whatever.

Let us know if it works,

cheers

[Kmmille25]

Thanks, Caspar!

That's exactly what I was looking for. I tested it, and it works great. On a semi-related note, I changed the 'enter a date' to use the 'submission time' dynamic item. It works, but there doesn't seem to be anything in MS Forms that provides the actual time stamp that includes minutes or hours - only the shorthand date like 9/8/2022 instead of 09/08/2022 @ 3:12 PM EST.

Is there any workaround to get the actual 'time' something is submitted instead of just the date?

[Kmmille25]

Thanks, Caspar!

That's exactly what I was looking for. I tested it, and it works great. On a semi-related note, I changed the 'enter a date' to use the 'submission time' dynamic item. It works, but there doesn't seem to be anything in MS Forms that provides the actual time stamp that includes minutes or hours - only the shorthand date like 9/8/2022 instead of 09/08/2022 @ 3:12 PM EST.

Is there any workaround to get the actual 'time' something is submitted instead of just the date?

[Caspar_Rubin]

Hey,

what I usually do is use the "Convert time zone" action to format my timestamps and then use that dynamic value (Converted time) inside the rest of my actions.

For me, I have to use UTC as Source and my time zone (UTC+1) as Destination.

In Format String you can either use one of the pre-defined values or go to the bottom and select "Enter custom value" and enter your custom string. For example dd.MM.yyyy HH:mm

cheers

[Kmmille25]

Hi Caspar,

I was able to get the hours and minutes into the list using the time conversion - but for some reason, it's showing up as the wrong time.

Here's what it looks like:

The format looks good, but I'm on Eastern Standard Time so it's 12:56 PM and not 05:56 AM.

Then the Converted time is added as a dynamic item under the 'Create Item' action.

In the debug - it looks correct:

However, in the outputs:

It looks like it's bringing in the wrong value. I'm a bit confused on how to get this resolved.