Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

Flow does not find date in excel

(1) ShareShare
ReportReport
Posted on by 32
Hello
 
I am building a flow that takes figures from Power BI and writes it to a row in excel that is pre populated with todays date. I keep getting the following error message. In key value i have 
formatDateTime(utcNow(), 'dd/MM/yyyy')
 
I am just using hard coded variables at the moment before i try getting the figures automatically from power bi.
 
 
 
"message""No row was found with Id '14/08/2024'
  • Chriddle Profile Picture
    7,793 Super User 2025 Season 1 on at
    Flow does not find date in excel
    I don't recommend to change the Excel's data type.

    To identify the Excel row via "Key value" you have to use the number that represents the date in Excel.
    (Even if you have set DateTime Format to ISO 8601, which is always a good idea)
     
    To calculate the Key value, use the following expression:
    add(
    	div(
    		sub(
    			ticks('2024-08-17'),
    			ticks('1900-01-01T00:00:00Z')
    		),
    		864000000000
    	),
    	2
    )
    where '2024-08-17' is the date you are looking for.
     
     
  • Wishamaster89 Profile Picture
    32 on at
    Flow does not find date in excel
    I've  figured it out, i had to convert the dates in excel to text using the iso format. That has now solved the issue.
     
    Thanks for your help.
  • Wishamaster89 Profile Picture
    32 on at
    Flow does not find date in excel
    I have tried what David suggested but unfortunately the data flow is still failing.
     
     
     
    {
      "status"404,
      "message""No row was found with Id '2024-08-16'.
  • Chriddle Profile Picture
    7,793 Super User 2025 Season 1 on at
    Flow does not find date in excel
    What Excel shows you only has a marginal connection to how the data is stored internally and transferred to the Power Automate Connector ;)
    I would think again about @David_MA 's tip
  • Wishamaster89 Profile Picture
    32 on at
    Flow does not find date in excel
    Thanks but that didn't fix it. In excel the date is formatted as date which i assume is correct?
  • Suggested answer
    David_MA Profile Picture
    11,517 Super User 2025 Season 1 on at
    Flow does not find date in excel
    Try expanding the advanced options in the Excel action and choose ISO8601 date format. You will also need to format your expression to use the ISO8601 format as well, which is yyyy-MM-dd.

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

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 566 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 516 Super User 2025 Season 1

#3
stampcoin Profile Picture

stampcoin 492