I have a SharePoint online library, where I want to merge several columns into a single column. Most of the columns are multi select columns (choice/checkbox). How can I use power automate to collect the values that someone selects per column and then have power automate put the selections into a single column? I am not a programmer. I am a technical writer who is attempting to understand all of this.

I find this post: Concatenate Sharepoint Data using Power Automate interesting, but I do not fully understand what is happening.

I do want to know how to combine multiple columns (some multi select) in a SharePoint online library.

Can anyone help? Is there a video on YouTube.com?

  • Looks like you've referred to my Power Automate post. However, would like to inform that this can also be done using SharePoint Calculated column in depending on your requirements. If it's not complex logic then I would go with Calculated column. If you could elaborate your SharePoint list columns with sample values and the expected results, surely someone would be able to help. – Matiur Rahman Feb 22 at 19:18
  • @Matiur Rahman I tried using Calculated columns, but SharePoint only shows column choices that are drop-down or single line of text. It does not list multi-select columns. I'm not sure where I can post an example of my columns. Let me try to start a fresh post. – Aleshia Thompson Feb 22 at 22:22
  • @MatiurRahman Here is the new post: sharepoint.stackexchange.com/questions/290180/… If you can assist, I would be grateful. – Aleshia Thompson Feb 22 at 22:34

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.