Answered

Column 'xxx' does not exist. It may have been deleted by another user.

(1) Share

Report

Posted on by Ru0

I am using Get Items to retrieve from sharepoint list. I am trying to filter if the column SyncedID and ID have the same value, and Client name is equal to a string.

It gave the below error, however 'HNB' is not a column, it is the value of the column... Not sure what am I doing wrong here in the filter query, if anyone could help it will be much appreciated!

Below is the raw input:

{
"host": {
"connectionReferenceName": "shared_sharepointonline",
"operationId": "GetItems"
},
"parameters": {
"dataset": "https://visainc.sharepoint.com/sites/VisaAcceptTrackerGroup",
"table": "32b245b8-9ba1-4a90-9c91-f8132e892711",
"$filter": "11 eq SyncedID and HNB eq 'HNB'"
}
}
 
 

Categories:

Building flows

Using flows

I have the same question (1)

All responses (2)

Answers (1)

Sort by

Verified answer

Expiscornovus 33,851 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @RC-21011217-0,

Normally the field names are first (and are just plain text) and the values are second (and often dynamic content). It looks like you swapped the order of the two in your query.

That's why it thinks HNB is a field. Simply type Client as the field name with text instead.

Can you try the below format instead? (below is just an example, replace 11 and HNB by dynamic content fields like in the screenshot)

(SyncedID eq 11) and (Client eq 'HNB')

Happy to help out 😁

I share more #PowerAutomate and #SharePointOnline content on my Blog, LinkedIn, Bluesky profile or Youtube Channel

Was this reply helpful? Yes No
Ru0 9 on at

Like (1)

Report
Copy link

Link copied!

Hi @Expiscornovus,

Thanks so much for your answer! I tried google and youtube tutorials for answers but all of them gave me the kind of syntax like what I have posted earlier.

Was this reply helpful? Yes No