Unanswered

Depending on a selection send an Email template to specific recipitant

(0) Share

Report

Posted on by Chris1968

1,154

Hi,

I would like to send an email which will be slightly different depending on a selection made.

So if employee selected the email will display in the body different information to that if manager is selected.
The manager email address is displayed with the formula using HTML text.

Currently this information does not appear in a Datasource (SharePoint) so was wondering if this can be actioned directly from the link in the Powerapp??

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (0)

Sort by

sgtsnacks64 322 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Clarky,

Can you share a little more on what you're trying to achieve with this?

> Is the selection based on the type of employee, or is something like a toggle option between Employee and Manager
> What changes are made to the template between Manager and Employee?

I'd be looking to set a variable with each template based on the type of employee, like:

Set(gblEmlTemplate, If(Type.Employee,"<a>Employee Template</a>","<a>Manager Template</a>"))

Was this reply helpful? Yes No
Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

You can do a condition in the "default" of the power app:

If(User().Email = ManagerEmail,

TEXT FOR THE MANAGER HERE,

TEXT FOR USER HERE

)

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,

Gonçalo Nogueira

Check my LinkedIn!

Buy me a coffee!

Check my User Group (pt-PT)!

Last Post on Community

My website!

Was this reply helpful? Yes No
Chris1968 1,154 on at

Like (1)

Report
Copy link

Link copied!

Hi,

It's based on an absence app and if the employee as Covid or not.

If Covid is selected, via a toggle, then the body of the email template will contain different information than if not Covid.
The email will go to the same Line manager.

Regards

Chris

Was this reply helpful? Yes No
sgtsnacks64 322 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Awesome,

@Nogueira1306 's solution stands,

HtmlText.Default = If(tglCovid.Value,
TEXT FOR THE COVID HERE,
TEXT FOR NO COVID HERE
)

Was this reply helpful? Yes No
Chris1968 1,154 on at

Like (0)

Report
Copy link

Link copied!

Hi
Would this allow me to add information that has been collected such as name of employee, Expected return date,.

When you say 'default' where would this be?? Sorry

Was this reply helpful? Yes No
Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

You can insert that condition here

You can keep your code, the only diference is that it can change based on your toogle/Checkbox.

You can define text for Covid and Not Covid and you can insert info from textboxs, comboboxs, etc

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,

Gonçalo Nogueira

Check my LinkedIn!

Buy me a coffee!

Check my User Group (pt-PT)!

Last Post on Community

My website!

Was this reply helpful? Yes No
Chris1968 1,154 on at

Like (0)

Report
Copy link

Link copied!

Hi,

This is the formula I have currently
The new bit will be added after the last & and before "</a>"?
If I want to more information to the body of the email I'll just add the a Name and then reference the respective field.
For example -
Text for Covid

Employees Name : Text(EmpName.Text),
Covid Reason: (DatacardValue.Selected.Value),
Return Date : (DatacardValue.Selected. Value),

Text for no Covid

Employee Name: Text(EmpName.Text),
Absence Reason: (DatacardValue.Selected.Value),

Sorry but how will it look??

Was this reply helpful? Yes No
Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
If( tglCovid.Value,

If( tglCovid.Value,
"<a href = "mailto:" && Office365Users.ManagerV2(DataCardValue7_6).mail && "?subject = Absence & body =
Employees Name : " && Text(EmpName.Text) && ",
Covid Reason: " && (DatacardValue.Selected.Value) && ",
Return Date : " && (DatacardValue.Selected. Value) && ">",

"<a href = "mailto:" && Office365Users.ManagerV2(DataCardValue7_6).mail && "?subject = Absence & body =
Employees Name : " && Text(EmpName.Text) && ",
Absence Reason : " && (DatacardValue.Selected. Value) && ">"

)

Something like that

Was this reply helpful? Yes No
Chris1968 1,154 on at

Like (0)

Report
Copy link

Link copied!

Hi,

If tried to add a formula in which I hoped would work but there is an error

Return Date: DataCardValue54.SelectedDate Error Invalid argument typr. Expecting one of the following: Boolean, Text, number, option set value.

Was this reply helpful? Yes No
Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Check the datacard value... you were the one tolding me that....

Was this reply helpful? Yes No