get file content using file system failed

(0) Share

Report

Posted on by julijazas

820

I have esatblished connection to my file server

I am using a File system trigger when a file is created.

in second step i try to use get file content and i point out List of file names from trigger action

When flow hits trigger action completes succesfulty but get file content fails with error message:

here is no file with name 'aaa.xlsx' located in '' on your file system. Verify the file exists or create it before trying to access it.
clientRequestId: 66e5741f-15a7-4958-821e-d9dd2f64c2fb.

Very strange because it find file name but says it does not find.

My goal when files will be created in that folder flow takes the files then substracts first 3 letters from the file name in this case aaa and then i will send these files as attachment to users aaa@companyname.com for each user individualy

Categories:

General topics

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Jay-Encodian 2,920 on at

Like (0)

Report
Copy link

Link copied!

Hi @jja

Could you please share your Flow to enable us to review please?

I'd expect your Flow needs to do the following:

1. Fire when a new file is added

2. Retrieve the 'document content' using the identifiers from the trigger action

3. Retrieve the 'document metadata' using the identifiers from the trigger action

4. Send the email

4.a. Attachment name: Use an expression to pass in the 'filename' obtained from step 3 and rename as required.

4.a. Attachment content: Pass the file content obtained from step 2

HTH

Jay

-------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved.

If you like my response, please give it a Thumbs Up

Was this reply helpful? Yes No
julijazas 820 on at

Like (0)

Report
Copy link

Link copied!

Hi @Jay-Encodian
I have already achieved by getting metadata and content using identifiers.

Now i am stuck how to make correct file send to correct recipient
lets say i have file aaa.xlsx and bbb.xlsx of cource later it will be like 50 files with this unique letters that represent users email.

How do i send file aaa.xlsx to aaa@company.com and bbb.xlsx to bbb@company.com

Was this reply helpful? Yes No
Jay-Encodian 2,920 on at

Like (0)

Report
Copy link

Link copied!

Hey @jja

Here you go:

Expression: concat(split(variables('Filename'),'.')[0],variables('DomainName'))

Obviously you'll need to change the variables you pass in as needed

HTH

Jay

-------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved.

If you like my response, please give it a Thumbs Up

Was this reply helpful? Yes No
julijazas 820 on at

Like (0)

Report
Copy link

Link copied!

Hi @Jay-Encodian

Thanks and what about send email action.
how this step should look like?

Was this reply helpful? Yes No
Verified answer

Jay-Encodian 2,920 on at

Like (0)

Report
Copy link

Link copied!

@jja

Something like so... obviously you'll be using different actions to get the file metadata and content (File system actions) but the principles are the same.

HTH

Jay

-------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved.

If you like my response, please give it a Thumbs Up

Was this reply helpful? Yes No
julijazas 820 on at

Like (1)

Report
Copy link

Link copied!

Hi @Jay-Encodian
Thankns it works. First i was confused that it reads only one file but i see it runs a separate flow for each file created

Was this reply helpful? Yes No