question

FilipLisiecki-1163 avatar image
0 Votes"
FilipLisiecki-1163 asked SaurabhSharma-msft commented

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

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.
@concat('$select=Title,ModifiedBy/Title&$expand=ModifiedBy') -> getting only the Title column
@concat('$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
image.png (30.6 KiB)
· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@FilipLisiecki-1163 ,

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

0 Votes 0 ·

@FilipLisiecki-1163 ,

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

0 Votes 0 ·

@FilipLisiecki-1163 ,

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

Thanks
Saurabh

1 Vote 1 ·

0 Answers