Share
Report
2I'm trying to run a simple task:
An Excel Sheet has a table, that collects statistics from the sheet. This Table needs to be exported to a SharePoint list, every six hours.
So, I created the flow: Recurrence (every 6 hours) -> List rows present in a table (table from my Excel sheet) -> Get items (SharePoint list with correct row titles) -> For Each (Value from Excel) -> Update item (SharePoint list with each line mapped to the corresponding line from Excel Output).
Now, whenever I try to save this flow, PA adds in another "For each", so that the result, when I test the flow, is, that every line in my list ist filled with the data from every line in the Excel table.
i.e. Line 1 get filled with line 1, line 2, line 3
then Line 2 gets filled with line 1, line 2, line 3
then Line 3 gets filled with line 1, line 2, line 3
So the result is that every line in my list shows the last line from the table.
Please help, because I'm losing my mind over this.
An Excel Sheet has a table, that collects statistics from the sheet. This Table needs to be exported to a SharePoint list, every six hours.
So, I created the flow: Recurrence (every 6 hours) -> List rows present in a table (table from my Excel sheet) -> Get items (SharePoint list with correct row titles) -> For Each (Value from Excel) -> Update item (SharePoint list with each line mapped to the corresponding line from Excel Output).
Now, whenever I try to save this flow, PA adds in another "For each", so that the result, when I test the flow, is, that every line in my list ist filled with the data from every line in the Excel table.
i.e. Line 1 get filled with line 1, line 2, line 3
then Line 2 gets filled with line 1, line 2, line 3
then Line 3 gets filled with line 1, line 2, line 3
So the result is that every line in my list shows the last line from the table.
Please help, because I'm losing my mind over this.
Categories:
I have the same question (0)
All responses (
Answers (
