cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
coresoul
Level: Powered On

Lookup columns from other lists

I have a 2 SharePoint Lists

  1. Request
    • Employee Name
    • Date Reported
    • Branch Number >>lookup column to Branch >>Branch Number
    • Branch Name
    • Branch Manager
  2. Branch
    • Branch ID
    • Branch Name
    • Branch Manager
    • Branch Number

In my canvas app for Request, I would like to pull data from Branch. Meaning, as soon as Branch number is selected, i would like to populate branch name and other data from Branch in the request screen.Powerapps.png

 

 

 

4 REPLIES 4
Super User
Super User

Re: Lookup columns from other lists

You could use the onchange property of the Branch Number control to lookup the Branch Name and set it in a variable. Then in the Branch Name control you would set the default property to the variable. 

Community Support Team
Community Support Team

Re: Lookup columns from other lists

Hi @coresoul,

 

Are Branch Name Column and Branch Manager Column in Request  single line Column?

And you want they are auto dispay by the Look Up Column Brand Number select?

 

I think you can try following workaround:

I test as next:

Data Source:

20190206Branch (My SP list name)

20190206Request(My SP list name)

Branch Number (look up from 20190206Branch’s Branch Number column)

20190206textbasedondropdownsp1.png

20190206tetbasedondropdownsp2.png

App Test:

DataCardValue17.Default: LookUp(

    '20190206Branch',

    'Branch Number' = DataCardValue16.Selected.Value,                     /*DataCardValue16 is under Branch Number_DataCard1*/

    'Branch Name'

)

 

DataCardValue18.Default: LookUp(

    '20190206Branch',

    'Branch Number' = DataCardValue16.Selected.Value,

    'Branch Manager'

    )            

 

20190206textbaseedondropdownapptest1.jpg

 

Result Test:

20190206textbaseondropdownresulttest.gif

20190206textbasedondropdownresulttestsp1.png

 

Hope this can be helpful.

Best Regards.

Yumia

 

 

coresoul
Level: Powered On

Re: Lookup columns from other lists

@v-yuxima-msft, thank you so much and it worked. I need little more. How do i get Branch Manager info. Its a People datatype in SharePoint. I tried this

LookUp(Branch, Branch_x0020_Number=DataCardValue11.Selected.Value, 'Branch Manager'.DisplayName) and its not working.peoplefield.png

 

 

coresoul
Level: Powered On

Re: Lookup columns from other lists

@v-yuxima-msft..please help !