Get data from a multi select column in single email

Copper Contributor

Hello, 

 

I have a multi select column in a list that I want to add to an email in a flow that I am creating. 

At the moment i have just added the 'leave type value' to an email and it applies to each and send several emails depending how many selections were made - one email for each value. 

EKIT415_0-1638155008712.png

 

I also tried this in an approval process but it put this into an apply for each as well and this broke the flow. 

EKIT415_1-1638155129700.png

 

so what I would really like to do is at the start of the flow turn the 'leave type value' into text at the start of the flow so i can just add this to the emails. I have attempted this:

EKIT415_2-1638155280337.png

but the problem with this is that output is so messy: {"":"Sick leave"}:{"":"TOIL"}
is there a way to clean this up or a different way to get the same result. 

0 Replies