cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dwalker97
Helper II
Helper II

Error: Excel Get row Key Value outputting wrong row (row below)

Hi,

 

I am reading in an Excel table, each row has an ID ranging from 0-100. I write the table to an array, loop through the array, and if a condition is I use Get Row to retrieve more info from the same table. (There are other reasons for me using this method)

 

The problem is that the correct row (ID column) is specified as the Key Value, although in the output the row selected is ID+1. The example here is that I specified ID 31 and the output ID to Get was 32. 

 

Is this a bug? This only happened to 2 rows out of 20.

 

dwalker97_0-1652263245261.png

 

Thanks!

0 REPLIES 0

Helpful resources

Announcements
October Events

Mark Your Calendars

So many events happening this month - don't miss out!

 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Users online (4,024)