Send Mail notification to the owner as soon ticket has status closed

(0) Share

Report

Posted on by Unbihexium

180

I’ve modified the «service desk» template and I would like to implement the following at the “TicketdetailsPage ” :

As soon the ticket status is “closed” and the button “save” is hit it should send a mail notification to the owner of the ticket.

If("StatusCase" = "Geschlossen";
SubmitForm(TicketDetailsForm);
Office365.SendEmail("Tickets.Owner"; <--- here is my problem
"Ticketsystem - Ticket ID: " & Value16-1 & Char(45) & Subject & " wurde geschlossen"; "Dein Ticket mit der ID " & Value16-1 & " wurde gelöst"
&Char(13) & " Abschluss-Kommentar: " & Value3 & Char(13)
& "Geschlossen durch: " & User().FullName)
;SubmitForm(TicketDetailsForm)
)

Have to mention, all user have a Office365 account,
and @ the “CreatenewticketPage” user are automatically detected with “User().FullName” equals “owner” in Excel-DB-sheet.

Probably I need to transform the User().FullName to User().Email but how??? o0

Would be thankful for any hint

Categories:

Building Power Apps

pic1.jpg

pic2.jpg

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

v-xida-msft on at

Like (1)

Report
Hi @Unbihexium ,

Do you want to send an email to the owner of the Ticket when you click "Save" button within the TicketdetailsPage?

Based on the needs that you mentioned, I have made a test on my side, please take a try with the following workaround:

Firstly, you need to add a Office 365 Users connector as a data source within your app. Then modify the formula within the OnSelect property of the "Save" button within TicketdetailsPage to following:

If(
"StatusCase" = "Geschlossen"; SubmitForm(TicketDetailsForm); Office365.SendEmail(
LookUp(Office365Users.SearchUser(); DisplayName = TicketsGallery.Selected.Owner; Mail); /* <-- Modify formula here. Find the email address of the specific owner via the Owner name */ "Ticketsystem - Ticket ID: " & Value16-1 & Char(45) & Subject & " wurde geschlossen"; "Dein Ticket mit der ID " & Value16-1 & " wurde gelöst" &Char(13) & " Abschluss-Kommentar: " & Value3 & Char(13) & "Geschlossen durch: " & User().FullName
);SubmitForm(TicketDetailsForm) )

Note: I assume that the user use the Full Name as the Display Name within their Office 365 Profile.

Best regards,

Was this reply helpful? Yes No
Verified answer

v-xida-msft on at

Like (1)

Report

Duplicated

Was this reply helpful? Yes No
Unbihexium 180 on at

Like (0)

Report

Hello Kris

Thank you for your reply.
That was excactly what I've been looking for. Thank you so much!

I had to type it like this: "LookUp('Office365-Benutzer'.SearchUser(); DisplayName = TicketsGallery.Selected.Owner; Mail);"
because of the language I guess ^^
It works perfectly!

Best regards

Was this reply helpful? Yes No