Hello everyone,
I am struggling to get the last steps of my flow to work correctly. What I am attempting to create is a flow that will take an Excel document from a regularly scheduled email, take the content from it and the write it to a specified Google Sheet document. I have got it about 90% of the way, the flow will write to the sheet, but it only writes to the __PowerAppsId__ column in my Google sheet and does not write the actual content from the Excel table.
My flow so far:
-When a new email arrives (V3) (working)
-For Each Attachment Loop
-- Get attachment (V2) (working)
-- Create File (Onedrive for business) (Working)
-- Delay 10s
-- Get file metadata (Onedrive for business) (Working)
-- Create table (Excel online business)
-- List rows present in a table (Excel online Business)
-- Apply to each loop
---Insert Row (Google Sheets)
I believe the issue is with the insert row step. I cannot select the names of the columns I specified in the create table step.
For the create table step, my inputs are -
Location - OneDrive for Business
Document Library - OneDrive
File - Id (from get metadata step)
Table Range - A1:D800
Column Names: Mail Name, Number, Year Of Birth, Primary Email
For the list column steps, my inputs are -
Location - OneDrive for Business
Document Library - OneDrive
File - Id (from get metadata step)
Table - body/name (From the create table step)
For my Apply to each loop, my input is body/value from the List rows step
For the Insert row step, my inputs are -
File - Google Sheet file location
Worksheet - Sheet1
I have advanced parameters for Name, Membership Number, Year of Birth and Primary Email, but I cannot dynamically select the column names stated in the Create tables step, they are not options when I look through the list provided.
Ideally, I'd like the new content to override any current content in the Google Sheet as well so that the content does not just get added to the end.
Can anyone please give me any advice on what I should do to fix this issue?
