web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Adding data to Excel f...
Power Automate
Unanswered

Adding data to Excel from template

(0) ShareShare
ReportReport
Posted on by

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

kelin84_0-1635862087203.png

 

Categories:
I have the same question (0)
  • Verified answer
    Community Power Platform Member Profile Picture
    on at
    Re: Adding data to Excel from template

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 497 Moderator

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 477 Super User 2025 Season 2

#3
chiaraalina Profile Picture

chiaraalina 242

Last 30 days Overall leaderboard