Hi @fokumus007 ,
The error is happening because you are trying to use an "apply to each" loop to a string, when the action requires an array as input.
Based on your description and on the images that you shared, I see that your first loop is fine, as you are basically iterating the "rows from an Excel table". For the second loop, however, it looks like you are trying to iterate some field from one of those Excel rows, which usually is a string.
As the "apply for each" loop will return you each row from the table, you will be able to access each column value from the dynamic content (or via expressions, if you prefer).
For example, take this Excel table: I will try to access all values form column "A" in Power Automate:
After run the "List rows present in a table", you can click in "Click to download" in the outputs section of the action to see how Power Automate is reading the data from your table
This is my output, and you can see that each row is stored inside "value" as an individual object. So we can assume that the "value" property (that one that you iterated in your flow) is an array of objects.
When you use your the "value" from "List rows present in a table" as input for the "apply to each" action, you will be able to access the individual properties of each row inside the loop (dynamically or via expressions). In my case, I just set the "A" property (which will return the value from column "A" for the currently iterated row) to a variable.
Finally, in my flow run, you will see a total of 5 iterations in my loop (which is expect, as I have 5 rows in the Excel table), and each one will be accessing the value from "A" column for the respective row (in the case below, the captured value was 7, which can be found in the 3rd row):
Let me know if it works for you or if you need any additional help. If for any reason you need to "iterate a string value", let me know and I show you how to split it to transform it into an array and allow the looping.
