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
Solved! Go to Solution.
Instead of using Update row, I should use Add a row into a table
Instead of using Update row, I should use Add a row into a table
User | Count |
---|---|
95 | |
45 | |
21 | |
18 | |
18 |
User | Count |
---|---|
142 | |
50 | |
43 | |
40 | |
31 |