Concatenating Multi-Choice Field

%3CLINGO-SUB%20id%3D%22lingo-sub-1392760%22%20slang%3D%22en-US%22%3EConcatenating%20Multi-Choice%20Field%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1392760%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20modern%20Sharepoint%20list%20with%20Fields%20including%3A%3C%2FP%3E%3CP%3ESpeciality%20-%20Choice%20(Multiple%20selection%20allowed)%3C%2FP%3E%3CP%3ESME%20-%20Person%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'd%20like%20to%20concatenate%20them%20into%20a%20single%20line%20of%20text.%20I%20can't%20use%20the%20Calculated%20column%20I%20believe%20due%20to%20the%20multiple%20choice.%20I%20tried%20Flow%20but%20really%20struggling%20to%20get%20anything%20to%20work%20as%20I%20keep%20getting%20'Apply%20to%20Each'%20and%20it%20won't%20let%20me%20extract%20the%20data.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnyone%20have%20any%20suggestions%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMany%20Thanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1392760%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECalculated%20Column%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFlow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20Automate%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1393662%22%20slang%3D%22en-US%22%3ERe%3A%20Concatenating%20Multi-Choice%20Field%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1393662%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F339060%22%20target%3D%22_blank%22%3E%40jawilson%3C%2FA%3E%26nbsp%3Byou%20%3CEM%3Ecan%3C%2FEM%3E%20do%20this%20with%20a%20flow%20in%20Power%20Automate%20and%20you%20DO%20need%20the%20%3CEM%3EApply%20to%20each%3C%2FEM%3E%20control%20as%20each%20answer%20of%20your%20multi-choice%20column%20needs%20to%20be%20evaluated.%26nbsp%3B%20In%20the%20list%20below%20the%20Platform%20column%20is%20a%20Choice%20column%20with%20multiple%20selections%20allowed%2C%20Person%20is%20a%20Person%20column%20and%20Concat%20is%20a%20single%20line%20of%20text%20column.%26nbsp%3B%20The%20result%20is%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%220-SP-List.png%22%20style%3D%22width%3A%20914px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F192104iA556301553A8272B%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%220-SP-List.png%22%20alt%3D%220-SP-List.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20flow%20that%20achieves%20this%20is%20as%20follows%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%221a-Trigger-initVar-Apply-Compose-Append.png%22%20style%3D%22width%3A%20590px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F192106i3C62A1AEE79727BE%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%221a-Trigger-initVar-Apply-Compose-Append.png%22%20alt%3D%221a-Trigger-initVar-Apply-Compose-Append.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENext%2C%20%3CU%3Eoutside%3C%2FU%3E%20the%20Apply%20to%20each%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%222a-Compose-Concat.png%22%20style%3D%22width%3A%20574px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F192105i88F75E16A7B5EE44%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%222a-Compose-Concat.png%22%20alt%3D%222a-Compose-Concat.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%223a-Update-Set.png%22%20style%3D%22width%3A%20629px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F192108i3864C034378F60FD%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%223a-Update-Set.png%22%20alt%3D%223a-Update-Set.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHopefully%20you%20can%20use%20that%20in%20your%20flow%20but%20come%20back%20with%20any%20questions.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1400072%22%20slang%3D%22en-US%22%3ERe%3A%20Concatenating%20Multi-Choice%20Field%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1400072%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you!%20This%20certainly%20looks%20like%20it%20will%20work.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%2C%20randomly%20since%20yesterday%20my%20power%20automate%20has%20changed!%20It%20now%20doesn't%20let%20me%20enter%20a%20function%2Fexpression.%20It%20only%20allows%20me%20to%20select%20a%20parameter%20from%20a%20previous%20step%3A%20%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22jawilson_0-1589825375614.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F192761i0B90FD36B8C917F0%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22jawilson_0-1589825375614.png%22%20alt%3D%22jawilson_0-1589825375614.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20not%20sure%20how%20to%20manually%20enter%20the%20expression%2C%20or%20if%20it%20is%20still%20possible%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

I have a modern Sharepoint list with Fields including:

Speciality - Choice (Multiple selection allowed)

SME - Person

 

I'd like to concatenate them into a single line of text. I can't use the Calculated column I believe due to the multiple choice. I tried Flow but really struggling to get anything to work as I keep getting 'Apply to Each' and it won't let me extract the data. 

 

Anyone have any suggestions?

 

Many Thanks

2 Replies
Highlighted

@jawilson you can do this with a flow in Power Automate and you DO need the Apply to each control as each answer of your multi-choice column needs to be evaluated.  In the list below the Platform column is a Choice column with multiple selections allowed, Person is a Person column and Concat is a single line of text column.  The result is:

 

0-SP-List.png

 

The flow that achieves this is as follows:

1a-Trigger-initVar-Apply-Compose-Append.png

 

Next, outside the Apply to each:

 

2a-Compose-Concat.png

 

3a-Update-Set.png

 

 

Hopefully you can use that in your flow but come back with any questions.

Highlighted

Thank you! This certainly looks like it will work. 

 

However, randomly since yesterday my power automate has changed! It now doesn't let me enter a function/expression. It only allows me to select a parameter from a previous step:  

jawilson_0-1589825375614.png

 

I'm not sure how to manually enter the expression, or if it is still possible?