Get data from a multi select column in single email

%3CLINGO-SUB%20id%3D%22lingo-sub-3012766%22%20slang%3D%22en-US%22%3EGet%20data%20from%20a%20multi%20select%20column%20in%20single%20email%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3012766%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20multi%20select%20column%20in%20a%20list%20that%20I%20want%20to%20add%20to%20an%20email%20in%20a%20flow%20that%20I%20am%20creating.%26nbsp%3B%3C%2FP%3E%3CP%3EAt%20the%20moment%20i%20have%20just%20added%20the%20'leave%20type%20value'%20to%20an%20email%20and%20it%20applies%20to%20each%20and%20send%20several%20emails%20depending%20how%20many%20selections%20were%20made%20-%20one%20email%20for%20each%20value.%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22EKIT415_0-1638155008712.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F329910iE5CBD03AB1EBB8E6%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22EKIT415_0-1638155008712.png%22%20alt%3D%22EKIT415_0-1638155008712.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20also%20tried%20this%20in%20an%20approval%20process%20but%20it%20put%20this%20into%20an%20apply%20for%20each%20as%20well%20and%20this%20broke%20the%20flow.%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22EKIT415_1-1638155129700.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F329911iC8D4B6A11C7F6703%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22EKIT415_1-1638155129700.png%22%20alt%3D%22EKIT415_1-1638155129700.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eso%20what%20I%20would%20really%20like%20to%20do%20is%20at%20the%20start%20of%20the%20flow%20turn%20the%20'leave%20type%20value'%20into%20text%20at%20the%20start%20of%20the%20flow%20so%20i%20can%20just%20add%20this%20to%20the%20emails.%20I%20have%20attempted%20this%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22EKIT415_2-1638155280337.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F329912i6D665CC99C388047%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22EKIT415_2-1638155280337.png%22%20alt%3D%22EKIT415_2-1638155280337.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3Ebut%20the%20problem%20with%20this%20is%20that%20output%20is%20so%20messy%3A%26nbsp%3B%7B%22%22%3A%22Sick%20leave%22%7D%3A%7B%22%22%3A%22TOIL%22%7D%3CBR%20%2F%3Eis%20there%20a%20way%20to%20clean%20this%20up%20or%20a%20different%20way%20to%20get%20the%20same%20result.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3012766%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional 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