Unanswered

Getting a Label from a Power Apps Form into the body of an email in a Flow

(0) Share

Report

Posted on by Jukie

Hello! I've found several threads that I can almost make work, but not quite. I have a field with multi-select values. In my Form, I created a Label and used the Concat expression to format the selected values in the multi-select (names) field: Concat(DataCardValue23.SelectedItems, Value & Char(10)). (Note also tried this with a text input box)

I cannot figure out how to add the formatted contents of that label to the body of my email in my flow. The other option is to add the multi-select field into the body of the email and format directly in my flow somehow. Any guidance for this newbie would be appreciated!

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

v-bofeng-msft on at

Like (0)

Report

Hi @Jukie ,

I‘ve made a test for your reference:

1\My flow

2\In Canvas app

Bof0508.Run(1,Concat(DataCardValue23.SelectedItems, Value & " "))

3\Result

Best Regards,

Bof

Was this reply helpful? Yes No
Jukie 82 on at

Like (0)

Report

Works perfectly! Thank you @v-bofeng-msft !

Was this reply helpful? Yes No
Jukie 82 on at

Like (0)

Report

@v-bofeng-msft One last question for you. I had multiple lists of names in different fields that I had to add in separately. Still works great, except when one of the lists happens to be blank in that record. It says the run tried to pass through a blank and made it invalid. Is there anyway I can get it to skip blanks?

ConferenceAttendeeEmail.Run(DataCardValue36.Text,Concat(DataCardValue23.SelectedItems, Value & " "),Concat(DataCardValue19.SelectedItems, Value & " "),Concat(DataCardValue21.SelectedItems, Value & " "),Concat(DataCardValue24.SelectedItems, Value & " "),Concat(DataCardValue22.SelectedItems, Value & " "),Concat(DataCardValue6.SelectedItems, Value & " "),Concat(DataCardValue1.SelectedItems, Value & " "),Concat(DataCardValue9.SelectedItems, Value & " "),Concat(DataCardValue20.SelectedItems, Value & " "),Concat(DataCardValue30.SelectedItems, Value & " "))

Was this reply helpful? Yes No
Jukie 82 on at

Like (0)

Report

@v-bofeng-msft I ended up being able to solve the blank record issue with the Coalese function. Thanks!

Was this reply helpful? Yes No