Showing results for 
Search instead for 
Did you mean: 
New Member

Copy cell values (range) from a table in worksheetB to cells in worksheetA

Hi All,


I have a flow that creates an excel file, from a template, on creation of an item in a Sharepoint list. The items from the list are then inserted to a table in a (hidden) worksheet - worksheetB,  Once the item values are added to the worksheet table, I want them to be copied to another worksheet - worksheetA. 


The direct lookup (=worksheetB!I4) pre-inserted in worksheetA does not seem to return any values as creating the table range seems to change the cell in the lookup in worksheetA. So, rather thank looking in "worksheetB!I4" it changes the lookup to "worksheetB!I6" and thus returning 0 values.


Any ideas how I can get round this, to pull the values direct from the table range? Is this even possible? 


Any help would be great appreciated as I've tearing my hair out with this.


Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Users online (1,217)