List Rows Present in Table (Excel Online) Fetches incorrect Data if Filter is used

(1) Share

Report

Posted on by pradeep_khanna

Hi,

I am using "List Row Present in Table" in one of my flows, to read an excel table stored on a Sharepoint Site.

If I use unfiltered read (Option A Below), the query works fine. However, if I use a filter condition for fetching Records (Option B Below), the query fetches some random cached data that doesn't even exist in the excel any more. The excel is likely to be updated every week with hundreds of records of which only 25-30% will need to be processed by the flow. Hence I would prefer to use filters at Fetch rather than using conditions downline in the workflow.

PS: Of course, I am using Drop-downs for populating the valid SP Site, List etc. I have just used random data for taking screenshots

Option A: Unfiltered Data read