Showing results for 
Search instead for 
Did you mean: 
Resolver II
Resolver II

row 1 formula changing when row 2 is added

I am adding the following formula to every line that is added via flow:

=INDEX('RosterAndAssignments'!A2:E17,MATCH("FCN",'RosterAndAssignments'!E2:E17,0), 3)


The formula as it appears in my "Add a row into a table" block is this:

example of code in flow.png


When I add another row from the same form submission (I can add up to 5), the above formula changes to:

=INDEX('RosterAndAssignments'!A1:E16,MATCH("FCDLC",'RosterAndAssignments'!E1:E16,0), 3)

This is deprecated code that has been universally updated in my flow. 


In testing, when I manually added a dash to column A, data in other columns appeared. Note that column I has a version of the deprecated formula, with the dynamic value filled it so the formula is not being generated dynamically from Flow, but instead is hard-coded.

example of manually adding data to table.png


Where is this data coming from, and how do I stop it?


Re: row 1 formula changing when row 2 is added



Please check if the same formula works outside of power automate.

So, if you add multiple rows using same formula directly in excel, does it work?


Resolver II
Resolver II

Re: row 1 formula changing when row 2 is added

Yes, when I add that formula to other cells without using Flow, the formula works perfectly:



When I enter only one row using the form in Flow, it works perfectly, also:



When I add a second row using Flow, the formula in the first row changes:



When I directly add data to the first row, of a blank table, (in this case an "X" in column H), other values populate, including the deprecated formula:





Helpful resources

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Upcoming Events

Experience what’s next for Power Automate

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors
Users online (6,542)