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)

Suggested answer

David_MA 12,982 Super User 2025 Season 2 on at

Like (0)

Report

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

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,443 Super User 2025 Season 2 on at

Like (0)

Report

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

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

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,443 Super User 2025 Season 2 on at

Like (0)

Report
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