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

[New_learner]

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.

[#2]

@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)

[#3]

Hello @RobElliott,
I have checked your solution in my another question. And I am working on the same solution.