Unanswered

Create columns in excel table dynamically. And, How to read an excel table row-wise and then column-wise for each row, and send data to SQL table

(0) Share

Report

Posted on by adibaba07

Hi All,

I have an excel file which has a fixed number of columns, from where I read row by row in Power Automate when I am trying to upload its contents. But now, I want to have the number of columns in my excel file to change/add columns depending upon a numerical value obtained which is a difference between a current date and the date provided (i.e. Number of Days).

For example, I have 5 fixed columns in my excel file. Now, my current date is December 1, 2021 and date provided is December 10, 2021. So, Power Automate should create (10-1)+1 columns extra in my excel with the dates as headers.

After this file is created, and the records are updated, I want to read this excel table in such a way that Power Automate reads the static data column values of each row and for that row it reads the value against the dynamic Date columns and sends the data to SQL procedure.

Thanks & Regards,

Aditya

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

ScottShearer 25,278 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@adibaba07 Please see these two blog posts as they might help.

Adding columns not supported

Adding a key column

Was this reply helpful? Yes No
jedunn 123 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

If I understand your scenario correctly, I believe you could create a flow that has the Excel Run Script action to run an Office Script. This script can accept parameters from previous flow steps and evaluate date conditions to determine the number of columns to add. Then it would use the addColumn() interface to add the columns. You may have other steps in your flow that send data to SQL.

If that sounds like a feasible route, learn more about Office Scripts to get started.

Was this reply helpful? Yes No