For those Velixo users who are also connected to Microsoft Teams there is a great opportunity to get the most of this integration. Storing reports in the cloud and sharing them across the organization can now be performed in the most straightforward way.

Using Teams when running your Scheduled Reports Distribution

A major advantage you can obtain from this integration is that your Report Distribution List can be significantly shortened by having just one link to the team’s channel - and no one is missed out!

Below is a distribution list for a monthly report, which must be distributed to seven people from the organization.

blobid5.png

Suppose you have those seven people in your team’s channel. And that’s how your distribution list can look:

blobid6.png

You can use the following links to Teams in your distribution list:

Path to the SharePoint folder

Considering that a file available in Teams is stored in a folder on a SharePoint site, you can choose the required folder and click Copy Link on the Ribbon to get a link to a SharePoint folder:

blobid7.png

and use it as a Folder Path in your Distribution List:

blobid8.png

Once the report distribution is completed, the report will be available in Teams in the Files tab of your channel:

blobid9.png

Limitations:

  • Velixo Reports cannot detect if your file already exists in SharePoint or if it is in use. The file you specify will always be overwritten when your distribute your report.

  • It is not possible to password-protect a PDF file when saving it to a cloud storage location (an error message will be displayed).

Email address of the team’s channel

If any comments must be provided with a distributed report, instead of using a folder path you can use the email address of your channel as an Email To parameter in the Distribution List. The channel’s email address is available from the context menu:

blobid10.png

Here is an example of Distribution List with email address specified:

blobid11.png

In this case a separate post will be added to the Posts tab of your channel:

blobid12.png

The report will be stored in EmailMessages folder within the Files tab:

blobid13.png

Permissions management in Teams

By default, all shared files in Teams have read-write permissions for every member of the channel. In case you want to share a report, for which any changes are undesirable, you can set up read-only permission in SharePoint.

To do that, open files in SharePoint:

blobid14.png

On a SharePoint site click the kebab menu: (

blobid17.png

) for the required file or folder and select Manage Access:

blobid15.png

You have a variety of options to configure the preferred set of access rules:

blobid16.png

Note: when you add or remove users from a team, their access is also added or removed from the SharePoint site.

Note: changes are saved instantly. You always have the latest version of the document, whether you are in Teams or in SharePoint Online.

Did this answer your question?