Get items filter query - match a field in SharePoint list with a field in excel online issues

[skong]

I am trying to match a field in SharePoint list with a field in excel online using filter query. Attached in the filter query, Both fields are text field and the error message was                                               the expression "employee_id eq 004545691" is not valid. Creating query failed.
clientRequestId: b3e86afb-a379-47a8-ad61-3e96bf84483a
serviceRequestId: b3e86afb-a379-47a8-ad61-3e96bf84483a. Please help.

[v-duann-msft · Accepted solution]

Hi @skong 

Thank you for posting.

First of all, please add single quotes around employee_id in filter query.

After that, please follow below steps to check the actual name of ‘employee_id’ in sharepoint.

Then can find the detectable name ‘CaseID’ in flow is ‘UniqueID0’

Hope the content above may help you.

Best regards,

Anna

[skong]

Thanks. I missed a singe quote.