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 )
and
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.
Hi @JenVitug,
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:
Best regards,
Mabel Mao
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
User | Count |
---|---|
12 | |
11 | |
8 | |
6 | |
5 |
User | Count |
---|---|
19 | |
14 | |
11 | |
10 | |
9 |