Hey Suraj,
The solution is that you need to import another list called UserList. it's a unique list per each sharepoint.
You can then join and get some needed info out
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
I am trying to receive from the SharePoint List's columns with names of the 'Created By' and 'Modified By' users. As a default, Lookup activity (and Copy data which I am using) in the ADF doesn't return these fields, only CreatedById and ModifiedById. How can I get these columns?
I was testing different combinations of the 'Query' field in the Lookup, however no luck. I am getting errors or no data...
i.e.
@markus.bohland@hotmail.de ('$select=Title,ModifiedBy/Title&$expand=ModifiedBy') -> getting only the Title column
@markus.bohland@hotmail.de ('$expand=ModifiedBy') -> getting only 'regular' columns, no ModifiedBy
Is it possible to use the Query field to get that columns? If no, how it could be done?
Hey Suraj,
The solution is that you need to import another list called UserList. it's a unique list per each sharepoint.
You can then join and get some needed info out