Microsoft Flow – SharePoint triggers and their limitations

Microsoft Flow is a great product that lets you trigger processes when items or files in SharePoint are changed. This works very well and better than in SharePoint Designer, however there are a few limitations that need to be addressed.

1. The Created or Modified trigger should give previous values for fields

When a flow is triggered on the modification of a list item or a file then it should be possible to get the current and previous values of the fields that were changed. So that when you want to check in a condition if the value of a specific field has changed you can do so

 

uservoice: https://powerusers.microsoft.com/t5/Flow-Ideas/Modified-trigger-should-give-previous-values-for-fields-changed/idi-p/94078

2. Being able to just trigger the flow when a specific field is changed

At the moment flows trigger when items are modified and it isn’t possible to filter on which modification was made. It would help if you could for example trigger a flow just when a field has been modified or not trigger if a specific field has been modified. Currently the workaround is to use a condition straight after the trigger, but that still adds a run history for the flow.

uservoice: https://powerusers.microsoft.com/t5/Flow-Ideas/Being-able-to-just-trigger-the-flow-when-a-specific-field-is/idi-p/94080

3. Triggers available for SharePoint.

Currently Flow offers 7 triggers. Some triggers are really missing.

  • When an item has been deleted
  • When a file has been deleted
  • When a site has been created
  • When a site has been deleted

And then there could of course be more, but these are the ones that I have been missing.

uservoice: https://powerusers.microsoft.com/t5/Flow-Ideas/Need-a-Sharepoint-trigger-when-a-list-item-is-deleted/idi-p/30050

4. Run a flow as …

As part of the trigger configuration it would be nice if it was possible to run the flow as a different user. Although I could also imagine that this could be implemented as a part of a scope in a flow

uservoice: https://powerusers.microsoft.com/t5/Flow-Ideas/Change-original-owner-of-a-flow/idi-p/94053

 

 

 

 

 

Advertisements


Categories:Flow, Microsoft Flow, Office 365, SharePoint Online

Tags:

3 replies

  1. Nice points.

    I think you will find the specific field in an item changed is a bit of a challenge as Share point appears to only ever write entire records in one operation. I could well be wrong but it does not just update one but the entire record.

    Run flow as could be tricky as you would need to ensure security from each action is good.

    Deletes definately.
    As for creation of new sites I think plimsail has that in it. However I am sure it will be part of new site designs. As you can run a flow from that when a site is created.

    Certainly nice if at least when the flow runs it picks up the previous values and has them in the log and necessarily as dynamic data items. As that might be confusing in the flow as to which is which value.

    Just my thoughts

    Like

  2. Hi There,

    Currently the workaround is to use a condition straight after the trigger, but that still adds a run history for the flow.

    Is there a tutorial or blog about this workaround?

    Regards,

    Rob

    Like

Please leave a comment or feedback

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: