Matching date format between Form and Excel

[mikhail_matveev]

Hi everyone, 

I'm trying to create Flow to get data from Flow and find this row in excel with this row 🙂

The problem is when I use datetime for "Key Value" it says that value is not found, I've tried to change date format but it didn't give result, 

any ideas?

I use this formula to convert data: 

convertTimeZone(body('Get_response_details')?['submitDate'],'UTC','Singapore Standard Time','dd/MM/yyyy h:mm:ss tt')

[v-yuazh-msft]

Hi @mikhail_matveev,

Could you please share a screenshot of the configuration of your flow?

If you compare the response submit time (with Precise time, minute and second) with a date time in the excel table, I afraid that no date time in the table would meet the same Precise time, minute and second.

You could take a try to compare the response submit time (with Precise year,month and date) with a date time in the excel table.

Best regards,

Alice

[mikhail_matveev]

Hi @v-yuazh-msft,

thank you for answer, screenshot in attachments. I can't choose format for Key column

[mikhail_matveev]

Guys, any ideas?

[mikhail_matveev · Accepted solution]

I found solution, Excel return date in number format, means that for 23/12/2018 it will be 43457, in same time Form gives date in timestamp. So, to get result you need to convert nuber 43457 to timestamp format.