Answered

Sending a mail based on choicebox

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello!

I have a multiple choice box and whenever the selected value equals "Vrijgegeven", I want to send a mail.

This is the code I've tried so far, it sends the mail without the if statement:

If(
 DataCardValue29.SelectedText.Value = "Vrijgegeven";
 Office365Outlook.SendEmail(
 "The email";
 "Nieuwe vrijgegeven manco";
 "Nieuwe vrijgegeven manco met bestandsnaam: " & DataCardValue12.Text
 )

Categories:

Building Power Apps

All responses (10)

Answers (1)

Sort by

mdevaney 29,993 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
@Anonymous
Can you please write this code and let me know if there are any options available other than Value? Your word Vrijgegeven might be stored under a different column name.

DataCardValue29.Selected.

Also, SelectedText is deprecated. You dont want to use this because it is being deleted from the PowerApps language. Instead you can simply use Selected.

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

It does say "Vrijgegeven". I just made a label with DatacardValue29.Selected.Value and it says that. So do you think if I use DatacardValue29.Selected it will work?

https://gyazo.com/8599ee3d818c9981d691c006f2d4b586

@mdevaney
mdevaney 29,993 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@Anonymous

No, that's not what I meant. Type this... then see what other columns Autocomplete suggests. My theory is you have the wrong column name.

DataCardValue29.Selected.

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

It only gives me the option "Value" @mdevaney
mdevaney 29,993 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@Anonymous
OK, as a test, please put this code in the Text property of a label and let me know whether it says true or false.

DataCardValue29.Selected.Value = "Vrijgegeven"

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

It indeed turns to true whenever I change the status to "Vrijgegeven" @mdevaney
mdevaney 29,993 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous

Perfect, then the problem is not the IF statement condition. The problem is your email code.

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Weird... Whenever I use the code without the if statement it works... Here is the code:

Office365Outlook.SendEmail("theemail";"Message";"Message)

I have this code on the OnSuccess off my form, maybe that is the problem?

@mdevaney
Verified answer

mdevaney 29,993 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
@Anonymous

Yes, that is 100% the problem. When the form submits it is likely clearing out your dropdown.

Use this idea instead...

If( Form1.LastSubmit.your_column_name = "Vrijgegeven"; Office365Outlook.SendEmail( "The email"; "Nieuwe vrijgegeven manco"; "Nieuwe vrijgegeven manco met bestandsnaam: " & DataCardValue12.Text )

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you so much 🙂

@mdevaney