Get file content from previous step

[AK-47]

Hi, I am trying to get the content of the file in the previous step but no matter which approach I take the flow errors at this point. What is the correct way to read in the file content from the previous step without statically using a filename. This flow operates on a number of file names so I need it to remain dynamic.

Thanks.

[fchopo]

Hi @AK-47 

As I understand by your screenshot, you are creating files in SharePoint based on email attachments. So you could get the file content from the attachments, and not from the SharePoint item. Apart from that, you're copying a file from one SharePoint site to another, but this could be done by creating the same file in two different sites. Am I right?

Regards,

Ferran

[CFernandes]

Hey @AK-47 

You can use the "Id" output of the Create file action in the "Get File Content".

Please make sure you select the same site address in the Get File Content action that you have used in the Create file.

I did a test and it worked for me. 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[AK-47]

Not quite. File attachment from email is save to a Sharepoint library. I am trying to write out the .txt as a .csv in the same location.

[AK-47]

Thanks for the reply. I did try that but it error'd. Let me try again and come back to you.

[fchopo]

Could you explain in more detail which is the idea of the flow? I mean, you receive some txt files in an email, and want to save them in a SharePoint library with 2 different extensions (txt and csv)? Am I right?

Regards,

Ferran

[v-litu-msft · Accepted solution]

Hi @AK-47,

You could also try the Get file content by path action to approach that, for example:

 Best Regards,
Community Support Team _ Lin Tu

[AK-47]

Lots of great suggestions and questions so let me go a bit further on this.

That's correct. The saving of the txt attachment is fine. I am trying to extend that process now to rename the file. The rename option is limited to a boolean which is correctly set but it won't take file extension parameters. What I have determined is that I need to continue to save the attachment as .txt then read in the file content to copy out to a new file name with the .csv extension. The flow fires on multiple emails, with differently named attachments. Therefore the flow needs to be able to use the ID of from the previous step.

When using the Id the error is:

The destination path cannot be the same as the source object itself.

When using the Path it errors saying path not found even though the debug output is pointing to it.

 

[muralidharan]

Hi @AK-47 ,

I believe you're trying to use variables and use them in the subsequent steps. 

Regards,

Murali!

[AK-47]

Thanks for everyone's help. I worked it out. I was overcomplicating it. Marking @v-litu-msft  answer as correct since it was the correct part that was missing/wrong once I removed the junk out it.