cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AOZ
Helper III
Helper III

Get attachment content for a hardcoded image name in attachment column

Good day,

I am collecting some pictures and they are being saved in the attachment column of a sharepoint list, with a specific name.

 

 

 

Collect(
    ColImages,
    {
        DisplayName: "CloseUpShot1" & ".jpg",
        Id: "CloseUpShot1" & ".jpg",
        Value: Camera1.Photo
    }
    );

 

 

 

I am then trying to send an email via Flow to notify users that a new item has been added. I wish also to include the link to the item and also the link to the attachment.

AOZ_0-1626954929609.png

i am however getting an error - which i think is because i have hardcoded the name of the picture.

AOZ_1-1626954994994.png

AOZ_0-1626955896861.png

 

How can i proceed with this please?

Rgds,

Arshad

1 ACCEPTED SOLUTION

Accepted Solutions
eric-cheng
Solution Sage
Solution Sage

Hi @AOZ ,

 

Try the below flow. 

 

1. Get the ID of your list item.  I hardcoded it but you use Get Items and pass a filter. Lo

 

Screenshot_20210722-221829_Chrome.jpg

 

Screenshot_20210722-221859_Chrome.jpg

If you have multiple attachments, save them to an array first.  Refer here to my previous reply.

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

View solution in original post

6 REPLIES 6
eric-cheng
Solution Sage
Solution Sage

Hi @AOZ ,

 

Try the below flow. 

 

1. Get the ID of your list item.  I hardcoded it but you use Get Items and pass a filter. Lo

 

Screenshot_20210722-221829_Chrome.jpg

 

Screenshot_20210722-221859_Chrome.jpg

If you have multiple attachments, save them to an array first.  Refer here to my previous reply.

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Dear @eric-cheng 

It still says file not found...

 

AOZ_0-1626959310471.png

 

AOZ_1-1626959347337.png

 

AOZ_2-1626959381567.png

 

 

Hi @AOZ ,

 

Can you check the parameters of your Get attachment content against my screenshot?

 

Id - List Item Id

File Identifier - Id returned from Get File Attachments

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

 

Dear @eric-cheng 

Works fine!

Hello @eric-cheng 

I have succeeded in getting the attachment pictures inside the mail.

Can you just help me for getting all the pics in one single email?

I have used the array as you suggested, but i think something is missing since i am still receiving multiple emails with one picture each time inside the mail.

AOZ_0-1627020872317.png

 

Hi @AOZ ,

 

No problems. 

 

Please move the Send an email outside of the loop and it should only send 1 email at the end of the flow.

 

You will only need to append to the array inside the loop.  Once the loop finishes, you will have a list of all attachments and you can just send it.

 

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

 

 

Helpful resources

Announcements
Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (1,833)