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.
@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
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.
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
Share
Report
All responses (
Answers (
66,797
