Transform single data into multiple rows in Sharepoint with Power Automate

[martinscairo]

Hello there,

I am responsible for digitalizing a manufacture process in which each day all collaborators make an appointment regard their work individually. They are identified by the column "Matricula".

However, sometimes there is a need to point collective occurrence, such as training, that represents that all workers were associated with it on an specific day. It is pointed just one time without any mention to the field "Matricula" (enrollment number).

I would like to create a flow that is able to read when a line is marked as "Collective occurrence", copy general columns and then change the occurence to "Individual" and fulfill the empty field "Matricula" with all the individual registrations that were made that day, just one time. 

When an item is created, here is why my flow does:

My challenge is then to fulfill the field "Matricula". Can someone please help me?