Answered

Join two SharePoint lists and return one value

(0) Share

Report

Posted on by guyinkalamazoo

182

I am sure this has been asked and answered before. In my app I am getting a list of items based on a Plant ID number. In this list is another ID that points to an item in another list. It is that item description I am trying to get to. So in SQL I would write something like. Also a quick DD

Select il.description from PlantItems pi

join ItemList il on pi.itemID = il.itemID

where pi.PlantID=1100

Screenshot 2021-10-28 084603.jpg

how would this work for a gallery in my app? Would I use a With statement?

Thanks for the information

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @guyinkalamazoo

In my example, I have used 3 SharePoint List but the concept is the same.

IssueTracker --> EventIItinerary --> Address

Set the Items property of Gallery to SPList1

Each column description
SPList1 Desc
ThisItem.'Issue description'
SPList 1 - Field
SPList1 ID - ThisItem.ID (SPList 1 - Unique ID)
SPList2 ID - ThisItem.SingleEvent.Id (SPList 2 - Unique ID)
SPList1 Lookup to SPList2 - ThisItem.SingleEvent.Value (Lookup Field to SPList 2)
SPList3 Lookup ID
LookUp(EventIItinerary, ID= ThisItem.SingleEvent.Id).Address.Id
Id of SPList 3
lblAddressId
SPList3 Data - LookUp(Addresses, ID= LookUp(EventIItinerary, ID= lblAddressId.Text).Address.Id).Address1

Thanks,
Stalin - Learn To Illuminate

Was this reply helpful? Yes No
guyinkalamazoo 182 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks, this was enough to get what I need. Have a great day!

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @guyinkalamazoo

I realized, already has a table setup so I just put it together.

SQL
Gallery Items property to
StudentTest

"Table 1 Data" - ThisItem.FirstName
"Table 2 ID" - ThisItem.TeacherID
"Table 2 Data" - LookUp(Teacher, TeacherID= ThisItem.TeacherID).TeacherName
"Table 3 ID" - LookUp(Teacher, TeacherID= ThisItem.TeacherID).TeacherInfoID
"Table 3 Data" - LookUp(TeacherInfo, TeacherInfoID= Value(lblTeacherInfoId.Text)).TeacherInfoName

Thanks,
Stalin - Learn To Illuminate

Was this reply helpful? Yes No