Rajeev Pentyala – Technical Blog on Power Platform, Azure and AI

In this short blog post, lets see how to write formula to combine combo box selected items in to text with a separator.

Formulas:

Single column collection:

• If the Combo box items is a single column collection as specified below.

• Use ‘ThisRecord.Value’ in the Concat function.
  • Formula : Concat(cmbFruits.SelectedItems,ThisRecord.Value,”,”)

Multi column collection:

• If the Combo box items is a Multicolumn Collection as specified below.

• Use ‘ThisRecord.{Attribute_Name}’ in the Concat function.
  • Formula : Concat(cmbFruitsTable.SelectedItems,ThisRecord.Name,”,”)

🙂