Share via

Getting the SharePoint List's Modied By and Created By in the Azure Data Factory Lookup query

Filip Lisiecki 31 Reputation points
2021-09-10T10:17:03.123+00:00

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

131105-image.png

Is it possible to use the Query field to get that columns? If no, how it could be done?

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,127 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Paul MacLennan 0 Reputation points
    2024-06-19T12:34:15.5733333+00:00

    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