Sharepoint Relationships ID vs Title

(1) Share

Report

Posted on by JonEric

Hey there! I'm wondering what's the best way to create relationships between items. I've seen some training that uses the ID of the list, while others use the title field. Any advice on this would be really helpful. I'm currently building a new employee onboarding app using a SharePoint list as the data source. I initially tried using the ID, but when I created a form in Power Apps, I couldn't figure out how to display the title instead of the ID.

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

michalparal222 86 on at

Like (1)

Report

Hi Jon,

in my experience there are two ways you either use a LookUp column in SharePoint or you use the item ID as a reference to the original item. And I am assuming that you are speaking of two or more lists, not just one.

But when you need to use it in your PowerApp I would choose the ID, because LookUp column are not delegable.

I am not sure what you meant by "I couldn't figure out how to display the title instead of the ID." but when you know the ID if the item, you can always get all the details about it, for example in Form:

LookUp('DataSource',ID = 3) // You should replace the value 3 with some dynamic variable.

Was this reply helpful? Yes No
enriqueglopez 503 Moderator on at

Like (1)

Report

To get the title from that LookUp, you should use:

LookUp('DataSource',ID = 3).Title

This will return the value Title.

If my answer helped you, please mark it as solution.

Was this reply helpful? Yes No
JonEric 16 on at

Like (1)

Report

I have two lists: one for projects called "Projects", where I use the ID as the primary relationship to another table called "project tasks."

In the "project tasks" table, I have a column named "Project Lookup ID" that looks up the Project ID to associate with the project in the Projects list.

When I create a form in Power Apps, the dropdown for the "project tasks" table, under "Project Lookup ID," shows the ID number. However, I want it to display the project's title that the ID is linked to.

Example below: Here are my Items properties. for the dropdown below showing the ID.

Choices([@'Project Task'].ProjectLookup)

Was this reply helpful? Yes No