SharePoint: Foreign Key Relationship

[Anonymous]

Is there a procedure to setup a sharepoint list to references a value from another list inside sharepoint?

[ericonline]

Hi @Anonymous. Please see this great thread here on the topic: https://powerusers.microsoft.com/t5/General-Discussion/Data-Management-Best-Practices/m-p/133247#M46272 

[v-xida-msft]

Hi @Anonymous,

Could you please share a bit more about your scenario?

Do you have problems with PowerApps?

If you want to create a SP list to reference a value from another list inside SharePoint, please check and see if the following article would help in your scenario:

https://support.office.com/en-us/article/create-list-relationships-by-using-unique-and-lookup-columns-80a3e0a6-8016-41fb-ad09-8bf16d490632

If you want to use the SP list which references a value from another SP list within a PowerApps app, please check the following article:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/sharepoint-lookup-fields

You could also take a try to check the thread the user @ericonline mentioned, then check if it help in your scenario.

Best regards,

Kris

[seadude]

@v-xida-msft, @Anonymous, is there still a maximum # of Lookup columns that one can have in a Sharepoint list that PowerApps ties to? If so, this is something to keep an eye on as you build your data relationships.

[Anonymous]

The scenario is:

I have 3 List

1. User List
2. Equipment List
3. Assignement List

The users can be assigned to equipment.  Only active users can be assigned to available equipment.  The assignment list must be able to pull all active users from the user list and pull all avaialbe equipment from the equipment list.