Excel online get cell value by date

[nenandi]

HI, how to get cell value in text field in power apps, I connect excel table who have column "Date:" and Headers eg. Fk1, Fk2, etc.

so in power apps when chose date from date picker need to filter date column and get value from Fk2 column. Thank you

[nenandi]

I try with lookup LookUp(Tbl_CDR, Day=DatePicker.SelectedDate,Fk2) and got this error

Issue The requested operation is invalid. Server Response: tbl_CDR failde: Invalid filter clause: unsupported operation. Only single 'eg', 'ne', 'contains', 'startwith' or 'endwith' is currently supported. clientRequestiD: