Answered

List rows filter - "does not exist in array" possible?

(0) Share

Report

Posted on by CCW

Hi,

I've got a table with around 30,000+ rows in. The data is fixed but new rows could be added.
I need to produce an Excel table with the contents of this huge table in it - but the Excel is narrowed down to just 3 columns.

Rather than producing the entire excel report every day, is there anything I can put in the ODATA filter to get any rows which are NOT in an array (array being a list of unique keys from the existing excel table)

I'm using the action SQL Get Rows V2

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Chriddle 8,470 Super User 2025 Season 2 on at

Like (1)

Report
Copy link

Link copied!

A Dataflow is much faster than updating Excel with Cloud Flow actions. So you might be able to create a new Excel file from the whole table each time.

To identify new entries, you can take a look at the "created" (or whatever it is called in your databse) field in your database entries.

Was this reply helpful? Yes No
CCW 32 on at

Like (0)

Report
Copy link

Link copied!

ok, if I did it as a dataflow which I can trigger from the flow, same issue - what should I use to determine what is new or how do I know what's been added since the last flow run? (I don't need updated as once the data's recorded that cannot change) so it's literally just brand new things?

Was this reply helpful? Yes No
Chriddle 8,470 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Maybe you can retrieve only records that are added/updated after the last flow run?
However, you should look at "Dataflows".

Was this reply helpful? Yes No