Microsoft forms date picker response represented incorrectly in email

(0) Share

Report

Posted on by Henry G Smith

166

Hi,

I create a Microsoft forms originally starting from excel. One of the questions requires a start date (or specific date). I have created a flow that when it is two weeks out from that specific date an automated email is sent out to specific employees.

In that email I have the responses from the Microsoft form, including the answer/response of the date picker. Instead of reading as a normal date e.g. 01/01/2022 - the response is coming up as "Start Date: 44654"

Does anyone know why it is not showing the date but rather a bunch of random numbers?

This is the flow I made:

The 14 day compose is:

formatDateTime(addDays(utcNow(),14),'MM/dd/yyyy')

and the second compose is:

addDays('1899-12-30', int(item()['Start Date']), 'MM/dd/yyyy')

Hopefully someone can help out?

Regards,

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Henry G Smith 166 on at

Like (1)

Report

Re: Microsoft forms date picker response represented incorrectly in email

I found an alternative. I just used my compose date instead and it worked!

Was this reply helpful? Yes No
v-LilyW-msft on at

Like (0)

Report

Re: Microsoft forms date picker response represented incorrectly in email

Hi @DynamicsHS

Glad that you have resolved your problem.

Because Excel stores internally the dates as sequential serial numbers starting from 1900-01-00, so it shows the serial number in Flow.

You can select ISO 8601 in the Datetime Format field, then the dates will be listed in a format that is directly readable.

Then you can directly format this date in the format you want.

formatDateTime(items('Apply_to_each')?['Start Date'],'MM/dd/yyyy')

Best Regards.

Was this reply helpful? Yes No