Lookup field in PowerApps to another SharePoint lookup field

%3CLINGO-SUB%20id%3D%22lingo-sub-3083414%22%20slang%3D%22en-US%22%3ELookup%20filed%20from%20PowerApps%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3083414%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%202%20SharePoint%20lists%3A%3C%2FP%3E%3COL%3E%3CLI%3E15%20meters%20test%20-%20a%20list%20where%20I%20store%20test%20results%3C%2FLI%3E%3CLI%3ESwimmers%20-%20a%20list%20where%20I%20store%20swimmers%20names%2C%20age%2C%20and%20other%20basic%20info%3C%2FLI%3E%3C%2FOL%3E%3CP%3EFrom%20list%20no%201%3A%20%3CSTRONG%3E15%20meters%20test%3C%2FSTRONG%3E%26nbsp%3BI%20use%20a%20dropdown%20called%20SWIMMERS%20to%20chose%20swimmers%20from%20list%20no.%202%20%3CSTRONG%3ESwimmers%3C%2FSTRONG%3E.%20This%20will%20save%20me%20the%20time%20and%20avoid%20spelling%20errors%20for%20each%20recorded%20test%20result.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20made%20a%20PowerApp%20based%20on%20Sharepoint.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20problem%20is%20that%20PowerApps%20-%20for%20some%20reason%20-%20won't%20suggest%20or%20display%20values%20if%20I%20reference%20the%20column%20called%20SWIMMERS%20from%20list%20no.%201.%26nbsp%3B%20So%3A%26nbsp%3B%3CSTRONG%3EThisItem.Swimmers%3C%2FSTRONG%3E%20shows%20nothing.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20beginning%20to%20realize%20that%20this%20might%20be%20a%20limitation%20within%20PowerApps%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20can%20I%20show%20my%20swimmers%20name%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3083414%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EPowerApps%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3085044%22%20slang%3D%22en-US%22%3ERe%3A%20Lookup%20field%20in%20PowerApps%20to%20another%20SharePoint%20lookup%20field%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3085044%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F425473%22%20target%3D%22_blank%22%3E%40jensjakobsen1966%3C%2FA%3E%26nbsp%3BI%20assume%20you%20are%20using%20a%20customised%20Power%20Apps%20form%20and%20have%20added%20the%20Swimmers%20list%20as%20an%20additional%20data%20source%20source.%20Add%20a%20dropdown.%20In%20the%20dropdown%20the%20items%20property%20should%20be%26nbsp%3B%3CSTRONG%3EChoices(%5B%40Swimmers%5D.Title)%3C%2FSTRONG%3E%20or%20whatever%20column%20has%20the%20swimmer's%20name%20in%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThen%20-%20and%20very%20importantly%20-%20go%20to%20the%20data%20sources%20icon%20on%20the%20left%20of%20Power%20Apps%20and%20refresh%20the%20Swimmers%20list%20datasource.%20The%20dropdown%20won't%20display%20anything%20until%20you%20have%20done%20the%20refresh.%20As%20soon%20as%20you%20do%20the%20dropdown%20will%20show%20the%20swimmers%20names.%20(Ignore%20my%20list%20and%20column%20names%2C%20they%20were%20just%20the%20lists%20and%20columns%20I%20had%20to%20hand!)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22lookup2.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F343533i54E11B0558B37B26%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22lookup2.png%22%20alt%3D%22lookup2.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20the%20customised%20form%20the%20column%20in%20your%2015%20metres%20test%20list%20which%20will%20hold%20the%20swimmer's%20name%20should%20reference%20the%20dropdown%20value%20that%20was%20selected%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22lookup2a.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F343534i728F50133F47DA1B%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22lookup2a.png%22%20alt%3D%22lookup2a.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20that%20helps.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EIntranet%2C%20SharePoint%20and%20Power%20Platform%20Manager%20(and%20classic%201967%20Morris%20Traveller%20driver)%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3085091%22%20slang%3D%22en-US%22%3ERe%3A%20Lookup%20field%20in%20PowerApps%20to%20another%20SharePoint%20lookup%20field%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3085091%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F174092%22%20target%3D%22_blank%22%3E%40RobElliott%3C%2FA%3E%2C%26nbsp%3Bthank%20you%20for%20taking%20time%20to%20help!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20error%20I%20tried%20to%20describe%2C%20is%20on%20the%20%22BrowseScreen1%22%2C%20the%20very%20first%20pageview%20of%20the%20data.%20I%20have%20added%20a%20screenshot%20to%20explain%20the%20best%20I%20can.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20syntax%20I%20use%20(to%20try%20and)%20reference%20the%20swimmers%20name%20is%3A%3C%2FP%3E%3CP%3ELookUp(Sv%C3%B8mmere%2CID%3DThisItem.ID%2CNavn)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Lookup_error.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F343535iDF56FC6DAB193EE1%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Lookup_error.png%22%20alt%3D%22Lookup_error.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20did%20add%20another%20datasource%20(before%20I%20posted%20the%20first%20post)%20-%20this%20means%20that%20I%20have%20a%20datasource%20for%20both%20of%20the%20lists.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

Hi 

I have 2 SharePoint lists:

  1. 15 meters test - a list where I store test results
  2. Swimmers - a list where I store swimmers names, age, and other basic info

From list no 1: 15 meters test I use a dropdown called SWIMMERS to chose swimmers from list no. 2 Swimmers. This will save me the time and avoid spelling errors for each recorded test result.

 

I've made a PowerApp based on Sharepoint.

 

My problem is that PowerApps - for some reason - won't suggest or display values if I reference the column called SWIMMERS from list no. 1.  So: ThisItem.Swimmers shows nothing.

 

I'm beginning to realize that this might be a limitation within PowerApps?

 

How can I show my swimmers name?

 

Thanks.

5 Replies

@jensjakobsen1966 I assume you are using a customised Power Apps form and have added the Swimmers list as an additional data source source. Add a dropdown. In the dropdown the items property should be Choices([@Swimmers].Title) or whatever column has the swimmer's name in it.

 

Then - and very importantly - go to the data sources icon on the left of Power Apps and refresh the Swimmers list datasource. The dropdown won't display anything until you have done the refresh. As soon as you do the dropdown will show the swimmers names. (Ignore my list and column names, they were just the lists and columns I had to hand!)

 

lookup2.png

 

In the customised form the column in your 15 metres test list which will hold the swimmer's name should reference the dropdown value that was selected:

 

lookup2a.png

 

Hope that helps.

 

Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

@RobElliott, thank you for taking time to help!

 

The error I tried to describe, is on the "BrowseScreen1", the very first pageview of the data. I have added a screenshot to explain the best I can.

 

The syntax I use (to try and) reference the swimmers name is:

LookUp(Svømmere,ID=ThisItem.ID,Navn)

 

Lookup_error.png

 

I did add another datasource (before I posted the first post) - this means that I have a datasource for both of the lists.

 

@jensjakobsen1966 in your first post you mentioned a dropdown, but there's no dropdown on your screenshot, so I'm not sure where the error is.

 

Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

@RobElliott - I've added a screenshot of the source.

 

The SharePoint list is actually not called SWIMMERS but SVØMMERE. but for the benefit of English language, I've referenced it as SWIMMERS. 

 

Below is a screenshot of the datasource.

sources.png

@RobElliott sorry about the confusion.

 

The dropdown I mentioned where within the lists. So within list 1, I used values from list 2 as source for a dropdown.

 

Sorry.