Concatanate gallery items into 1 email if ticked on check box

[kORINNERB]

Hi,

I am tryong to send 1 email to include all the ticked items in the gallery using the below formula, however, it still sends a seperate email per gallery item, is there a way rather than a seperate email but to put only the checkbox ticked gallery items into the email only as one email listing per gallery item thats ticked in the 1 email when it sends?

ForAll(Filter(
Gallery2.AllItems,
Checkbox3.Value= true
), Office365Outlook.SendEmailV2(Label7.Text,"QHSE Audit - Non Conformance"&" "&"-"&" "& Dropdown1.Selected.Result &" "&DatePicker1.SelectedDate &" "&"Audit ID"&" "& Label8.Text,"Hello"&" "&"<br>"&"<br>"&"Following our audit at the below site today, Please see below details for non-conformances:"&"<br> "&" <br>"&"Location:"&"<br>"&Label11.Text & "Category:" & " " & Category & "<br>" & "Location:"&"<br>"& Label11.Text & "<br>"&"<br>"&"Review Item:"&" " & 'Review Items ' & "<br>" &"<br>" &"<br>"&"Category:"&"<br>"&Title&"<br>"&"<br>"&'Statutory '&" "&"Non Conformance Details:"&"<br>"&TextInput4.Text&"<br>"&"<br>"&"Statutory Non-Conformances must be addressed within 7 working days of issue, with Non Statutory Non-Conformances addressed within 30 days of issue. All evidence must be provided, via email with the Audit ID number in the subject, to the Auditor for review and closure."))

[timl · Accepted solution]

Hi @kORINNERB 

You could try collecting the HTML text that pertains to each selected gallery item into a collection, and you can then concat the HTML text and send it in a single email. The formula would look something like this:

ClearCollect(colItems,
             AddColumns(
                        Filter(
                               Gallery2.AllItems,
                               Checkbox3.Value= true
                        ),
                        "HTMLBodyText",
                        "Hello"&" "&"<br>"&"<br>"&"Following our audit at the below 
                        sitetoday, Please see below details for non-conformances:"&
                        "<br> "&" <br>"&"Location:"&"<br>"&Label11.Text & "Category:" 
                        & " " & Category & "<br>" & "Location:"&"<br>"& Label11.Text & 
                        "<br>"&"<br>"&"Review Item:"&" " & 'Review Items ' & "<br>" &
                        "<br>" &"<br>"&"Category:"&"<br>"&Title&"<br>"&"<br>"&'Statutory '&"
                        "&"Non Conformance Details:"&"<br>"&TextInput4.Text&"<br>"&"
                        <br>"&"Statutory Non-Conformances must be addressed within 7 
                        working days of issue, with Non Statutory Non-Conformances addressed
                        within 30 days of issue. All evidence must be provided, via email 
                        with the Audit ID number in the subject, to the Auditor for review
                        and closure."
               )
);
Office365Outlook.SendEmailV2(Label7.Text,
                            "QHSE Audit - Non Conformance",
                            Concat(colItems,HTMLBodyText)
)

[kORINNERB]

Hi Tim,

Thank you for the quick response, i have tried teh above and although when i put the formula in the on select section of the button, when i press the button it errors with a red cross on the button fo some reason and seems to be this part of the formula underline red

Office365Outlook.SendEmailV2(Label7.Text,"QHSE Audit - Non Confrmance",Concat(colItems,HTMLBodyText
))

[timl]

Hi @kORINNERB 

The first thing I would check is - if you go to the File > Collections menu, can you see if the formula correctly builds colItems and that you can see the HTMLBodyText field?

[kORINNERB]

It is, see screen shot below

The part where the error is seems to be in the send email part of the formula

[kORINNERB]

Hi, dont worry found the issue, it eas to with Label7 where the to field is on the send email but have fixed it now and is working - thank you for your help!