How do specify a dynamic Range in Create Excel Table Action
Given: a SharePoint docu library with an Excel file
I need to create a new Sheet in the Excel file (triggered by a Form Request) (achieved SheetABC )
I need to create a TABLE in the Excel Sheet (SheetABC) that was created (how do i do this , i need to specify the Range in the Action and i want the range to be in SheetABC!$A:$H , the Sheet created in the previous step.
According to your description, I tried to create a flow format the sheet created in the previous step to a table with the range to be $A:$H. However, it returned error message said that “A table cannot overlap another table”.
Per my certain research, I am afraid that dynamic content in Table name field has not been supported yet. As in my flow, in order to use get the worksheet created in the previous step, I have to use the dynamic content from the previous action. So it failed.
Besides, I have seen a similar request on Flow Ideas Forum, please vote the idea at here, PGs will take hot ideas into consideration first in the future releases: