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

Filip Lisiecki 21

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?

Saurabh Sharma 23,676 Reputation points Microsoft Employee

2021-09-11T01:20:47.073+00:00

@Filip Lisiecki ,

Thanks for using Microsoft Q&A !!
I am seeing the same behavior in my environment and I am checking internally with the products team on the same. I will get back to you as soon as I hear back.

Thanks
Saurabh
Saurabh Sharma 23,676 Reputation points Microsoft Employee

2021-09-16T22:37:48.867+00:00

@Filip Lisiecki ,

I am still waiting for the products team confirmation on the same but I believe that getting modified date for Share Point lists is not explicit and you may have to write extra code to get it. I will update you as soon as I hear back.

Thanks
Saurabh
Saurabh Sharma 23,676 Reputation points Microsoft Employee

2021-10-18T18:54:07.45+00:00

@Filip Lisiecki ,

I have received the confirmation that you need to write additional code to get this information.

Thanks
Saurabh
Paul MacLennan 0 Reputation points

2023-09-04T13:43:26.86+00:00

amazing help, what was the additional code?