Answered

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

All responses (4)

Answers (2)

Sort by

Pstork1 69,661 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

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
Priyanka03 2 on at

Like
a
(0)

Report
Copy link

Link copied!

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.
Verified answer

Priyanka03 2 on at

Like
a
(0)

Report
Copy link

Link copied!

@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
Verified answer

Pstork1 69,661 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

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