Question: Regards excel spread sheets

Anonymous · ‎04-27-2020

Hi,

My situation is this.

I have a large spreadsheet that I need to parse and process.

To test PA I have done :-

Made the change to settings of list all rows to exceed the 265 limit.

Created a flow, thus

Manual start

Init Variable (1)

List all rows against the spreadsheet

Filter Array against on field.

For each -

Increment the variable by one.

Email out the variable.

The issue is when I go into excel and view the data there is 3425 rows (Inc Heading) But my count only ever comes out to 3206.

Is there any issues that would cause this, or do I need to modify another setting somewhere?

Thanks

Anonymous · ‎04-28-2020

To Clarify

Excel spreadsheet has 3652 rows. (That match the filter)

The count says only 3276

If I write out to HTML table I get only 3276 rows.

Does anybody no why please?

Helpful resources