I have five checkbox in power apps, I am passing those value to office script using power automate, I want to setup the print area based on the true or false value of those checkbox.
If QFM31 is true, Set Print area to A1:F21 of Sheet 1,
If QFM32 is true, Set Print area to A23:F50 of Sheet 1
If Firstarticle is true, Set Print area to A1:F21 of Sheet 2
If Setupsheet is true, Set Print area to A1:F21 of Sheet 3
If Specsheet is true, Set Print area to A1:F21 of Sheet 4,
When multiple are set Print area accordingly for Example:
if both QFM 31 and QFM 32 are selected, set A1:F21 OF Sheet1 as page1 and A23:F50 OF Sheet1 as Page 2
I wanted to do like that for every possible combination for these five.
I tried following but it is setting up print area to all no matter which one are true.
function main(workbook: ExcelScript.Workbook,
QFM31: string,
Specsheet: string,
) {
if (QFM31) {
let sheet1 = workbook.getWorksheet('Sheet1');
sheet1.getPageLayout().setPrintArea('A1:F21');
sheet1.getPageLayout().setPrintArea('A1:F21,A23:F50');
let sheet1 = workbook.getWorksheet('Sheet1');
sheet1.getPageLayout().setPrintArea('A23:F50');
let sheet2 = workbook.getWorksheet('Sheet2');
sheet2.getPageLayout().setPrintArea('A1:F21');
let sheet3 = workbook.getWorksheet('Sheet3');
sheet3.getPageLayout().setPrintArea('A1:F21');
let sheet4 = workbook.getWorksheet('Sheet4');
sheet4.getPageLayout().setPrintArea('A1:F21');
