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.

Categories:

Using flows

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

v-duann-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
skong 142 on at

Like (0)

Report
Copy link

Link copied!

Thanks. I missed a singe quote.

Was this reply helpful? Yes No