cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Bee1
Frequent Visitor

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

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:

Bee1_0-1654986294812.png

Here is my flow:

Bee1_1-1654986409654.png

 

Bee1_0-1654992436227.png

 

Thanks!!!

Bee1

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Bee1
Frequent Visitor

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.  

 

Bee1_0-1655026053750.png

 

View solution in original post

3 REPLIES 3
Bee1
Frequent Visitor

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_0-1655024065380.pngBee1_1-1655024181394.png

 

 

Bee1
Frequent Visitor

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.  

 

Bee1_0-1655026053750.png

 

v-liwei-msft
Microsoft
Microsoft

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:
vliweimsft_0-1655286741848.png

 

 
Best Regards,

Levi

 

Helpful resources

Announcements
 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Users online (2,153)