Image column as attachments in email

[_maaaaavs_]

Hi. I was wondering if my Image column in sharepoint can be emailed as attachments in Power Automate? If yes, can you pls share some insights on how to do that. Thank you

[v-chengfen-msft · Accepted solution]

Hi @_maaaaavs_ ,

Through the link below,

How to get contents of an image column of SharePoint in Power Automate - Debajit's Power Apps & Dyna...

The above link uses serverRelativeUrl to obtain files, but this attribute can no longer be used directly.

So I changed my mind, I just need to fill in the corresponding file name under the corresponding folder, so that I can form a complete file path to get the file.

we can know that the image files in the image column will eventually be stored in Site contents in Site Assets/lists/. . . In one of the folders, the folder name is the ID corresponding to the sharepoint list

Here is a test for your reference:

I use【When an item is created】as a trigger.
[Send an HTTP request to SharePoint] used to obtain the file information of the image column

Obtain the file name from the return value of [Send an HTTP request to SharePoint] through the following formula

json(first(body('Send_an_HTTP_request_to_SharePoint').d.results)['Image column Name'])['fileName']

Here is result:

Best Regards

Cheng Feng

[_maaaaavs_]

Hi! Thank you for your reply. It is working but I have an issue. It says "We couldn't open the image file". Why is that? Thank you.

[v-chengfen-msft]

Hi @_maaaaavs_ ,

Can you show me your flow?
Judging from the content you provided, it is possible that the file cannot be recognized because the file name does not carry a suffix, so it cannot be opened.

Please use DisplayName

Best Regards

Cheng Feng

[_maaaaavs_]

Hi @v-chengfen-msft. I think I did it correctly. 

[v-chengfen-msft]

Hi @_maaaaavs_ ,

From the picture you provided, I have some problems:
First, the file name of this picture is very complicated, and there may be problems.
Second, the file content is only 1kb, is it the same size as the original file?

Can you show a screenshot of the flow you built?

Can you check the results of the flow execution play?

Like this,

Best Regards

Cheng Feng

[_maaaaavs_]

Hi, @v-chengfen-msft. This is the result of my flow.  

This is the email I'm getting. I'm not sure why the attachment is just 1kb.

[v-chengfen-msft]

Hi @_maaaaavs_ 

Please modify the body to the file content of [Get file content using path]

Best Regards

Cheng Feng

[_maaaaavs_]

Omg it's now working. Thank you very much!

[_maaaaavs_]

Sorry for asking questions too much. I also have another problem. Is there a way to send all attachments in a single email? As you can see, I added 2 new items in my sharepoint list. But I got 2 seperate email for each attachment. I just want them all to be in a single email. Is that possible? 

[Anonymous]

Hi @_maaaaavs_ and @v-chengfen-msft 

I'm wondering if any of you have found a solution to integrate the attachments in one email? Thanks for the further insights

[_maaaaavs_]

Yes, but I decided not to use flow on this one. What I did is by doing it inside powerapps using the SendEmail action. There's one video of Shane Young that uses collections as attachments. Here's the link. 

[Anonymous]

Alright. Thanks for the reference @_maaaaavs_ 

[Juli5854]

Hello, 

thanks for the "tutorial", it is working fine for me as well. 

Nevertheless, I have one question: 

The image is (and also should be) no mandatory field. Therefore, I need to implement a condition, that the flow is continued even there is no image in the image column. 

Do you have an idea how this condition could look like? 

Many thanks in advance!

Best regards, 

JS

[_maaaaavs_]

Hi! What do you mean? Can you give me more information about that?

By "mandatory", do you mean your image column in your data source? 

[Juli5854]

Hi, 
I meant that the user does not need to add a image and it is only an option. 
However, I was able to solve the problem now by myself.