Using SharePoint Activities with Integration Service connection.
I use Get Single List Item without the list picker, so I pass the list ID and site URL as variables. I want to get a specific item by ID. The “Filter By ID” button disappears when I change the list picker to “Enter URL.”
When I try to set the filter as “ID equals variable”, the activity throws an error:
RemoteException wrapping UiPath.MicrosoftOffice365.Office365Exception: The request is malformed or incorrect. —> RemoteException wrapping UiPath.MicrosoftOffice365.Office365InternalException: Code: invalidRequest
Message: A provided field name is not recognized
Image1: 2 activities configured as same; first one doesn’t have any filters, the second one has a filter.
Wanted you to check as I tried same without intergation services and it worked…with adding column name in retreived columns and then fitlering
unfortunately I dont have access to integration services…so wanted you to check the same…
as far as activity is concerned I believe the filtering is happening after retreival…and if we donot include that column in the columns to retreive then it might not filter and that might be causing the error
You cannot filter by ID( the api does not support it and it makes sense, if you have the id you can just use that to fetch the item). However, the By Id button should not disappear, and this is a bug.
The bugfix is due to be released in version 3.1.0 of Microsoft Office 365 activities.
My aim was to fetch the record by ID while giving the list ID and site URL without the list picker. But it was not possible because once I change the list picker to variable input, the ID option was disappearing.
Is there any other option for this, or will it be possible with the new release?
Ideally when integration service is not there and if we use for each list item with fields/ID eq 'value' it did work..is the api different in that case?
