SOLVED Help with Office Script to convert a Table to UPPER case

Hi guys,

I'm a complete noob so please bear with me. What I need is an office script (as this needs to be run from a Power Automate flow).

I have a table which contains my data (which has been extracted by the flow).
It's a requirement that the data is converted to UPPER case. This is what I'm stuck on.

Please Login or Register  to view this content.

This was created using the "Record" function in O365 Excel.
1. I create a new worksheet.
2. Target A1
3. =UPPER(Extract) <-- name of table is Extract.
4. I manually selected the cells that make up the table.
5. Pasted values into original sheet (called Table) cell A2.
6. Delete the temporary worksheet.

It works... kinda! However, I need a way to only copy the cells that contain the UPPER data (from new worksheet). As you can see, it selects the range A1:AQ12 because at the time of recording, there were 12 rows and 43 columns.
The number of rows is dynamic, sometimes it will be more than 12 or less. The number of columns is always going to be 43.

What I'm looking for ultimately is for an office script that will replace the data in my main worksheet with UPPER case characters.
And as I mentioned, it needs to be an office script as that's a function that can be run from Power Automate (this is an automation I'm building).

Any help would be great.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. As you are new here, I have done it for you this time.)

Welcome, the Office Scripts docs are here. Check out the API reference. It has a lot of examples. There is also a lot of Excel samples. Converting to upper case is a Typescript/Javascript method. Just need to make sure it is a string since it can be a number. I've learned Typescript a while back since I wanted to do a React project. There is a good course on Udemy. It goes on sale all the time.