Forum Discussion

New_learner's avatar
New_learner
Copper Contributor
Oct 03, 2022

How to concatenate particular column value from multiple rows if username column has same value.

 
I have two share point lists:
  1. Employee-List
  2. Employee-Project List
 
In Employee-Project-List:
  • I have added Employees with different projects as shown in image as follow:
  • Where EmployeeName and ProjectName are Lookup fields from Employee List and Project List respectively.
 
  • List 2 - Project List

          (Project List-Structure as follows)

 
And in Employee List
I want concatenated project values with comma-separated for Employee, like shown in below image
I need help in getting it worked via power automate flow 
Flow should be triggered when new item is created/updated in Employee-Project List
 
Please guide me.
Thanks in advanced.
  • RobElliott's avatar
    RobElliott
    Silver Contributor
    Oct 03, 2022

    New_learner as a personal opinion I think you are making life difficult for yourself. With a Power Apps app and Lists data sources everything would be so much easier. Did you have a look at my solution here using a Power Apps customised form for the dropdowns etc question you raised? All this additional stuff about concatenating values just becomes easy, and you can use filters etc etc if you build a solution in Power Apps. Your scenario is ideal for Power Apps but so much harder (or maybe not even possible) with Lists on its own.

     

    Rob
    Los Gallardos
    Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

     

     

    • New_learner's avatar
      New_learner
      Copper Contributor
      Oct 04, 2022
      Hello RobElliott,
      I have checked your solution in my another question. And I am working on the same solution.

Resources