Sharepoint When a file is created or modified (properties only) Trigger Delay

[DSattelberger]

Hi all,

I've been working on a flow to update some custom columns in a document library.  It uses the When a file is created or modified (properties only) Sharepoint trigger.  The issue I've been having is that the trigger sometimes has a long delay, only running an hour or two after a change was made.

Flow Details:

Specifically, we have a file naming convention of the following format:

<code 1>-<code 2>-<code 3>-<code 4>-<code 5>-<file number>-<file description>

XX-XXX-XX-XXX-XX-0004-ShortFileDescription

Basically, we have custom columns in the document library to hold codes 1-5 and file description, and the flow needs to update them whenever a file is renamed.  I also have a custom column called Old_Filename, which holds the file's previous name.  This is used in a trigger condition to make sure the flow only runs when a file name has changed:

@not(equals(triggerBody()?['{Name}'], triggerBody()?['Old_Filename']))

Basically, the flow gets a file modification/creation, splits the filename into an array of its component parts, then updates the custom columns in the library with the new values:

Error Details:

I've been looking through the troubleshooting options in this page.

We are on the basic O365 plan, no Premium, etc.  It doesn't seem to be throttling, as it will run immediately if I manually resubmit a previous run.  For a while during testing, it wasn't turning up any checks at all, skipped or no, even in cases when it ran successfully (though some have started appearing in the last 20 minutes).

When I peek code out polling trigger interval is supposed to be set at every 5 minutes:

Any help would be appreciated.

Thanks!

[lbendlin]

Apart from the annoying delay, is there an actual error with your flow?

All these "triggers"  are not really triggers. They are lots of little polling machines that ask the source "has anything changed?"  "How about now?"  etc. incessantly.

[DSattelberger]

It has no errors, no, and as far as I can tell, for every case in which it's supposed to run it does do so eventually.  However, the PM is worried that the 1-2 hour delay will introduce errors from users further down the line.  We use the little codes to filter the list of existing filenames in a PowerApp, and they're worried users might use an existing filename because they don't realize it's already been used.

As far as I can tell from the Peek Code, the polling trigger is supposed to check every 5 minutes, which would be fine, but given the delay it doesn't seem to be doing that.

[lbendlin]

I think somewhere in the documentation there is mention of the SLA for this kind of stuff.  I don't think you'll find more than "best effort".  If you need a more reliable solution, look elsewhere.