Unanswered

Create en excel file and fill it with datas from an adaptive card

(0) Share

Report

Posted on by mad95

I'm trying to understand at a basic level how I can pass some data, harvested with an adaptive card, to a NEW Excel file in which this data will be stored into a table.

Example: I open up teams, write a word, an adaptive card pops up, I fill it, click submit, and an Excel file is created with a table in it where the data from the adaptive card will be stored. Is it possible? Because I've reached this solution, but it's not correct. It creates a new label into an already existing Excel file and tries to fill it, but it fails. Even if it doesn't fail, this wasn't what I wanted...

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (0)

SanmeshG 1,947 Moderator on at

Like (0)

Report
Hi @mad95 ,

It is possible , I would suggest you to create a JSON object and pass it in the Add a Row action. This should look as below.

{ "Header1":"Dynamic Data From Adaptive Card1", "Header2":"Dynamic Data From Adaptive Card2", "Header3":"Dynamic Data From Adaptive Card3" }

I am not sure what is the step in you current screenshot as the language is not English

Was this reply helpful? Yes No
mad95 28 on at

Like (0)

Report

ops, sorry, in order the excel actions are "Create worksheet","create table", "add a row into a table"

Was this reply helpful? Yes No
SanmeshG 1,947 Moderator on at

Like (0)

Report

Hi @mad95 ,

Yes that is one way else you can have a file with a table and use the file content of that table and create that file and pass the JSON object in the add a row action.

Hope this helps ,
Thanks!

Was this reply helpful? Yes No
mad95 28 on at

Like (0)

Report

but it isn't working...well it's almost working...at the moment i've managed to fine a way to insert the info into a pre-existing file, with a pre-existing table, but i want to be able to create that file from 0, with an empty table and then fill it...all throgh power automate,but i don't have the action Create File so...

Was this reply helpful? Yes No
SanmeshG 1,947 Moderator on at

Like (0)

Report

Hi @mad95 ,

1. You have to create a file with the same table(if the table headers are static) and store it in SP Doc Library or OneDrive and use the Get File Content Action and create a new file by passing the File Content from Get File Content action and then use the Add a Row action and pass the JSON object.

2. You can save a blank file in your OneDrive or SP Document Library and create a table by passing the table headers and then use the Add a Row action by passing the JSON object.

Was this reply helpful? Yes No