Is it possible to automatically send an excel export from Copilot for Security to someone's email, using logic apps?

ikkikevin1 0

Hey dear community!

Currently, I am working in Logic Apps with a Copilot for Security prompt action. This prompt action will ask copilot to generate a top 10 list of something and export it as an excel file as an output. Is it possible to store this excel file output as an attachment for an Outlook action? If so, how to do this? If not, got any alternative ideas how to solve this problem?

I know what the standalone Copilot for Security is able to generate an excel file once you ask a top 10 of something, but whether that works in Logic Apps, I cannot seem to get it work...

Deepanshukatara-6769 10,455 Reputation points

2024-09-30T07:47:09.1566667+00:00
Hello , Welcome to MS Q&A

To store an Excel file output as an attachment for an Outlook action in Logic Apps, you can follow these general steps:

Use an Excel Online (Business) connector to get the Excel file output.

Use a Create blob action from the Azure Blob Storage connector to create a blob for the Excel file output.

Use a Send an email action from the Office 365 Outlook connector to send an email with the Excel file output as an attachment.

Here are more detailed steps:

In the designer, add an Excel Online (Business) connector and configure it to get the Excel file output.

In the designer, add a Create blob action from the Azure Blob Storage connector and configure it to create a blob for the Excel file output. Use the dynamic content from the Excel Online (Business) connector to get the Excel file output.

In the designer, add a Send an email action from the Office 365 Outlook connector and configure it to send an email with the Excel file output as an attachment. Use the dynamic content from the Create blob action to get the blob URL, and use the Attachment Name and Attachment Content properties to add the Excel file output as an attachment.

References:

Tutorial: Create workflows that process emails using Azure Logic Apps, Azure Functions, and Azure Storage

Connect to Log Analytics or Application Insights from workflows in Azure Logic Apps

Kindly let me know if anything else needed

Please accept answer if it helps

Thanks
Deepanshu
ikkikevin1 0 Reputation points

2024-09-30T08:16:25.0833333+00:00

Hey!

Thank you for your reply.

The problem is a bit more sophisticated. Let me give a bit more context. Nowadays, you have Copilot for Security, which is able to generate an excel file with the results from the prompt (see image below)

The idea is that now, I want to do the same within Logic Apps, in which I use the Copilot for Security action instead to get the reporting. However, when I ask copilot to generate the excel file, I don't know how to get it attached in the Outlook action.

How can I do this?

1 answer

MayankBargali-MSFT 70,536 Reputation points

2024-10-03T04:46:46.6+00:00

@ikkikevin1 Thanks for reaching out.

As per the document Submit a Copilot for Security prompt returns the EvaluationResult json object.

You can validate what data you need from the response of this action and leverage the Create CSV table action and pass the array of your json object for which you want to create the table.

Now use the output of this Create CSV table action and use it in your Send an email (v2) action

and add the attachment name and content to this action.

Workflow:

Submit a Copilot for Security prompt --> Create CSV --> Send an email (v2)

In the below screenshot I have used the HTTP trigger action and then createArray but you need to pass the customized output of your Submit a copilot action with the createArray if the json is already of type array. The best way to find it to run your flow and validate the run history what is the output you are getting from this action and what value you need in your table and if it needs any customization (using other action) to make it as per the array json object.

Feel free to get back to me if you need any assistance.

Please 'Accept Answer' if it helped so that it can help others in the community looking for help on similar topics.
Please sign in to rate this answer.
ikkikevin1 0 Reputation points

2024-10-03T07:38:29.13+00:00

Thank you for your reply and sincere help!

I tried to add EvalutationResult from copilot to the Creat CSV table action, but that option is not available...what should I fill in instead?

MayankBargali-MSFT 70,536 Reputation points

2024-10-04T14:38:29.73+00:00

@ikkikevin1 Please test your flow and check the output of your Submit a copilot action and you will find the sample response which is generated. In case if it doesn't populate the fields in the UI you can leverage the output function to get the output from your action and take only the response that you needed.

ikkikevin1 0 Reputation points

2024-10-09T11:46:35.4433333+00:00

Could you please perhaps elaborate a bit more how I could do this? I'm a bit confused how to execute the test...
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Is it possible to automatically send an excel export from Copilot for Security to someone's email, using logic apps?

1 answer

Your answer