web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / List Rows Present in T...
Power Automate
Unanswered

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

(1) ShareShare
ReportReport
Posted on by 31

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

pradeep_khanna_1-1685425235670.png

 

 

Option B: Filtered Data read (My preferred solution, but giving trouble)

pradeep_khanna_0-1685425204473.png

 

Categories:
I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 497 Moderator

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 477 Super User 2025 Season 2

#3
chiaraalina Profile Picture

chiaraalina 242

Last 30 days Overall leaderboard