I'm building a flow that will essentially take data from a SQL server (using Get Rows V2) and populate an existing Excel file with a table.
I'm having issues trying to get the output from SQL to populate the excel table. One part I have a feeling could be contributing to this problem is I want to use a friendly column name vs. what I currently have in SQL but I don't know what else could be missing. Does anyone have some thoughts how I could accomplish this? I'm interested in using this existing spreadsheet and pre-formatted table to allow our team to quickly print as needed.
If my understanding to your problem is correct; then it means you have an excel formatted as a table, so if I am correct you need to add and Apply to each loop to the output of Get Rows and then use Add Row in a table action as below:
Glad I was on the right track. I've added the apply to Each control, and this is the error I am being returned:
Everything up to that point looks good. I'm using the output from Select to add the rows into the Excel Table.
I'm following the guide here:
Since I need to use a pre-formatted table, I can't just create a table in a new file within the flow. That value in 'Table' is first(outputs('Get_tables')?['body/value'])['id'], where after the file is copied to Sharepoint I'm using an HTTP request to get the file ID to use in Get Tables in a previous action.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Read the latest about new experiences and capabilities in the Power Automate product blog.
If you are a small business ISV/Reseller, share your thoughts with our research team.