Answered

Send Email - Dynamic Subject

(0) Share

Report

Posted on by Ryan_B

446

I have a form with a text input field that I would like to use as the subject line when sending an email. I feel like I have the correct answer but it doesn't appear to be working. Here is my sample code:

Office365Outlook.SendEmailV2(
 "myemail@email.com",
 "Downtime - " & DowntimeType.Text,
 varEmailMessage,
 {Importance: "High"}
);
ResetForm('Downtime Form');

No errors are being thrown but it doesn't add the input from DowntimeType.Text. The email I receive has the subject line as "Downtime - " and nothing else. I've also tried using Concatenate to no avail. I don't work with forms often so maybe it has something to do with the fact that the input is within a DataCard?

Categories:

Building Power Apps

I have the same question (0)

All responses (15)

Answers (1)

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
@Ryan_B

First, this formula should be in the OnSuccess action of your form.

From there, you need to access the LastSubmit value from your form.

Office365Outlook.SendEmailV2( "myemail@email.com", "Downtime - " & Self.LastSubmit.DowntimeType, // or whatever your field name is from the form record. varEmailMessage, {Importance: "High"} ); ResetForm('Downtime Form');

I hope this is helpful for you.

Was this reply helpful? Yes No
Ryan_B 446 on at

Like (0)

Report
Copy link

Link copied!
@RandyHayes
So I ended up changing it from a text input to a combo box, how would that alter that line? I've tried the two lines below as they are the only ones that will accept anything, but neither work.

"Downtime - " & Self.LastSubmit.'Downtime Type'.Value "Downtime - " & Self.LastSubmit.DowntimeType.Value

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@Ryan_B

What is the name of the column in your list record for Down Time Type and what kind of column is it?

Was this reply helpful? Yes No
Ryan_B 446 on at

Like (0)

Report
Copy link

Link copied!

@RandyHayes
The column name is "Downtime Type" and it's a Choice column.

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
@Ryan_B

Then this:

"Downtime - " & Self.LastSubmit.'Downtime Type'.Value

Should be working for you.

Do you get an error or anything on it?

Was this reply helpful? Yes No
Ryan_B 446 on at

Like (0)

Report
Copy link

Link copied!

@RandyHayes
No error is thrown, but it still doesn't come through correctly. I'm also noticing that it's not actually saving the value to the SharePoint list either. I wonder if that's indicative of what the actual problem is.

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@Ryan_B

Yep! There's the issue.

What is the Update property of the datacard that contains that control?

Was this reply helpful? Yes No
Ryan_B 446 on at

Like (0)

Report
Copy link

Link copied!
@RandyHayes
DowntimeType.Selected.Value

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@Ryan_B

To clarify -

DowntimeType is the name of the dropdown control in your form datacard?

The value you are trying to submit from the dropdown is in your choice column?

The items property of the Dropdown control is: Choices(yourList.'Downtime Type')?

Tell me about any customizations you have made to the "Downtime Type" datacard when/after you added it to your form.

Was this reply helpful? Yes No
Ryan_B 446 on at

Like (0)

Report
Copy link

Link copied!

@RandyHayes
Sorry for the confusion.

DowntimeType - name of the combo box within Downtime Type_DataCard2
Values within this combo box are appearing properly from the SharePoint list where the column is called "Downtime Type" and of type Choice.
Items property - Choices([@'MyList'].DowntimeType)

As for changes I made, it's tough to say exactly. I went into my SharePoint list and changed the column from single line of text to Choice, and added some sample choices. Went back to my Power App and refreshed my data source. Removed the text input field from the data card and added a combo box instead. Went through the error marks and thought I wired it back up correctly but it appears that isn't the case.

Was this reply helpful? Yes No