Combo box people picker strange one

(0) Share

Report

Posted on by vffdd

1,257 Super User 2024 Season 1

I have a combo box whose items are from a people field in sharepoint list.

Distinct(MyList,Namefield.DisplayName)

has been working fine !! but now for some reason some random numbers appear under the names when I go to select. This only happened with I edited other fields in the app. I didn't edit the combo box !

Layout is like this

It's driving me nuts..

And the numbers are random because they change !

any ideas?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

v-peijunz-msft Microsoft Employee on at

Like (0)

Report
Hi @vffdd,

Maybe you could try the following formula in Combo box Items property:
Choices([@YourSharePointListName].'ColumnName')

Based on your description, I have made a simple test for your reference.
1. I have a SharePoint list called Reminder, and it contains a person column called Assigned To.
2. In Power Apps, I insert a Combo box control
For the reason why cannot view the data in the Combo box, please see attached:
https://powerusers.microsoft.com/t5/Building-Power-Apps/People-picker-from-sharepoint-list/td-p/619237

Best regards,
Sylvia

Was this reply helpful? Yes No
vffdd 1,257 Super User 2024 Season 1 on at

Like (0)

Report

Unfortunately that does not work Sylvia for me. I've now just added a new combo box in another screen worked fine for 2 days and then suddenly the numbers appear underneath ! it's bizarre. To get rid of them if I control x the combo box and then control z to put it back they go... am wondering now if I should open a ticket on this one as seems very odd.

Was this reply helpful? Yes No
Verified answer

vffdd 1,257 Super User 2024 Season 1 on at

Like (0)

Report

I've just changed it from a people field to a single field that seems to have done the trick. But I always had it as a people field previously.. hopefully it won't cause any issues

Was this reply helpful? Yes No