cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
FlatFish
Helper I
Helper I

Sending an email using a sharepoint list and dropdowns

Hi everyone, 

 

I have multiple dropdowns that a user can select, all options are in a sharepoint list that has specific columns called Email body and email subject. I want to send an email with a button to specific users that are constant, but the body and subject varies depending on the selected items in the dropdown.

 

This is what I have that does not work. How would I go about modifying this so when this button is clicked it opens up outlook and populates the subject/body accordingly

LookUp(LookupTable,User = userSelectDropDown.Selected.Title && 'Bank Names' = bankSelectionDropDown.SelectedText.Title && 'Account Option' = accountOptionDropDown.Selected.Title && 'Bank Account type' = bankAccountTypeDropDown.Selected.Title,Launch("mailto:email@email.com" & &body='Email Body'))

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-bofeng-msft
Community Support
Community Support

Hi @FlatFish :

please try:

Launch(
  "mailto:email@email.com",
  {
   subject: "Subject", 
   cc: "bof@ss.com", 
   body: "Body"
  }
)

Best Regards,

Bof

View solution in original post

3 REPLIES 3
vwyankee
Helper V
Helper V

From what you describe I feel like you may have overcomplicated this. To have a button that creates an email draft from selected fields in the Power Apps form you could use something as simple as:

Luanch("mailto:recipients@yourdomain.com?subject="&DropDownControl01.selected.value&"Whatever else for the subject&body="&DropDownControl02.selected.value&"whatever else you want in the body")

 

If you need to do lookups based on what is selected in the Power Apps form you can insert those in there as well, but it all needs to be within your Launch operator. You can also create a variable for the whole html string and then after use it in your Launch operator - Launch("mailto:"&varMailtoString)

v-bofeng-msft
Community Support
Community Support

Hi @FlatFish :

please try:

Launch(
  "mailto:email@email.com",
  {
   subject: "Subject", 
   cc: "bof@ss.com", 
   body: "Body"
  }
)

Best Regards,

Bof

Thank you so much @v-bofeng-msft that is exactly what I needed!

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on June 15, 2022 at 8am PDT.

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Top Kudoed Authors
Users online (1,950)