Prefill dropdown using lookup

[apkoh18]

Hi All

I am waiting to prefil a drop down list that is connected to SharePoint List (eg PeopleList) using a lookup from another list SourceList.

ID	ValueColumn	PersonColumn
1	Value1	Person1

PeopleList:

Person

Person1

Person2

LookUp('SoureList',ID= Value(ValueCard_DataCardValue.Selected.Id),'PersonColumn')

So when i chose Value1, in ValueCard. Person1 from the same row in SourceList is show in PersonCard.

Is this possible?

[v-bofeng-msft]

Hi @apkoh18 ：

The point is that DefaultSelectedItems should be items in the combo box's data source.Your combo box's source is PersonList , but  DefaultSelectedItems is a text type value which is not a record in PersonList. You'd better try:

With(
 {
  ThePerson:LookUp('IFM Approver 1_1',Approver1.DisplayName=(LookUp('Bank Accounts_1',ID=Value(FromAccountNumber_DataCardValue.Selected.Id),DefaultApprover.DisplayName)),Approver1.Email)
  },
  LookUp(PesrsonList,xxx=ThePerson)
)

Best Regards,

Bof