I have problem with Power Automate running Office Script...If i run the script manually through excel, it works fine..but on power automate,
We were unable to run the script. Please try again.
Office JS error: Line 7: Range getSurroundingRegion: The requested resource doesn't exist.
The script is to create table'
Can you share a screenshot of the excel script action and the full script please?
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
P.S. take a look at my new blog here and like & subscribe to my YouTube Channel thanks 😉
Do you have a value in the cell A1 or is it blank. Only if you cell is blank you will get the error.
Please add values in A1 and then try to run your script it should not give you an error.
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!