Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I am pulling images from power automate into excel using the following Run script code:
function main(workbook: ExcelScript.Workbook, sheetName: string, address: string, base64ImageString: string) {
let sheet = workbook.getWorksheet(sheetName);
let range = sheet.getRange(address);
let OldDevSNimg = sheet.addImage(base64ImageString);
for (let i = 0; i < 3; i++) {
let nextcell = range.getOffsetRange(+1, 0);
OldDevSNimg.setTop(nextcell.getTop());
OldDevSNimg.setLeft(nextcell.getLeft());
OldDevSNimg.setWidth(300);
OldDevSNimg.setHeight(400);
OldDevSNimg.setLockAspectRatio(true);
OldDevSNimg.setPlacement;
OldDevSNimg.incrementTop(3);
OldDevSNimg.incrementLeft(5);
}
}
The Power Automate flow is sending a column with multiple images from a SharePoint list which need to be put on their respective rows... The issue I'm having is each image comes across and is placed on top of one another.
I am struggling with a for loop or some way to dynamically change to the next row (in the same column) for each image coming across from power automate.
Or, is there a way to put a function in the 'Address' area of the Run Script action which will automatically move to the next excel row for every item in the 'Apply to each' action?
Any help would be greatly appreciated! Apologies as I am new to Type Script / Power Automate and just can't get the right syntax or expression.
Thanks in advance!
Solved! Go to Solution.
Hi, @Syndicate_Admin
It seems that your question has been solved in other forums and I am quoting the solution here to help the community.
Here is the original answer:
This small example will start from cell A3 and keep offsetting down to the next row for 5 loops ...
function main(workbook: ExcelScript.Workbook)
{
let worksheet = workbook.getActiveWorksheet();
for(var i = 1; i <= 5; i++) {
var nextCell = worksheet.getCell(2, 0).getOffsetRange(i, 0);
nextCell.setFormula("=ROW()");
}
}
... getOffsetRange is moving from A3 by the amount of rows during each loop.
So this line of yours ...
let nextcell = range.getOffsetRange(+1, 0);
... really needs to factor in the iteration from your for loop (i.e. the value of i).
It should be more like this ...
let nextcell = range.getOffsetRange(i, 0);
... and your for loop should start from 1, not 0 ...
for (let i = 1; i <= 3; i++)
... something like that.
refer:
Office Script (TypeScript) code to advance one cell every time the code runs
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @Syndicate_Admin
It seems that your question has been solved in other forums and I am quoting the solution here to help the community.
Here is the original answer:
This small example will start from cell A3 and keep offsetting down to the next row for 5 loops ...
function main(workbook: ExcelScript.Workbook)
{
let worksheet = workbook.getActiveWorksheet();
for(var i = 1; i <= 5; i++) {
var nextCell = worksheet.getCell(2, 0).getOffsetRange(i, 0);
nextCell.setFormula("=ROW()");
}
}
... getOffsetRange is moving from A3 by the amount of rows during each loop.
So this line of yours ...
let nextcell = range.getOffsetRange(+1, 0);
... really needs to factor in the iteration from your for loop (i.e. the value of i).
It should be more like this ...
let nextcell = range.getOffsetRange(i, 0);
... and your for loop should start from 1, not 0 ...
for (let i = 1; i <= 3; i++)
... something like that.
refer:
Office Script (TypeScript) code to advance one cell every time the code runs
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.