Why does my flow create multiple items when I upload a new document to a SharePoint library

Question

For some unknown reason whenever I upload a new document to the document library, my background flow pulls the required data correctly but it creates multiple new items when it's only meant to create one in the list.

It seems to create as many new items in the list as there are files in the SharePoint library.

Can anyone see what I'm doing wrong.

Screenshots below.

Answer 1

You are using Get files (properties only) action which retrieves all files in mentioned library/folder. Then you are applying loop on all results/files >> This is the reason flow is creating multiple items for each file in folder/library.

---

If you are trying to get the properties of newly uploaded file, you should directly use "List rows present in a table" action in Power Automate like:

You need to pass the file Identifier from trigger to this action to limit the file.