I have a flow that does the following
- When a spreadsheet is added to a library
- Create a table in that sheet
- Get the list items from that table
- For each list item, create an item in a SharePoint list
I want this flow to be automated that is triggered when a file is added to the library. This only works when I select to do a manual test, and runs as expected. Otherwise the flow will not run.
I've made a copy of the flow that is activated by a button, as an exercise, and that works every time.
