Power Apps

(0) Share

Report

Posted on by PAJ

280

I am facing as issue with this error,

"Syntax error at position 8 in 'End Date eq 16/03/2023'. inner exception: Syntax error at position 8 in 'End Date eq 16/03/2023'. clientRequestId: 3664ff1d-b402-4440-bbbc-9a67d677323e"

The type for the column 'End Date' in Excel Online is 'Date type'

Need help with this. i just want to compare if Today's date is one day before that of the 'End Date'

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

PAJ 280 on at

Like
a
(0)

Report
Copy link

Link copied!

Sorry Screenshot correction
v-liwei-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @PAJ

The Filter query of List rows present in a table does not support column names with spaces.
1. You can modify the column name and change End Date to EndDate.
or
2. Use Filter array.

Best Regards,

Levi
PAJ 280 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes it sure does