Hi, I want to use the activity Get List Items to retrieve data from Sharepoint, but I’m having difficulty using the activity because the field Columns to retrieve doesn’t list any options and doesn’t allow me to provide a value, but that field is mandatory to run the activity.
The packages are all updated and in the documentation I don’t find any information regarding this issue.
As you can see I even tried to write one column to test it this way but without success.
The older versions allow writing the value for columns but require the list as variable of type Office365SharepointList. The new versions without that requirement has the same behavior that the newest.
I’m trying to use the activity with the integration service and with this I don´t have the requirement of the 365 Scope.
How can I inicialize one variable of type Office365SharepointList to test the older versions? Can you help me with an example?
With that solution I have to use the Office 365 scope and I get the error:
Get List Info: Code: AccessDenied
Message: Either scp or roles claim need to be present in the token.
The permissions are all granted so I don´t know what I’m missing here.
I only get to write values on that filed as you show in the picture if I downgrade the package to an older version, but that brings me other issues in other activities used on the process, so what ideally I would use the Sharepoint with one of the latest version if not the latest and with the use of integration services and connector instead of using the Office 365 scope.
Can you please check the prrmissions that are given in the azure app…because typically this error occurs only when those have a delegated permission set