43
Hello
I want PAD to start writing everytime when i use write to excel to worksheet action for output such that it writes from row which is firstfreerow for all columns as my output data will contain dynamic data (sometimes some columns will be written , sometimes it not the case )
Thanks
Well, get the row to write to using Get first free column/row from Excel worksheet. I assume this is quite clear?
Then use a loop when writing your data. Loop through the values/columns in your data and keep incrementing a variable for a column index. Then use the column index in Write to Excel worksheet to specify the column to write to.
The specific way in which to build the loop depends on the data you want to write. If the above is not clear/detailed enough, please provide more context as to what sort of data it is, and we can then help you out with a more specific explanation.
-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.
I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.
Share
Report
All responses (
Answers (
