Okay, It seems like I may have misunderstood your question. I thought you wanted to write each of those values into a separate column. But what it seems that you need is to write the values as separate rows instead. When that is the case, you actually need a bit more actions. You should try doing something like this:
This will iterate through your %RMList% variable, creating a %CurrentItem% variable in each iteration. %CurrentItem% will be a list of its own, so there is another nested Loop action that will iterate through %CurrentItem% writing each value into a separate column. And then there is a Get first free row on column from Excel worksheet action to figure out which row to write to.
Here's a snippet for copying and pasting it to PAD:
LOOP FOREACH CurrentItem IN RMList
Excel.GetFirstFreeRowOnColumn Instance: ExcelInstance Column: $'''A''' FirstFreeRowOnColumn=> FirstFreeRowOnColumn
LOOP LoopIndex FROM 0 TO CurrentItem.Count - 1 STEP 1
Excel.WriteToExcel.WriteCell Instance: ExcelInstance Value: CurrentItem[LoopIndex] Column: LoopIndex + 1 Row: FirstFreeRowOnColumn
END
END
Try it and see if this works better for you.
-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.
I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.
