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@example.com" & &body='Email Body'))
Solved! Go to Solution.
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:firstname.lastname@example.org?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)
Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.
Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.
The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.
We are excited to announce a new way to share your ideas for Power Apps!