Answered

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

(0) Share

Report

Posted on by skong

142

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.

All responses (2)

Answers (1)

skong 142 on at

Like (0)

Report

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

Thanks. I missed a singe quote.
Verified answer

v-duann-msft on at

Like (0)

Report

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

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