cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
slabunski
Level: Powered On

Populate Email with EditForm Data

Hello All!

Been trying my best to get this to work and i am just having a hell of a time. I have watched multiple videos but cant seem to get the data to showcase! I am creating an order form, but some orders need approval requests to be sent, i am trying to automate this process with a button press to take the information listed in the form , and send it to a specific email inbox with the content. here is my coding for the button:

 

Office365.SendEmail( "emailaddress@recipiant.com",

"Please provide authorization for:" & ThisItem.'Column1',

"CC Approval required for:"

& Char(13)

& Char(13) &

"Dealer: " & ThisItem.'Column1'

& Char(13) &

"Dealer #: " & ThisItem.'DEALER_N'

& Char(13) &

"Order #: " & ThisItem.'ORDER_N'

& Char(13) &

"Total: " & ThisItem.'VALUE' ,

{From:"fromemailaddress@sender.com"}

)

 

The content shows as follows:

 

------

CC Approval required for:

 

Dealer:           

Dealer #:         

Order #:          

Total:            

-----

 

Email doesn't have any of my filled in form content. Not sure what i am doing wrong, the coding works, email is sent, but no information from the form is included. Help!

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Populate Email with EditForm Data

Hi,

 

If it's a new record, there won't be any ThisItem values 🙂

 

Just use the object's .Value/.text

 

So let's say that Dealer is DataCardValue1 in this case, then you would use:
"Dealer: " & DataCardValue1.Value

 

Give that a try for the rest and let me know if you run into any issues,

 

Cheers,

@iAm_ManCat




Don't forget to 'Mark as Solution' if a post answered your question and always 'Thumbs Up' the posts you like or helped you!

View solution in original post

2 REPLIES 2
Super User
Super User

Re: Populate Email with EditForm Data

Hi,

 

If it's a new record, there won't be any ThisItem values 🙂

 

Just use the object's .Value/.text

 

So let's say that Dealer is DataCardValue1 in this case, then you would use:
"Dealer: " & DataCardValue1.Value

 

Give that a try for the rest and let me know if you run into any issues,

 

Cheers,

@iAm_ManCat




Don't forget to 'Mark as Solution' if a post answered your question and always 'Thumbs Up' the posts you like or helped you!

View solution in original post

slabunski
Level: Powered On

Re: Populate Email with EditForm Data

Thank you for your quick assitance!
I used the following ant it worked:

"Please provide authorization for:" & SUB_DEALER_NAME_VAL.Text,
"CC Approval required for:"
& Char(13) & Char(13) &
"Dealer: " & SUB_DEALER_NAME_VAL.Text
& Char(13) &
"Dealer #: " & SUB_DEALER_NUM_VAL.Text
& Char(13) &
"Order #: " & SUB_ORDER_N_VAL.Text
& Char(13) &
"Total: " & SUB_VALUE_VAL.Text 


For those reading in the future, this is the name of the actual Textbox (Named: Text Input) within the card.

Helpful resources

Announcements
thirdimage

Power Apps Super User Class of 2020

Check it out!

thirdimage

Power Apps 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

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Users online (5,384)