Unanswered

Random File.ReadFromCsvError error when running a Power Automate Desktop flow in unattended mode.

(0) Share

Report

Posted on by waltz313

If i manually run the process in PAD it is perfect every time, but when i run via a scheduled Power Automate Cloud flow, it is hit and mis, full error is:

Problem while executing action 'ReadCSV'. Import failed. Error while parsing

Microsoft.PowerPlatform.PowerAutomate.Desktop.Actions.SDK.ActionException: Import failed. Error while parsing ---> System.IO.FileNotFoundException: Could not find file 'C:\Users\#######\#####\Business Intelligence - Power Automate\Unpaid Direct Debits\Test.csv'.
at Microsoft.VisualBasic.FileIO.TextFieldParser.ValidatePath(String path)
at Microsoft.VisualBasic.FileIO.TextFieldParser.InitializeFromPath(String path, Encoding defaultEncoding, Boolean detectEncoding)
at Microsoft.Flow.RPA.Desktop.Modules.File.Actions.ReadFromCSVFileAction.Execute(ActionContext context)
--- End of inner exception stack trace ---
at Microsoft.Flow.RPA.Desktop.Modules.File.Actions.ReadFromCSVFileAction.Execute(ActionContext context)
at Microsoft.Flow.RPA.Desktop.Robin.Engine.Execution.ActionRunner.Run(IActionStatement statement, Dictionary`2 inputArguments, Dictionary`2 outputArguments)

i have hashed out parts of the path but they are correct (tested by creating a shortcut directly from the path and it opens). The issue i have is that, in unattended mode, it sometimes works but regularly fails.

Categories:

Power Automate Desktop

All responses (3)

Answers (0)

Sort by

CU16071609-1 6,255 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@waltz313

Error says file is not exists in the given path "C:\Users\#######\#####\Business Intelligence - Power Automate\Unpaid Direct Debits\Test.csv".

It's advisable to condense the file path, reducing its length (if its lengthy), and ensure to check if the file exists before attempting to open the URL. and also add some wait duration

If possible share some screenshot of your flow, so that we can understand bit deeper on the reported issue.

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀
Jacksonong2020 21 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

I have the same issue. The file exists and in there, when I use attended bot the files runs correctly, but when it run unattended, the file cannot be found.

I have already added a file check to check if file exists, and put in a delay loop to wait until file exists.

there is no error if I were to run it attended, only unattended the file cannot be found. File path is also not long, the file is on sharepoint folder.
Jacksonong2020 21 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi all,

I found out the problem with unattended machine. For Excel file, the open excel function on power automate desktop will wait for the file to be loaded and downloaded from sharepoint, but CSV, the files doesnt wait for the file to arrived.

Solution : On the folder that the bot is reading, always Keep on this device.