Excel Workflow Set Permission plug-in properties

«Back to Plugins Table

Related Topics

The Excel Workflow Set Permission Plug-in enables you to set read-only permissions for the users or groups associated with the Data File and/or Supporting Documents in the custom workflow.

Notes:

  • It is recommended that you add the plug-in in the beginning of the workflow so that the supporting documents and data files are locked throughout the process.

  • If you need to add the plug-in after the Start node, then you must add the Wait plug-in or an activity between the Start node and the Excel Workflow Set Permission plug-in.

  • You must republish the solution after adding the plug-in.

Prerequisite:

If the Excel Workflow Set Permission plug-in is added after Start Node, add an activity or the Wait plug-in before the adding Excel Workflow Set Permission plug-in.

Parameters:

Permissions
  • Read: Sets the Read permission. You can select if you want to set the permission for Data File, Supporting Document or both, by selecting the radio buttons corresponding to them.
  • Inherit from Parent: Resets the unique permissions and inherits the permissions of the that Data Library.

DataFile

Select the Yes radio button to set permissions for the Data File.

SupportingDocument

Select the Yes radio button to set permissions for the Supporting Document.

Behaviour when Allow Replacement property set to True

If the Allow Replacement property has been set to true, the assigned user will be able to make changes and complete the tasks related to a read-only data file.

Behaviour when Allow Replacement property set to False

If the Allow Replacement property has been set to false, the data file will open in read-only mode and the assigned user cannot make any changes, but they can complete the task.

Known Issues and Limitations

  • Any user can delete the Supporting Doc using Manage Supporting Documents in Winshuttle Excel Addin if the Allow Replacement property is set to true.

  • The Approve or Reject buttons for custom Excel workflow tasks are not visible to the user when the Data File is opened directly on a browser from the SharePoint document library interface in Excel.

  • For Team from Role type task with Allow Replacement property set to True, the second user is notified if file is already checked-out by another user.

  • Version history is not maintained for the archived data files.

  • The Data Files set to read-only permissions using this plug-in, loose properties when the Move Archived Data job is run.

  • The Data file originator can create a file version with changed data, even when the Data File has been set to read-only permissions using this plug-in.

  • Users can update metadata using the Set Column plug-in even if the Data File is set to read-only using this plug-in.

  • Users can perform a manual run of the task even after the Data file is set to read-only, by using the plug-in.