Applies to: Event Management for Office 365/SharePoint online
Follow this guide if you only want to show events to specific target audiences, if you want to decide per event if the event should be visible to all users or just to specific users or groups. This guide describes how to do this using Power Automate. This Power Automate flow can be used to set unique permissions on items depending on the users or groups entered in a Person or Group column.
Create the Target Audience column
First you have to create a new Person or Group column in the Scheduled Events list that can be use to specify the target audiences.
Make sure Allow selection of Groups and Allow multiple selections is enabled.
We also need to use the internal column name in the Power Automate flow to get the users and groups specified. To get the internal column name, click on the new column header and click on Filter.
Now select @Me and click on Apply.
In the URL you can now view the internal column name in the FilterField1 query string parameter.
We need the internal column name later when creating the Power Automate flow.
The Power Automate Flow
To make it easier for you to configure the flow, we created a flow template that you can import into Power Automate.
Open Power Automate, click on My flows and then on Import.
Select the downloaded flow template ZIP package and click Import.
Now you have to change the resource connections. In the IMPORT SETUP column click on Select during import and create new connections for all resources.
Now click on Import.
After importing the workflow, click Open Flow at the top.
Update the trigger and the 2 following actions. In the trigger, select your Event Management website and the Scheduled Events list. In the Initialize variable Site URL action, also enter the URL of the SharePoint website and in the Initialize variable TargetAudienceColumnName action, enter the internal name of your Target Audience column (see above).
Also review all the other steps to make sure they meet your needs. The flow starts whenever an event is created or changed. If users or groups are specified in the target audience column, this breaks the permission inheritance and separate permissions will be assigned to the event. The website owners and members always receive permissions. In addition, the specified users and groups will receive Read permissions. If the user column is empty, permissions will be inherited from the parent level.
After you have updated the flow, save it and click on the arrow at the top left to go back to the flow overview. Here you can activate the flow by clicking on Turn on.
Now click on Edit again to test the flow via Test / Manually. Simply create a new event in the Scheduled Events list and enter one or multiple users or groups in your target audience column.
I hope you found this guide useful. If you have any questions, please send an e-mail to [email protected].
