Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
maibacherstr
Helper III
Helper III

Relate a Sharepoint User Information List to Another SharePoint List

Hello, my report model has come to a standstill while I'm trying to relate SharePoint's (hidden) user information list (UIL) user data to my Stakeholder Registry which is also a list on the same SharePoint site. To summarize, I'm looking carefully through my expandable Stakeholder Registry fields but have not been able to locate a key, such as an ID column, the would enable this relationship. I'm left to rely on a human in the loop making routine updates, which is what I'm trying to automate.

 

Does anybody have the UIL expertise to help draw this connection?

 

Many thanks

1 ACCEPTED SOLUTION
maibacherstr
Helper III
Helper III

Conclusion:

To relate a user in my Stakeholder Registry (SP List) to the User Information List, I would create a "Title (Linked Account)" field which gives me each person's name (ie, their Title), and a Lookup to the Title field from the UIL, effectively allowing me to manually associate the name from my SH Registry to the UIL. (Unfortunately this is how my team was already doing it; I think it's the best way, but requires a human in the loop).

View solution in original post

5 REPLIES 5
maibacherstr
Helper III
Helper III

Conclusion:

To relate a user in my Stakeholder Registry (SP List) to the User Information List, I would create a "Title (Linked Account)" field which gives me each person's name (ie, their Title), and a Lookup to the Title field from the UIL, effectively allowing me to manually associate the name from my SH Registry to the UIL. (Unfortunately this is how my team was already doing it; I think it's the best way, but requires a human in the loop).

VijayP
Super User
Super User

@maibacherstr Creating Custom Column with ID based on information in your Table helps you to create a proper relationship! Please share your Kudos!
https://www.youtube.com/watch?v=HVxgi1BxxG8&list=PLWQB3PEUJKRneu8fam5CaCMCdrIdT_zDD

You can watch these videos to understand creating relational database and create connections!




Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
MY Blog || My YouTube Channel || Connect with me on Linkedin || My Latest Data Story - Ageing Analysis

Proud to be a Super User!


Hello again, I'm aware about the generalities of creating an Index column for example, how and why, but the problem I'm facing is that I'm fearing there really is no useful connection that exists to the UIL. By creating an index column, I would happily get my 1-N IDs, but the problem still remains that a UIL list appears to reside independently from other lists on the SharePoint site. 

VijayP
Super User
Super User

@maibacherstr 

In Power Query Editor you can create a custom column with ID .

IF you are able share some data after sanitized and after removing classified information can explain better




Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
MY Blog || My YouTube Channel || Connect with me on Linkedin || My Latest Data Story - Ageing Analysis

Proud to be a Super User!


Hello sir, in my case I would have to take half a day to sanitize and recreate a complex dataset, but you definitely have my attention with the creation of a new ID column. Is there any more detail you can take a moment to share, about how that would be accomplished?

 

Many thanks,

Dan

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.