cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
thecharwest
Helper I
Helper I

List Choices (multi-select option set) values in an email

I'm trying to include a choices/multi-select option set field's values into an email, and simply adding it as dynamic content doesn't seem to work - the email just returns a blank value. Is there a step I can add to list out these values so I can include them in the email?

 

flow choices.PNGemail choices.PNG

12 REPLIES 12
eric-cheng
Solution Sage
Solution Sage

Hi @thecharwest ,

 

Have a look at these two posts here and here to see how to convert a multi select field to a comma separated list.

 

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

thecharwest
Helper I
Helper I

Hi @eric-cheng 

 

Thanks for those posts. I think I'm a little closer, but I still haven't managed to get it working. I'm a bit confused as to what to put in the field circled in green? The highlighted parts are all referring to the same field, and I'm not even sure if that's 100% correct. 

 

Can you see where I'm going wrong? What should I put in that field?

initialise.PNG

 

eric-cheng
Solution Sage
Solution Sage

Hi @thecharwest ,

 

I created a multi choice field called Multi

Screenshot_20210724-015731_Chrome.jpg

 

For the flow, I initiated a string called MyString and retrieved a List Item.  When you use the Multi column, it will automatically loop.  In the loop append the value to the string variable.

Screenshot_20210724-015905_Chrome.jpg

 

You can then use the string variable in your email.

 

Screenshot_20210724-015945_Chrome.jpg

 

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

 

Hello, 

 

Thank you for trying to help but I'm still stuck at the same point. I don't seem to have the correct dynamic content for the field I highlighted before (circled in green again here):

flow multi.PNG

 

I named the initialize variable MultiStandards, and where you seem to have a "MultiValue" dynamic content option in your field at the append step, I have no such luck. You can see I've tried searching for "Multi" as that's what I named mine, but nothing comes up as a value. Do you know what I am missing here?

 

Thanks in advance.

Hi @thecharwest ,

 

You wouldnt have Multi Value as this is what I named my column.  Please select your Dataverse Website Field - standards value.

 

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Hiya @eric-cheng 

 

I don't seem to have any Values options:

flow no value.PNG

 

eric-cheng
Solution Sage
Solution Sage

Hi @thecharwest ,

 

Please select the option in blue below. I dont know which field this is as its blocked out in your screenshot.

 

Screenshot_20210727-215631_Chrome.jpg

 

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Hi @eric-cheng 

 

Yeah sorry about that, I gave up bothering to rub it out! 

 

I tried that, and got this error:

 

ExpressionEvaluationFailed. The execution of template action 'Apply_to_each' failed: the result of the evaluation of 'foreach' expression '@triggerOutputs()?['body/samar_websitefieldisoqarstandards']' is of type 'Null'. The result must be a valid array.

 

flow new error.PNG

 

 

I'm afraid I'm very much a novice when it comes to Flow so can you tell me what this means?

 

Thanks for sticking around and helping out!

eric-cheng
Solution Sage
Solution Sage

Hi @thecharwest ,

 

Looks like some of the values may be empty

 

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Hi @eric-cheng 

 

So this only works if someone selects all of the options available in the field?? Is there no way around this?

 

Basically it's a field on a form on our website which is asking to select up to four options, but most people will probably only choose one of the four. Is there any other way of creating a flow to list them, even if only one option is given by the user?

Hi @thecharwest ,

 

You will need a condition or if() statement to handle blank values

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Hi @eric-cheng 

 

Do you have an example I might be able to follow? I think the if() statement probably makes most sense but I have no idea where I'd add it in the flow or even really what it would need to say. As I said, I am a complete novice! 🙂 

Helpful resources

Announcements
Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Top Solution Authors
Top Kudoed Authors
Users online (2,699)