cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

SharePoint: Foreign Key Relationship

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

4 REPLIES 4
Community Champion
Community Champion

Community Support
Community Support

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

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@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
Not applicable

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.

Helpful resources

Announcements
secondImage

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

Top Kudoed Authors
Users online (21,573)