cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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?

2 REPLIES 2
Highlighted
Microsoft
Microsoft

Re: row 1 formula changing when row 2 is added

Hello,

 

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?

 

Highlighted
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:

BenDonahue_0-1594037360592.png

 

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

BenDonahue_1-1594037440340.png

 

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

BenDonahue_2-1594037560112.png

 

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:

BenDonahue_3-1594038108308.png

 

 

 

Helpful resources

Announcements
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)