0

I have a SharePoint list named Technicians which contain a field name "Technician Name" of type people/group, as follow:

johnjohn123_0-1697674210089.png

Now I want to build a combo box field which shows the Technicians' display names to be able to search/filter the Technicians lists. but when I added a combo box field and I defined the Technicians inside the Items property I can not find the TechnicianName field, as follow:

johnjohn123_1-1697674457861.png

Second question, Also I have a form for adding new Tasks >> and inside the form I want to show the list of Technician and pass the value of the selected Technician to a field named Assigned Technician field which is of type people/group also, any advice?

3
  • 1
    Is this a single selection or multiple selection person column? Oct 19, 2023 at 5:46
  • @GaneshSanap-MVP it is a single selection Oct 19, 2023 at 10:02
  • Try solutions given below and let me know if it works for you. Oct 20, 2023 at 10:31

1 Answer 1

1

Try this:

Set items property of combo box control to:

Distinct(Technicians, 'Technician Name'.DisplayName)

OR

AddColumns(Technicians, "TechnicianNamePP", 'Technician Name'.DisplayName)

Then set Primary text and SearchField to local TechnicianNamePP column:

enter image description here

Technicians List Data:

enter image description here

Combo box in Power Apps:

enter image description here


Then you can access the details of selected technician in your app using formulas like (while using 1st case):

LookUp(Technicians, 'Technician Name'.DisplayName=ComboBox1.Selected.Value,'Technician Name'.Email)

OR in 2nd case:

ComboBox1.Selected.'Technician Name'.Email

Where ComboBox1 is the name of your combo box control in Power Apps.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.