topic Re: Excel to Teams in Qlik Automate

Excel to Teams

Rfoot — Wed, 08 Feb 2023 21:31:26 GMT

Hi,

Is it possible to send an excel sheet to teams?

Currently, I am getting data from a straight table putting into an excel file, saving to my onedrive then trying to send that excel into teams.

Regards

Re: Excel to Teams

Shai_E — Sun, 12 Feb 2023 16:47:53 GMT

Hi Team,

From reading the documentation for the "Send Message" Microsoft Teams block, it seems like this might be possible, if the file is in share point (must be on SharePoint), you can use the Microsoft SharePoint block "Get Item" to get the attachment details for your excel file, in order to add it to the "Send Message" block attachments field.

Link to the documentation (See example 4):

Send chatMessage in a channel or a chat - Microsoft Graph v1.0 | Microsoft Learn

@AfeefaTk , did i understand this right?

Re: Excel to Teams

AfeefaTk — Mon, 13 Feb 2023 08:31:31 GMT

@Shai_E Yes, I think you are correct

@Rfoot We are investigating if it's possible to use the existing "Send Message" block to send attachments that are already available in SharePoint.

We will get back to you as soon as we have an update

Thanks

Re: Excel to Teams

AfeefaTk — Fri, 24 Feb 2023 09:20:03 GMT

Hi @Rfoot

We managed to use the "Send Message" block to send files that exist in SharePoint.

I have created an example automation to show this approach

Please try it out and see if that works

More information on importing automation can be found here.

Hope this helps

Thanks