Add row into table - cell reference get moved after adding it

%3CLINGO-SUB%20id%3D%22lingo-sub-862661%22%20slang%3D%22en-US%22%3EAdd%20row%20into%20table%20-%20cell%20reference%20get%20moved%20after%20adding%20it%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-862661%22%20slang%3D%22en-US%22%3E%3CP%3Efollowing%20issue%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ei%20have%20an%20excel%20with%20several%20sheets.%26nbsp%3B%20(excel%20is%20located%20on%20onedrive)%3C%2FP%3E%3CP%3Esheet%201%20contains%20a%20table%20which%20get%20populated%20with%20data%20coming%20from%20MS%20flow%20(add%20a%20row%20into%20table)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESheet%202%20references%20to%26nbsp%3B%20cells%20on%20Sheet%201%26nbsp%3B%20--%26gt%3B%26nbsp%3B%26nbsp%3B%20e.g.%26nbsp%3B%26nbsp%3B%20%3DSheet_1!%24%3CSTRONG%3EB%24287%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethe%20problem%20is%20%2Cthat%20whenever%20flow%20addsa%20row%2C%20the%20reference%20on%20sheet%202%20get%20changed%20to%26nbsp%3B%20%3DSheet_1!%24%3CSTRONG%3EB%24288%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eso%20how%20can%20i%20add%20flow%20data%20to%20an%20excelsheet%20and%20at%20the%20same%20time%20reference%20to%20these%20cells%20within%20other%20sheets%20%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethank%20you%3C%2FP%3E%3CP%3Estefan%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-862661%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Super Contributor

following issue:

 

i have an excel with several sheets.  (excel is located on onedrive)

sheet 1 contains a table which get populated with data coming from MS flow (add a row into table)

 

Sheet 2 references to  cells on Sheet 1  -->   e.g.   =Sheet_1!$B$287

 

the problem is ,that whenever flow addsa row, the reference on sheet 2 get changed to  =Sheet_1!$B$288

 

so how can i add flow data to an excelsheet and at the same time reference to these cells within other sheets ?

 

thank you

stefan

0 Replies