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!!

All responses (3)

Answers (0)

bdransf1 20 on at

Like (0)

Report

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

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!
Venkata Golla 78 on at

Like (0)

Report

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

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

can you please expand the Select Action's input parameter?
v-qiaqi@microsoft.com on at

Like (0)

Report

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

HI @bdransf1,

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