Share via

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

ikkikevin1 0 Reputation points
2024-09-30T07:41:51.93+00:00

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...

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
3,124 questions
Microsoft Copilot for Microsoft 365 Development
Microsoft Copilot for Microsoft 365 Development
Microsoft Copilot for Microsoft 365: Microsoft 365 Copilot refers collectively to Copilot experiences within Microsoft 365 applications.Development: The process of researching, productizing, and refining new or existing technologies.
137 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. MayankBargali-MSFT 70,421 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.

    enter image description here

    enter image description here

    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.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.