cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
apkoh18
Frequent Visitor

Prefill dropdown using lookup

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.

IDValueColumnPersonColumn
1Value1Person1

 

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?

 

 

10 REPLIES 10

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

Helpful resources

Announcements
Super User 2 - 2022 Congratulations 768x460.png

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

<
Users online (3,622)