So I have 2 SharePoint lists in the same site. They have records with IDs which coincide to record names. Both lists have a common column, the record ID, which is connected but I'm not sure how.
Only one of them have the record names column, how can I connect it?
I'm using the list which doesn't have the name but I want it to appear even at least as a text on Power apps by relating it to its ID.
Either by sharepoint or on power apps (like if ID from one list is equal to the ID in the other, then the text should display the project name from the other list).
How can I do this?