Flow triggers 3 times when 3 files drop at once in a SharePoint folder – how do I prevent duplicate ADF pipeline runs?
My setup: flow triggers on “When a file is created or modified in a folder.” Every day, 3 files land in the same SharePoint folder around the same time. The flow fires once per file, so I get 3 instances running in parallel — all of them eventually pass my checks and all 3 end up calling my ADF pipeline.
I already have a Do Until loop inside that polls for all 3 files in that SharePoint folder and sets an AllFilesPresent boolean — but that’s a local variable, doesn’t persist across instances. So all 3 runs flip it to true independently and fire the pipeline.
I tried setting concurrency to 1 on the trigger so runs queue instead of going parallel, but that doesn’t actually help — they still all run through the logic sequentially and each one triggers the pipeline.
Is there a native Power Automate way to do this without needing an external list or flag file?