Send image from a collection

[pityman]

Hi,

i have a collection shore the image 

In the image 

Now the question is how can i send out the image from this collection to email?

Thankss!

[v-xiaochen-msft]

Hi @pityman ,

Please try this formula:

Office365Outlook.SendEmail("your email","Subject","Body",{Attachments:AddColumns(your collection.image, "Name", DisplayName, "ContentBytes", Value, "@odata.type", "")})

1\ This is my collection 'Test2'.

2\ Add a button control and set its onselect property to:

3\ The result is as follows:

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

[pityman]

Thanks for your reply.

I would like to send the pic in html body instead of attachments

However, it seems like there is some error

Is it possible if i select the image with the title "Before....." and put in new column ?

I am only able to select the first image and put it in collection
After:First(ThisItem.Attachments).AbsoluteUri

[v-xiaochen-msft]

Hi @pityman ,

Please use 

AddColumns(First(FilteredCollection).image………….  instead of AddColumns(FilteredCollection.image

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

[pityman]

Hi @v-xiaochen-msft 

It works for the first row. However , i have several rows in the collection need to send out as well.

My idea is to create a table in html body and attach the image

Is there any way to do it? also i need to put the before image and after image in the correct column

[v-xiaochen-msft]

Hi @pityman ,

Please refer to the steps below:

1\ This is my test collection ’Test2’.

2\ Add a button control and set its onselect property to:

Office365Outlook.SendEmail("your email","Test", Concatenate("<table style=""width:100%"">

  <tr>

    <th>BBB</th>

    <th>image</th>

   

  </tr>" , Concat( ForAll(Test2,"

  <tr>

    <td>"&ThisRecord.BBB&"</td>

    "&Concat( ForAll(ThisRecord.image,"<td><img src="""&ThisRecord.AbsoluteUri&"""</img></td>"),Value)&"

  </tr>

"),Value),"</table>"),{IsHtml:true})

3\ The result is as follows:

Best Regards,

Wearsky

If my post helps, then please consider Accept it as the solution to help others. Thanks.

[pityman]

Hi @v-xiaochen-msft ,

Thank you for your reply.

I received the url instead of the image. May i seek your advice?

[v-xiaochen-msft · Accepted solution]

Hi @pityman ,

Please try to delete </img .

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

[pityman]

Hi @v-xiaochen-msft 

it works after i changed the code to 

In my image I have "before" and "After". is it possible to lookup the before image and put it in the same column?

[pityman]

Thanks @v-xiaochen-msft 

is it possible to put the image in the correct column based on the Display Name?

Example:

The Display name starts with Before will put in Finding Column whereas the display name starts with After will put in Rectification column