Hi,
I am new to power Automate and I am trying to Automate some excel automation.
I have an Excel which has 3 sheets in it. One of the sheet(sheet A) has some information regarding the PTO dates of team, Approver and Status column. I have to create a new sheet with approver's name if Status column is empty. ( I am able to achieve this for the first time). If the sheet is already there then I need not create a new sheet. I am using Get All work sheets activity, then using for each loop and inside the loop I am writing if condition. If sheet exists then do nothing, else Add work sheet. But the problem here is it always trying to execute else part. and throwing error. Is there a way I could resolve this.
Thanks in advance.
