Office Scripts: Run Scripts for all Excel files in a folder using Power Automate

Check out the source code of this project and other projects at this site:
github.com/sumurthy/officescr...
(Note - use table.getRowCount() API instead of the one I'm showing in the video to check the number of actual data rows in the table)
Chapters
0:00 Introduction
1:50 Use Recorder to capture actions
3:00 Edit script
8:48 Setup Power automate flow

[@Ethan-dd4ln]

Great video Sudhi! Can’t wait for tomorrows Reddit event!

[@user-xi6px5xg4h]

This didn't work for me. Got an error on apply to each: An Action failed. No dependent actions succeeded.

[@MrKor4k]

What about folder in SP, Does ID work as well?

[@PrashantKg1996]

Hey Sudhi, I tried to do the same thing but on 35 files on SharePoint where the average file size of ~80 MB. My typescript adds a new sheet, puts 2 formulas, a date, and some formatting. Upon running the power automate, it seems that it runs on some files only not on all the files. I get the following error "We were unable to run the script. Please try again. Office JS error: Line 3: Workbook addWorksheet: The request failed with status code of 504, error code UnknownError and the following error message: clientRequestId: 70fe275e-1481-4323-8e8a-53fc63ef2bb9" Could it be that typescript won't run on huge files which can't be opened on excel online?

[@bienvantrang9702]

same here, i have more 20 files in folder but only 5-8 files run the scripts

[@arie.afritamaartadityaarta1743]

Hi... Can you give me code for automatically date and time in excel sharepoint?

[@movieclips7511]

please make more videos