Morning all,
Now... I dont *think* I'm doing anything wrong, but I reserve the right to be wrong 🙂
I have an Excel Spread sheet in a SPO Doc Library. (The name doesnt change) Called CCTest1.xlsx.
I need this sheet to both create and update an SPO list.
What I have thus far is:
Recurrance: every 1 week
List rows present in a table:
Location: *my site*
Document Library: Cost Centre Report
File: CCTest1.xlsx
Table: Table1 (yes, its there and Flow detects it automatically)
Apply to each:
Out put: value (from previous step(List rows))
Create Item:
Site Address: (same as above)
List: Cost Centres (List contains the exact same columns as the spreadsheet)
field1 = field1
field2 = field2
etc
Save.
Test.
Nothing. No new items are created in the list.