News and Announcements icon

Power Platform CommunityForums Power Automate - General Discussion Matching date format b...

Power Automate - General Discussion

Answered

Matching date format between Form and Excel

Like (0) Share

Report

Report

Posted on 11 Dec 2018 06:40:38 by mikhail_matveev

15

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')

All responses Img

All responses (4)

Answers Img

Answers (1)

Verified answer

mikhail_matveev 15 on 23 Dec 2018 at 04:41:55

Like (1)

Report

Re: Matching date format between Form and Excel

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.
mikhail_matveev 15 on 23 Dec 2018 at 02:56:21

Like (0)

Report

Re: Matching date format between Form and Excel

Guys, any ideas?
mikhail_matveev 15 on 11 Dec 2018 at 10:04:54

Like (0)

Report

Re: Matching date format between Form and Excel

Hi @v-yuazh-msft,

thank you for answer, screenshot in attachments. I can't choose format for Key column
v-yuazh-msft on 11 Dec 2018 at 09:45:03

Like (0)

Report

Re: Matching date format between Form and Excel

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

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Announcing our 2025 Season 2 Super Users!

Quick Links

Leaderboard > Power Automate

#1

Tomac 986 Moderator

#2

stampcoin 699 Super User 2025 Season 2

#3

Riyaz_riz11 577 Super User 2025 Season 2

Last month Overall leaderboard

Featured topics

How to Ask for Help with Your Power Automate Workflow

Product updates

Microsoft Power Platform Community release plans