Unanswered

Power Automate - Get File Content Action - picks up my excel table but not the tables contents?

(0) Share

Report

Posted on by User24689

I've got a CSV file transformed into Excel, and I'm looking to migrate that data to a different Excel template stored in a SharePoint library. Since I plan on reusing this template, I'm incorporating the details into it, then utilizing "Get File Content" and "Create File" to generate a copy of the template. Next, I'll clear the rows in the original template for future use. While the table transfers over to the new template successfully, the table contents aren't showing up. So two questions

1. Why wont the content appear?

2. Am I creating the best solution to the above? Is there an easier way - New to PA!!

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (0)

Garethterb1 131 on at

Like (0)

Report
Copy link

Link copied!

Hi, I'm a bit confused with the csv part of this question.
Are you using the Get File Content on an excel document that has a table with data in the table and then creating a new document using the Create File action using the content of the body of get file content as the content of the new file whilst ensuring that the name has .xlsx at the extension? if so the file should be an identical copy of the original file.

Was this reply helpful? Yes No
User24689 4 on at

Like (0)

Report
Copy link

Link copied!

My current workflow follows these steps:
Receive CSV attachments via email, which are always in CSV format.
For each attachment:
Convert the CSV file to Excel format using a third-party connector.
Create a new file with the converted content.
List the rows present in the original CSV.
For each row:
Use multiple compose actions to extract relevant data.
Add these rows to a blank Excel template stored in a SharePoint library. (Since I intend to reuse this template for each trigger of the flow, I proceed to copy it)
Get File Content (content of the original Template that is to be re-used)
Create File (using the file content from previous step) - This final created file has the table in but not the contents of that table that were added previously in the flow

Long story short what I'm trying to do is.
Retrieve CSV from ERP System
Convert to Excel (Our ERP Import for later stage will not accept CSV) and place this in an template that is suitable for a supplier to see ( Columns named better, formatted for import back into the ERP System etc)
Send to Supplier

Flow is probably overly complicated but googling my way through this!

Was this reply helpful? Yes No
Garethterb1 131 on at

Like (0)

Report
Copy link

Link copied!

Ok, that makes a bit more sense. I use excel templates for similar things. what works for me is the following, first save your template with its predefined tables in SharePoint, then in your flow.

Get the content of the template file using Get file content using path
Create a new new file with the content of the template.
Then for each of your csv rows Add a row into a table using
body('Create_file')?['Id'] as the File.

This way you keep your template in its original state and avoid conflicts if there are multiple runs ate the same time.

Was this reply helpful? Yes No
User24689 4 on at

Like (0)

Report
Copy link

Link copied!

What do I put in the row field?
Here's my flow so far

Was this reply helpful? Yes No
Garethterb1 131 on at

Like (0)

Report
Copy link

Link copied!

Hi.
In the row box you would put the row details that you want to add in JSON format. e.g.

{
"Text" : "SomeData1",
"General" : "someData2",
"Variable" : "@{body('Compose')}"
}
Where, Text, general and variable or my row headers in the table.

Was this reply helpful? Yes No