Unanswered

Multiple select Notification to Mail

(0) Share

Report

Posted on by ArtHavenShelter

Hi! Searching for a solution I can't find the right one. What I would like is to Send an email after an Item has been created. One of the fields is a multiple selection field. I would like to have them shown in the email. I created this:

With this result:

So, I get a result, but the reader needs to see through the lines what he or shee needs to do. What do I do wrong? And how can I solve it.

Kind regards,

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

Ellis Karim 11,653 Super User 2025 Season 2 on at

Like (1)

Report
Re: Multiple select Notification to Mail

Hi @ArtHavenShelter ,

The result you are seeing is due to the fact that the Access Rights column is a multi-select column and is composed of several properties. You just need to (1) select all the "Value" properties, and then (2) join all these values into a string:

(1) Select all the "Value" properties

The Select action produces an array of the values:

[ "CRS", "Email", "Leave system", "Special access to SharePoint" ]

(2) Join all values from the Select action using a command and space character:

The Join action produces the following string:

CRS, Email, Leave system, Special access to SharePoint

(3) Use the output of the Join action in the Send an email action:

Here is a sample runtime output:

Ellis
____________________________________
If I have answered your question, please mark the post as ☑️ Solved.
If you like my response, please give it a Thumbs Up.
My Blog Site | Twitter | LinkedIn

Was this reply helpful? Yes No
ArtHavenShelter 88 on at

Like (0)

Report

Re: Multiple select Notification to Mail

Hi! Looks a bit different from my side, but it works. Any recommendations if this is okay enough or not?
Kind regards!

Was this reply helpful? Yes No
ArtHavenShelter 88 on at

Like (0)

Report

Re: Multiple select Notification to Mail

Thank you so much! It looks a bit different from my side, but it works.

Was this reply helpful? Yes No
Ellis Karim 11,653 Super User 2025 Season 2 on at

Like (1)

Report

Re: Multiple select Notification to Mail

That's look OK. I'm was trying to simulate your problem in my Dev environment so my screenshots will look a little different. As long as the correct SharePoint column is used (Access Rights) along with the expressions, the flow should work.

Ellis

Was this reply helpful? Yes No