I use Power Automate (not desktop version). My flow seems simple:
- Every weeks
- Copy file (From folder A to folder B in the same SharePoint). Replace existing file.
- Run a script in the file (removes duplicated emails and removes columns)
Only Copy file works. I tried to split the script in two: First script removes duplicated emails. Second script removes column. No success.
Here is the first script:
function main(workbook: ExcelScript.Workbook) {
let selectedSheet = workbook.getActiveWorksheet();
// Remove duplicates from range A:AF on selectedSheet
selectedSheet.getRange("A:AF").removeDuplicates([10], false);
}
Here is the second script:
function main(workbook: ExcelScript.Workbook) {
let selectedSheet = workbook.getActiveWorksheet();
// Delete range B:F on selectedSheet
selectedSheet.getRange("B:F").delete(ExcelScript.DeleteShiftDirection.left);
// Delete range G:G on selectedSheet
selectedSheet.getRange("G:G").delete(ExcelScript.DeleteShiftDirection.left);
// Delete range H:L on selectedSheet
selectedSheet.getRange("H:L").delete(ExcelScript.DeleteShiftDirection.left);
// Delete range K:Q on selectedSheet
selectedSheet.getRange("K:Q").delete(ExcelScript.DeleteShiftDirection.left);
// Delete range M:N on selectedSheet
selectedSheet.getRange("M:N").delete(ExcelScript.DeleteShiftDirection.left);
}
Have you any recommendation using Power Automate online or the desktop version?