Unanswered

Filter Query no longer producing results for "List rows present in a table"

(0) Share

Report

Posted on by bdransf1

Hi there,

I have a simple flow that sends a reminder email based on a date column (in text form) from an Excel Online table in my OneDrive account. It worked beautifully for 4 months and then just stopped working 3 weeks ago with no changes to the excel sheet or the flow. I've rebuilt the flow and still can't get any results filtering text from any column, not just this date one.

Date Column (which is straight text):

Flow (I have replaced my normal format date expression with straight text for clarity:

Results of the empty array even though there are 3 rows with that date:

Any suggestions greatly appreciated!!

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

v-qiaqi@microsoft.com on at

Like (0)

Report

HI @bdransf1,

Please make sure the column type in your excel table as below:

Was this reply helpful? Yes No
Venkata Golla 78 on at

Like (0)

Report

I tried both Column type as "General" and "Text". It worked fine for me.

can you please expand the Select Action's input parameter?

Was this reply helpful? Yes No
bdransf1 25 on at

Like (0)

Report

Thanks so much. I have tried 3 different columns: a date column, a text column, and a general column. None of them generate any results.

I ended up just making a copy of the sheet and the filter works on the new copy. It must be something corrupt in the original sheet.

Thanks for your input!

Was this reply helpful? Yes No