cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ClarkyPA365
Resolver I
Resolver I

Sending Email with attachments from a Gallery

Hi,

I'm hoping someone can assist.

 

I have a gallery which contain results from a checklist. The information is stored in a Collection. The Checklist contains 13 scenario's which some may have an issue with.  

 

I want to send only those that have issues on an Email with information relating to what & where the issue is and possibly other bits of information.

 

Firstly is there away to distiguese between a 'Yes' & 'No' within a gallery.  Yes = Issue

Secondly I have tried to create an email using some formula from a Shane Young video which formats the email body in to nice segements

 

Office365.SendEmailV2(
"Email Address",  (This has been changed)
"Perimeter Check Issues",
Concat(
Perimeterissue,
"Building: " & Building & Char(10) &
"Area: " & Title & Char(10) &
"Comments: " & Comments & Char(10)
)
)

 

but the details displayed are on a constant line

Building: Ferguson Area: Emergency Exit Doors Comments: test Building: Ferguson Area: Ground Floor Windows Comments: Building: Ferguson Area: Secure Vehicle Compound Comments: test1

 

Any assistance would be welcomed

 

Chris

2 REPLIES 2
LRVinNC
Super User
Super User

First, as to formating your email, please take a look at this post I provided a while back for another user. https://powerusers.microsoft.com/t5/General-Discussion/Email-form-data-without-using-Flows-Form-data...

You can use HTML within your send email to format your email as you desired.  It is not difficult to do so with only very basic HTML commands.

 

As to determining Yes/No, you indicated there is a checklist in the  gallery.  You can check this control to see if the value is true and use it to control which items you include in your output.  Look at the post above and you will see how I created the HTMLEmail global variable and used if statements within the Set statement in order to format.  You can do the same to select which data is include and which is excluded as you assemble the output.

LRVinNC

------------------
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Hi,

I've managed to format the body of the email with the fields required.  Thanks for your suggestion.

I am now wanting to attach images taken from the camera to the email.
See image1 - This is my part of my check list.  (There are roughly 10 more of these which may require images to be taken)
All the information is sent to a collection.  I've sort of followed Shane Youngs video Email Multiple Attachments, but I struggling to implement this it to my application.

I have perfromed the solution and it works using blank screens but not sure where / how it works when i'm Collecting addtional information not just the images

Any idea?

 

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (1,957)