Answered

Send Email without using automate and add backend data into sample email of body

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi Everyone ,

I need to send email without using power automate . So I use On Success property of edit form ,I am using

OnSuccess = Office365Outlook.SendEmail("nancy@xxxx.onmicrosoft.com", "Use Details", "Details

1. RegID: 
2.  City:
3. Country:

How we pull out data of RegID, City, Country. And I don't want to use RegID:txtinput.text something .

Thanks,

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Sort by

VJR 7,635 on at

Like (1)

Report
Copy link

Link copied!

@Chitrakant27 , the EditForm1.LastSubmitted.RegID of the form will give you those details in the Form's OnSuccess property. Hope that is what you are looking for. Likewise you can use LastSubmitted.City and LastSubmitted.Country

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @VJR

Are you saying like
Let me try once , if any error i will post
1. RegID:EditForm1.LastSubmitted.RegID
2. City:
3. Country:

Was this reply helpful? Yes No
cwebb365 3,294 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Basically, but it would be more like:

Office365Outlook.SendEmail("nancy@xxxx.onmicrosoft.com", "Use Details", "Details

1. RegID: " & LastSubmit.RegID & "
2. City: & LastSubmit.City & "
3. Country: " & LastSubmit.Country)

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @cwebb365 ,
I want to pull out data from share point list not Edit form so query I apply
RegID:

Was this reply helpful? Yes No
cwebb365 3,294 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

huh? That is pulling it from your last submit, has nothing to do with the edit form. I was just pointing out the formatting to concatenate the string with dynamic values in the email body.

Was this reply helpful? Yes No
Verified answer

cwebb365 3,294 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
So RegID: comes from the form item you submitted or somewhere else in the app? If some other data source, you need to utilize Lookup to get the value. Something like below. Last submit is just assuming a value based on something on the form.

1. City: " & Lookup(Datasource,id = LastSubmit.Regid).City & "

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @cwebb365

Thank you so much!!!

Was this reply helpful? Yes No