Unanswered

Sending Email with 2 Collections and Signature Image

(0) Share

Report

Posted on by Dave-ITMan

Hi Experts,

I have multiple collections of images being taken at different stages of the app, the new collection is named ColCameraImages and I need to add this collection to the code I already have OnSubmit (see below trimmed down code) to send an email, how can I add this new collection (ColCameraImages) as well as the existing (colImages) collection please?

ClearCollect(
 colImages,
 AddColumns(
 RenameColumns(
 'AttachmentControl-1'.Attachments,
 "Value",
 "ContentBytes"
 ),
 "@odata.type",
 ""
 ),
 {
 Name: "Signature.jpg",
 ContentBytes: 'Signature-1'.Image
 }
);

Office365Outlook.SendEmailV2('Lbl-AllEmailAddresses' , 'Result-Job-Number'.Text , "Hi,<br><br>

Please see completed form below and attached photos<br><br>

<b>Classification: </b>"&'Dropdown-Classification'.Selected.Value&"<br>
<b>Date Identified: </b>"&'Date-Created'.SelectedDate&"<br>
<b>Status: </b>"&'Dropdown-Status'.Selected.Value&"<br>
<b>Date Closed: </b>"&'Date-Closed'.SelectedDate&"<br>
<b>Time Identified: </b>"&'Result-TimeIdentified'&"<br><br>

<b>Notes: </b>"&'Notes-1'&"<br><br>

<b>Unique ID: </b>"&'UniqueRefNum-1'&"<br><br>

Regards<br><br>

Company<br></br>",
 {Attachments: colImages}
);

Thanks in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Dave-ITMan ,

Please try to use ForAll function.

ClearCollect( colImages, AddColumns( RenameColumns( 'AttachmentControl-1'.Attachments, "Value", "ContentBytes" ), "@odata.type", "" ), { Name: "Signature.jpg", ContentBytes: 'Signature-1'.Image } ); ForAll(ColCameraImages,Collect(colImages,{Name:ThisRecord.<field1>,ContentBytes:ThisRecord.<field2>})); ...

Best Regards,

Wearsky

Was this reply helpful? Yes No
Dave-ITMan on at

Like (0)

Report
Copy link

Link copied!

Hi @v-xiaochen-msft

Thank you for this, can you confirm what the Name:ThisRecord.<field1>,ContentBytes:ThisRecord.<field2> is referring too please? I'm not sure which fields I need to change ThisRecord and field1 and field2?

Many thanks

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

Like (0)

Report
Copy link

Link copied!

Hi @Dave-ITMan ,

Generally, it's your file name column and file content column from your first collection.

Best Regards,

Wearsky

Was this reply helpful? Yes No