Exporting Tables & Visualising Data

(3) Share

Report

Posted on by boww1

We want to evaluate whether Copilot Studio can automate data-related tasks, such as exporting a structured table into an Excel spreadsheet and generating graphical representations of the data. The goal is to determine if Copilot Studio can effectively process, format, and visualise data without manual intervention.

our key focus areas include:

Exporting structured data (e.g., tables) into an Excel file.
Generating graphs or charts based on the data within Copilot Studio.
Assessing feasibility, ease of implementation, and practical use cases.

Categories:

Bot extensibility

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

sandeep_angara 430 Moderator on at

Like (1)

Report
Copy link

Link copied!

@boww1

You can write an office script that gets data within the worksheet and create visualizations. An office script can be invoked through Power Automate flow and get outputs (in this case charts) and show them in Copilot Studio using media control or adaptive card. Ensure you get the image in base64 format so that image or adaptive card actions can render them.

If this answers your question, please mark this as verified.

Was this reply helpful? Yes No
boww1 27 on at

Like (0)

Report
Copy link

Link copied!

hi @sandeep_angara, is there a way I can utilize the Generative Answers or Azure OpenAI?

Scenario:

Agent: here are some table.

User: export that to excel.

Agent: click this link to download the file.

this is the scenario that we wanted to try

Was this reply helpful? Yes No