Skip to main content

Notifications

Power Automate - General Discussion
Answered

Matching date format between Form and Excel

(0) ShareShare
ReportReport
Posted on by 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')

 

Flow2018-12-11_143645.jpgFlow2018-12-11_143848.jpg

  • Verified answer
    mikhail_matveev Profile Picture
    mikhail_matveev 15 on at
    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 Profile Picture
    mikhail_matveev 15 on at
    Re: Matching date format between Form and Excel

    Guys, any ideas?

  • mikhail_matveev Profile Picture
    mikhail_matveev 15 on at
    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

    Flow2018-12-11_180416.jpg

  • v-yuazh-msft Profile Picture
    v-yuazh-msft on at
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,434

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,722

Leaderboard