‘Get changes for an item or a file (properties only)’ action returns a boolean result. It checks each of the columns has changed or not in the SharePoint document library or lists. This action should be used when using the trigger ‘When an item or a file is modified.’
I got excited when this trigger and action were released. With this trigger, it would be easy to monitor only specific columns without additional conditions. Before using this trigger, you need to make sure the list and library version has enabled.
Requirements:
For example, HR will upload the documents to a document library. There are four columns in the document library: Employee Number, Department, Employee Name, and Status. When an Employee Number column is updated, it will send an email to the Manager. This document library should not be searchable. The name of the document library is Employee Documents.
Built a simple workflow using the trigger and the action, but we encountered an issue when the flow didn’t trigger. We run the flow manually, updated the document library where the flow was created, and waited. But the flow doesn’t run at all. We didn’t receive any error, only when the flow is timeout because it didn’t receive any trigger. Created the flow in another tenant because we thought that some error or issue might affect the flow, but it works successfully. We raised a Microsoft support ticket and found out the cause.
Cause:
Remember in the requirements that the document library is not searchable? We set the document library under List Settings >> Advanced Settings >> Under Search, we set the ‘Allow items from this document library to appear in search results’ to NO. These settings caused the trigger, not running.
As per Microsoft Support, the document library has been updated in the backend, but the flow doesn’t receive any trigger.
Resolution:
In the document library or lists, other than making sure that versioning is enabled, you set the ‘Allow items from this document library to appear in search results’ to YES.
#HappySharing
REference:
- When an item or a file is modified
- Get changes for an item or a file (properties only)
- Introducing ‘When an item or a file modified’ trigger and ‘Get changes’ action
- Flow when a SharePoint column is updated by Laura Rogers
- Run a flow when SharePoint column is modified by April Dunnam
Featured image by Miguel Á. Padriñán from Pexels