cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
K369
Resolver II
Resolver II

send email when combobox value changed

Hello all,

I have a combobox with SP list choices as "Open" , "Closed".

When I change selection of combobox to "Closed" I want "Button1 selected which has code for sending email.

Is it possible?

Essentially what I am trying to achieve is , if user changes value of combobox to "Closed" , an email is sent.

Thank you in advance.

Regards

 

2 ACCEPTED SOLUTIONS

Accepted Solutions

Something like

If(ComboBoxSample.Selected.Value = "Closed", Office365Outlook.SendEmailV2("You@youremail.com", "your subject", "message in the body"))

 

You will need to the add the outlook connector to use the outlook send email function.

View solution in original post

Hi KennyJ

Apologies for a late reply.

Your solution works very well and I have modified a bit. So big thank you to you.

Again very sorry for a late reply

Kind regards

View solution in original post

4 REPLIES 4
KennyJ
Resolver I
Resolver I

Hi, 

couple of different ways you could do this.

If the user updates the record and Patches back the updated record you could do an if statement to check the value and then send out the required email on the same button click for the patch.

You could also use Power Automate for when records are modified which on runs when the result of the field is closed.  

Thank you KennyJ

Is it possible to give me some guidance on IF statement please

Something like

If(ComboBoxSample.Selected.Value = "Closed", Office365Outlook.SendEmailV2("You@youremail.com", "your subject", "message in the body"))

 

You will need to the add the outlook connector to use the outlook send email function.

View solution in original post

Hi KennyJ

Apologies for a late reply.

Your solution works very well and I have modified a bit. So big thank you to you.

Again very sorry for a late reply

Kind regards

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

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.

Users online (1,274)