Unanswered

How to Rename worksheet name

(0) Share

Report

Posted on by Priyanka03

I'm trying to create table but it says the error message status code 400 invalid arguments. My worksheet name is SLA Breach Output as its space inbetween so i used replace(SLA Breach Output ,' ','') and it is not working. Kindly confirm what went wrong.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (2)

Pstork1 68,697 Most Valuable Professional on at

Like (1)

Report

There is no action available in Power Automate to rename a worksheet. But you can remove the spaces when you use the worksheet name to create the table. Instead of replacing the spaces with an empty string I would suggest replacing them with an underscore '_'. However, I think the issue you are having is because of your Table Range setting not the table name. if the Worksheet name has spaces in it all you need to do is surround the variable holding the name with single quotes when specifying the range. Like this

Was this reply helpful? Yes No
Priyanka03 on at

Like (0)

Report

I tried the exact format as like you but it still says that Status 400 error: The argument is invalid or missing has incorrect format.

Was this reply helpful? Yes No
Verified answer

Priyanka03 on at

Like (0)

Report

@Pstork1 ,

I tried like this and it is working fine.
=OFFSET('SLA Breach Output'!A1,0,0,SUBTOTAL(103,'SLA Breach Output'!$A:$A),3)
Thank you

Was this reply helpful? Yes No
Verified answer

Pstork1 68,697 Most Valuable Professional on at

Like (1)

Report

If the worksheet name is in a variable you can replace everything inside the single quotes with the variable and it will work also.

Was this reply helpful? Yes No