Answered

Store File content in a variable

(0) Share

Report

Posted on by JamesSnaps

187

Hi, I'm trying to work out if it's possible to store the content output of 'get file content' in a variable. Have been trying to do this in a string variable and then add an attachment to an email with the variable in the 'content' part of the attachment but the attachment is not able to be opened when I receive the email.

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (1)

ChristianAbata 8,953 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

hi @JamesSnaps you can apend the variables.

Was this reply helpful? Yes No
Verified answer

abm abm 32,985 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!

Hi @JamesSnaps

Try the below.

Next you need to append the array with filename and content

Finally add your attachments in your email.

Note: If you file content type is binary then convert it using base64() expression. Here in my example I am using CDS database which is already getting the document in base64 format.

Thanks

Was this reply helpful? Yes No
v-litu-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @JamesSnaps,

Could you please share the configuration of your Flow by screenshots?

I think the reason for the received email couldn't open the attachment is the content code format, you could refer to this similar post to learn how to convert the content into base 64 and try it again:

https://powerusers.microsoft.com/t5/Building-Flows/Send-mail-with-attachment-when-a-new-message-and-file-posted-in/m-p/493138

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
JamesSnaps 187 on at

Like (1)

Report
Copy link

Link copied!

Many thanks, just tested this and works like a treat. Did have to convert to base64, but that's easy enough. Much appreciated.

James

Was this reply helpful? Yes No
Gangula 77 on at

Like (2)

Report
Copy link

Link copied!

I'm facing a similar issue.
I would like to use a variable to add "File Content" in the "Create file in SharePoint" step.

But the "Dynamic Value" drop-down doesn't show the variable at all.

Was this reply helpful? Yes No
TValenzuela 3 on at

Like (0)

Report
Copy link

Link copied!

I wanted to reach out and see if you ever found a solution. I'm in the same boat where I've created the array variable, appended the file name and content to the array, but when I go to the file contents filed the dynamic content for the variable is not there.

Edit: It seems this solution works for email where you can have the attachments field utilize the array. However, using the array in other areas that are designated for "File Content" doesn't seem to work. If anyone has a particular solution for that I would love to hear it. Thanks!

Was this reply helpful? Yes No
abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @TValenzuela

Try to add a compose action step just above the step. Can you see the Dynamic content you looking for?

Thanks

Was this reply helpful? Yes No