Showing results for 
Search instead for 
Did you mean: 
New Member

Transform single data into multiple rows in Sharepoint with Power Automate

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?


Helpful resources

Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (4,845)