Good morning UiPath Forum, I am having a problem with an OData filter. I am simply trying to query the ID on a SharePoint list and return the one list item with that ID number. I have tried all of the following but continue to get the error shown in the image. I’d greatly appreciate your assista…

Hi @jamiejam i think the id should be numeric value so if this assumption is correct you need to avoid adding single or double quotes around numeric values for ID Update your filter expression in the For Each List Item activity to: ID eq 21 If fields/ is required (depending on your SharePoint li…

Formatting error on OData query

Help Studio

jamiejam (Jamie Garvey) January 11, 2025, 7:58pm 3

Thanks VERY much @mahmoud.zaky . “fields/ID eq 21” worked.

1 Like

Topic		Replies	Views
For Each List Item error on OData filter - "Expression Activity type 'VisualBasicValue`1' requires compilation in order to run. Please ensure that the workflow has been compiled." Activities activities , question , microsoft_office365 , sharepoint , sharepoint-list	3	64	January 2, 2025
Sharepoint ODATA Filter by Look Up ID Activities activities , question , microsoft_office365	2	3001	September 28, 2022
For Each List Item supported OData filters Activities microsoft_office365 , sharepoint	1	720	November 28, 2023
OData Filter For "Contains" On Get List Items Activity (Sharepoint) Activities activities , question , microsoft_office365	13	11474	October 5, 2023
ODATA filter with Variable as value Studio studio , question , properties_panel	4	101	November 22, 2024

Formatting error on OData query

Related topics