Answered

Help with Write to File

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I'm trying to use "Get file path part" and extract just the file name without extension.

I want to send this list of file names to a .txt somewhere on my agency's filestore, but I keep getting the same error when trying to target both the shared drive and local file structure:

Microsoft.Flow.RPA.Desktop.Robin.SDK.ActionException: Invalid directory specified ('Access to the path 'C:\Users\jakso\Desktop\test location\CSV Home' is denied.') ---> System.UnauthorizedAccessException: Access to the path 'C:\Users\jakso\Desktop\test location\CSV Home' is denied.
at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost)
at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost)
at System.IO.StreamWriter.CreateFile(String path, Boolean append, Boolean checkHost)
at System.IO.StreamWriter..ctor(String path, Boolean append, Encoding encoding, Int32 bufferSize, Boolean checkHost)
at System.IO.StreamWriter..ctor(String path, Boolean append, Encoding encoding)
at Microsoft.Flow.RPA.Desktop.Modules.File.Actions.WriteTextToFileAction.Execute(ActionContext context)
--- End of inner exception stack trace ---
at Microsoft.Flow.RPA.Desktop.Modules.File.Actions.WriteTextToFileAction.Execute(ActionContext context)
at Microsoft.Flow.RPA.Desktop.Robin.Engine.ActionRunner.RunAction(String action, Dictionary`2 inputArguments, Dictionary`2 outputArguments, IActionStatement statement)

Can someone explain what I'm doing wrong?

Thank you!

Categories:

Power Automate Desktop

I have the same question (0)

All responses (4)

Answers (1)

Sort by

VJR 7,635 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Anonymous

I was able to write just the file name without extension to a Text file without any issues.

The error message in your post is showing as below
Invalid directory specified ('Access to the path 'C:\Users\jakso\Desktop\test location\CSV Home' is denied.)

1. When do you get this error? On which action?
2. Can you check if you have access to C:\Users\jakso\Desktop\test location\CSV Home
3. Some do not have access to create anything on Desktop through automation processes. Check if you are able to create the text file on some other path that does not include the default windows folders (like Desktop, My documents, Users, etc)
3. Can you also manually try to create a Text file on this location and see whether you are able to create it or not
4. Also share some screenshots of the PAD flow and also the contents of the action where you are getting the error.

Was this reply helpful? Yes No
MichaelAnnis 5,727 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

If you still can “get file path part” to work, you can use “get files” and for each file use the “%CurrentItem.NameWithoutExtension% property to get it where you need it to go.

Best of Luck!

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

My flow is made of 2 actions.
1. get the file path part so that there is data to write to the text file
2. write the data to a text file at the specified location.

I get the error mentioned in the OP when my flow tries to execute step 2. "Write text to file". I have access to every (non system locked like sys32) directory in the computer. I even have access to every directory I attempted in the shared drive. I haven't tried non default folders like you mentioned.

I'll take a screen shot of the error window if I still can't get it to write to a file in a non default directory.

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I made a text file in a folder tree under My Documents (the Windows default one) and inside that created text file in my newly created folder path I'm no longer getting OP's error.

I think what was causing the error originally is that I had targeted a folder path and not a file path. If you look at the folder path you'll note that it doesn't end in a file, it ends in a folder.

Changing the directory to look at a text file in my flow caused the flow to send text to that file, but not if the directory ends in a folder.

Was this reply helpful? Yes No