I’m trying to create a flow where when a sub-folder is created in Sharepoint, a new row is added to an excel document which has the date created, name and link to the sub-folder.
Currently I have the trigger “When a file is created (properties only)” followed by the action “Add row to table”. The problem is this creates rows in excel for all the files inside the sub-folder as well which I don’t want.
Trying is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Add a Condition. In the Condition Parameters, check that the IsFolder property of the ‘When a file is created’ action is equal to true. Put your ‘Add a row into a table’ action in the ‘True’ branch of the condition.