cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Super User
Super User

Re: Adding email to an existing formula

Great, I'm glad that did the trick!

Highlighted
Frequent Visitor

Re: Adding email to an existing formula

Now i just have to change the rest. I did get the email from the ticket which is great however I get Text as the subject and the body is HTMLtext. I know that I placed subject as Text so that is easy to fix but the body i need to figure out haha I will post any questions if I have a hard time.

Highlighted
Frequent Visitor

Re: Adding email to an existing formula

Just changed the Subject but am not understanding the body portion. Sorry if I am bugging haha

Highlighted
Frequent Visitor

Re: Adding email to an existing formula

This is the latest I have transformed to

 

If(IsBlank(Subject.Text) || IsBlank(Description.Text) ,UpdateContext({msg_visible:true}),SubmitForm(NewTicketForm);UpdateContext({New:Patch(Tickets,LookUp(Tickets,ID=Text(Max(Tickets,ID))),{Subject:Subject.Text,Description:Description.Text})});
Office365.SendEmail(
"email1@company.com", // To field
"New Ticket", // Subject Field
Value13 & Char(10) & Subject & Char(10) & Description & Char(10)
))

 

For some reason I cannot get Value13 to print on the email whoever

 

DataCard15 is the Created by* section where it asks the user to place their name

DataCard15 is the following:

 

StarVisible15 = "*"

ErrorMessage15 = Parent.Error

Value13 = Parent.Default

Key15 = Parent.DisplayName

 

So Im curious if I need to change Value13 to something completely different or modify it to be visible or if I need to replace Value13 with Key15 instead. This is as far as I have gotten.

 

 

Highlighted
Super User
Super User

Re: Adding email to an existing formula

Value13 is a text input control. Therefore, Value13.Text is the syntax that you would use to retrieve the text that's in the control.

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (7,402)