Using IDs to get data from multiple SharePoint Lists

(0) Share

Report

Posted on by aah

126

I have the SharePoint lists 'Authorisation_Dates', 'People' & 'Departments'.

I have a form that uses the 'Authorisation_Dates' list as the data source. My problem is that I need one of the text fields on the form to display the department name.

To do this I need a formula that uses the employee ID from the 'Authorisation_Dates' list, matches it with the 'People' list, then uses the department ID from the 'People' list to match up with the department ID from the 'Departments' list and pull up the department name.

Any help on this would be appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

v-jefferni on at

Like (0)

Report
Hi @aah ,

Based on your description, I have made a simple test for your reference.

SharePoint lists:

Formula:

LookUp(Departments, 'Department ID' = LookUp(People,'Employee ID'=DataCardValue_EmployeeID.Text).'Department ID').'Department Name'

Best regards,

Was this reply helpful? Yes No
aah 126 on at

Like (0)

Report

Thanks for the reply.

It doesn't seem to be working for me and I'm not sure why, any ideas?

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report

Hi @aah ,

Is there any error message? Where would you like to display the department item?

Best regards,

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report

Hi @aah ,

Is there any error message? Where would you like to display the department item?

Best regards,

Was this reply helpful? Yes No
aah 126 on at

Like (0)

Report

There is a delegation warning but that's all I get.

So to display the information the user clicks the info button which then takes them to the form. The form uses the same data source and displays all of the users information using a LookUp but I just can't seem to get the Department Name to work.

Was this reply helpful? Yes No
NurSabrina24 165 on at

Like (0)

Report
For the individual details, did the user need to fill-in the details on their own? If yes, you could put the Default for the department name label as:
LookUp(Departments, DepartmentID = <dropdownname>.Selected.Value).DepartmentName

Hope this solves it.

Was this reply helpful? Yes No
aah 126 on at

Like (0)

Report

They didn't, all of their info is already in my SharePoint lists. Thanks for the idea though.

Was this reply helpful? Yes No