When I a replace a file in onedrive my automation fails

(0) Share

Report

Posted on by JPey

I have an automation that relies on an excel spreadsheet (text.xlsx) in a onedrive folder (My files>Test).

There will only ever be one file in the folder at a time and it will always be named the same (test.xlsx)

When I replace text.xlsx with a new version, even with the same name, the power automate breaks down. I assume this is because power automate is not really using the file name in the following steps, but something else. How to I accommodate that I will be replacing text.xlsx frequently?

Thank you for your help!

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (0)

JPey 70 on at

Like (0)

Report

To clarify the next step is to create a table in the text.xls file

Was this reply helpful? Yes No
Rhiassuring 8,690 Moderator on at

Like (0)

Report

It is using the file name, and the location.

Can you show the configuration of your flow? You say it "breaks down". What do you mean by that? Is it not triggering?

Was this reply helpful? Yes No
JPey 70 on at

Like (0)

Report

When I run this flow and the file is already in the folder location, it succeeds. When I run the flow the first time it works. When I delete the original file and a new file with the same exact name, it fails. It continues to fail until I update the file in the CREATE TABLE section (even though it's the same name and path).

Was this reply helpful? Yes No
Rhiassuring 8,690 Moderator on at

Like (1)

Report

Try changing your settings on the action to Secure Input / Secure Output = Yes.

This has turned into my "turn it off and back on again" recommendation when it comes to Excel - it seems like Excel actions like to cache things.

Was this reply helpful? Yes No