ADF copy Sharepoint list, User Principal Name field

Question

We are currently copying a Sharepoint list to ADF. The list has several Person fields (Created by, Modified by etc).

For an embedded Power BI report in our Sharepoint site, using data from that SP list, we need to extract the User Principal Name (UPN) for filtering results. We have already tested that the embedded report successfully extracts the users UPN with DAX code. However, we have to expand our relevant data warehouse fact table with a UPN field.

Do we need to add and maintain a specific UPN column in the Sharepoint list, or is there any way we can extract/ transform the UPN from the Person fields, in ADF?

Answer 1

Hi @Dev 9 ,

Thank you for posting query in Microsoft Q&A Platform.

I hope you are trying to look for ways to fetch UPN of Sharepoint user object using Azure data factory.

If yes, Azure data factory has connector for SharePoint online list. So, if UPN is available as part of list then we can get that info using SharePoint online list connector. Click here to know about that connector.

If you cannot get UPN values in share point list, then you can consider writing code in Azure Function to get UPN data. Once your azure function is ready, you can use Azure Function activity in Azure Data factory pipeline to execute and get details. Click here to know about Azure Function activity.

Below link has details about how to get UPN details using code.
https://social.msdn.microsoft.com/Forums/en-US/22dc504f-8ad0-42df-b6d4-81257d288fe6/how-can-i-get-the-upn-user-principal-name-from-a-spuser-object-in-sharepoint-2010?forum=sharepointdevelopmentprevious

Hope this helps. Please let me know if any further queries.

---------------

• Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification