Bad request when using filter in action - list rows present in table.

[Bee1]

I have a excel table with Expiry Date and a variable which I am trying to filter the rows = variable. But I encountered bad request when running the flow. The Expiry Date in excel is in Date format while the variable is in string format.

When I did a Compose statement to check the format of the expiry date field in Excel, it is date field format shown in the 3rd screen capture below. Is the bad request to be due to different value format? If yes, how do I handle it. Please help. 

Appreciate any help given. 

Excel Table:

Here is my flow:

Thanks!!!

Bee1

[Bee1]

I managed to change the reminder date  to Excel date number after going through a few forum post. But I still encounter Bad request with error code shown below. Would appreciate any help to overcome the error.

Syntax error at position 11 in 'Expiry Date eq '44753''.
inner exception: Syntax error at position 11 in 'Expiry Date eq '44753''.
clientRequestId: ef1f915c-a613-45ab-9a58-f28bbca3cb3b

Here are the screen capture of my updated flow and error code.  Would appreciate any help to resolve the error!

[Bee1 · Accepted solution]

I managed to get it working by updating by removing the space between expiry and date in the Excel column and also remove space between expiry and date in the filter criteria in List rows present in table.  

[v-liwei-msft]

Hi @Bee1 ,

The addDays function returns a date with time, and the date in your Excel table only contains date and no time.

You can add a formatDateTime function to the addDays function to convert it to the same format as your Excel:

Best Regards,

Levi