I am trying to convert one row of data in list 1 to multiple rows of List 2 using MS FLOW (Example shown below). Please can you guide me the steps?
|Project||Q1 Score||Q2 Score||Q3 Score||Q4 Score|
1. use and array variiable and add all the values of column Q1 Score, Q2 Score, Q3 Score and Q4 Score in it.
2. Use a forach loop to lop this array, inside this loop create item for every value of score entered in array.
Hope this helps.
Chandrashekhar, Pune, India
Thank you for posting to the Flow Community Forum! It appears you have found a solution to your issue! If you feel as though your issue has been solved and you are satisfied with one of the previous replies, please click "Accept as Solution" on the reply that contains the solution so that this thread will be marked for other users to easily identify!
Thank you for being an active member of the Flow Community!
Microsoft Flow Community Manager
Hi Guys. I want to solve a similar problem. I want to copy columns as items in a new SharePoint list based on a criteria. The first list looks like this:
The new list should look like this:
The actions should be performed for all new items created in a list. Appreciate detailed steps (screenshots) for how to accomplish this, as I’m new to Power Automate.
Thanks in advance