The Internal Event provides the capability for admins to execute code that should occur after a column is updated on a file or folder in the internal sFiles component (shown below).


After a column is updated on a file or folder in the internal sFiles component, the component will fire an Internal_Event__e platform event of type "ColumnUpdate".

NOTE: Columns are updated in the following instances:

1. When a file is uploaded
2. When a folder is created
3. When the "Edit Values" feature is used

Prerequisites

1. sFiles version 1.50.1 or later installed.
   1. Visit sFiles on the AppExchange and click "Get it Now" to update to the latest version.

Trigger Code 

Create a trigger for the Internal_Event__e platform event. The following example shows a trigger when a column change occurs:

trigger InternalEventTrigger on fileforcem1__Internal_Event__e (after insert) {
    
    for(fileforcem1__Internal_Event__e event : Trigger.New){ 
        if(event.fileforcem1__Type__c == 'ColumnUpdate'){
            String fileName = event.fileforcem1__Item_Name__c; //Name of File Modified
            String recordId = event.fileforcem1__Record_Id__c; //Salesforce record associated with the action
            String eventContent = event.fileforcem1__Event_Content__c; //Metadata of file updated
            fileforcem1.SharepointFileInfoHistory updatedFile = (fileforcem1.SharepointFileInfoHistory)JSON.deserialize(eventContent,fileforcem1.SharepointFileInfoHistory.class); //SharepointFileInfoHistory of file updated
            //Do Something with Information After Column Change
        }
    } 
    
}

Fields on the ColumnUpdate Internal_Event__e Event 

FIELD	DESCRIPTION
User_Id__c	The Salesforce User Id that caused the event.
Type__c	"ColumnUpdate"
Site__c	The SharePoint site Id associated with the action.
Document_Library__c	The SharePoint document library associated with the action.
Record_Id__c	The Salesforce record associated with the action.
Item_Name__c	The name of the associated SharePoint file.
Item_Id__c	The SharePoint Id of the associated file.
Event_Content__c	JSON serialized file metadata that can be deserialized as fileforcem1.SharePointFileInfoHistory NOTE: To retrieve the NewItemInfo parameter, you will need to add LogColumnUpdate to the related SharePoint Object Settings' Feature Permissions.
Source__c	The API name of the sFiles component:  fileforcem1-browser-enterprise = sFiles Enterprise Component  fileforcem1-browser-standard = sFiles Standard Component  fileforcem1-browser-community = sFiles Full Feature [Per-User Only] Component