I have a 2 SharePoint Lists
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.
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.
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:
20190206Branch (My SP list name)
20190206Request(My SP list name)
Branch Number (look up from 20190206Branch’s Branch Number column)
'Branch Number' = DataCardValue16.Selected.Value, /*DataCardValue16 is under Branch Number_DataCard1*/
'Branch Number' = DataCardValue16.Selected.Value,
Hope this can be helpful.
@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.