Adding data to Excel from template

(0) Share

Report

Posted on by Community Power Pla...

Hi I'm trying to interact with a newly created Excel file from a template, but nothing is really happening.
When my trigger are activated I'm creating two folders, and in one of them I want to add a Excel spreadsheet from a template. I got that working. I'm also able to create a table. But as far as I understand by watching videos if I then need to add data into the new table I'll need to use Key Column and Value. As I understand. that needs to be predefined in the spreadsheet. Like, look at the row where Key column == No and Value == 1, and then fill out the fields like { "GlobalID" : "123"} But if I don't have a key culumn with a key value how do I then proceed?
Thanks

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Community Power Pla... on at

Like (0)

Report

Re: Adding data to Excel from template

Instead of using Update row, I should use Add a row into a table

Was this reply helpful? Yes No