Hi everyone,
I’m not sure what changed, but the “Get items” procedure had been working as expected since it was created and has suddenly stopped returning any data this week.
Cancelled column is a Choice column in our SharePoint list with 'Yes', and 'No' values.
This is what the data looks like when I tested without any conditions.
"Cancelled": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": 0,
"Value": "Yes"
},
"Cancelled#Id": 0
Tried different conditions but nothing is working:
'Cancelled/Value' eq 'Yes'
Cancelled/Value eq 'Yes'
Cancelled_x0020_Value eq 'Yes'
Cancelled_Value eq 'Yes'
Cancelled#Id eq 0
'Cancelled#Id' eq 0
Cancelled/Id eq 0
'Cancelled/Id' eq 0
Cancelled eq 0
Any suggestions please?