Flow does not find date in excel

(1) Share

Report

Posted on by Wishamaster89

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'

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Suggested answer

David_MA 14,354 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Wishamaster89 32 on at

Like (0)

Report
Copy link

Link copied!

Thanks but that didn't fix it. In excel the date is formatted as date which i assume is correct?

1 people found this reply helpful.

Was this reply helpful? Yes No
Chriddle 8,685 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Wishamaster89 32 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Wishamaster89 32 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Chriddle 8,685 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No