Power Platform Community Forum Thread Details

ListA

- StudentName (data type = text)

ListB

-StudentID (data type = lookup, lookup source from ListA.StudentName)

In Powerapps,

Set(selectedStudent = 'student1')

student1 is one of the value in listA

In EditForm:
comboBoxStudentID - Data Source from listB

how to hit the outcome as per below?

Outcome for comboBoxStudentID:

DefaultSelectedItems = selectedStudent
Items = selectedStudent

Categories:

Building Power Apps

Hi @CU14010518-0,

Based on your values, I believe the Items of comboBoxStudentID should be

Choices(ListB.StudentID)

and if you are going to set the Variable selectedStudent to a name in ListA.StudentName, the DefaultSelectedItems should be

{
   Value: selectedStudent,
   Id:
   LookUp(
      ListA,
      StudentName = selectedStudent
   ).ID
}

I will add a further note that SharePoint Lookup columns are mostly unnecessary with Power Apps and have the potential to cause you unwanted and unneeded complexity and restrictions - I have never used them. It is generally a better idea to get the required field Items directly from the second list with Power Apps and write back to a Text column.

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps LinkedIn Buy me a coffee