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

Re: Adding email to an existing formula

Great, I'm glad that did the trick!

GC87
Level: Powered On

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.

GC87
Level: Powered On

Re: Adding email to an existing formula

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

GC87
Level: Powered On

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.

 

 

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
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (6,709)