Is there a means for identifying the last column in a spreadsheet and stopping a process at that column in a desktop flow and continue with other steps?
Working with a spreadsheet that has a variable number of columns every month, I setup a flow to do a calculation on each column.
Essentially, it is one calculation that is copy/pasted across a range.
All is well in the first run, however, with a variable number of columns every month it will only work if the same number of columns are present every month.
I need it to simply stop at the last column and continue with other steps in the flow.
Any thoughts on how I might approach this would be a huge help.

Report
All responses (
Answers (