Hi Members,
I am facing an issue in the Power Apps Combo box control, some of the items are missing when I connect to the SharePoint list.
Requirement:
I have a SharePoint list [Employee List] over more than 5000 items, with a columns like:
- Employee Name [Person or group]
- Employee ID [Number]
- Role Code [Single line of text]
In the Role Code column, I have a items like [HYW, ORM,POL], [ORM,UYH, HYW], [HM, HYW], [POL,ORM]
Now, in the Power Apps form, I have a combo box control, here I need to display the Employee Names that contains "HYW" in the Role code column.
Combo box Items property:
SortByColumns(ShowColumns(Filter('Employee list',IsBlank('Role Code')=false && "HYW" in 'Role Code'),'Employee Name'),"Title",SortOrder.Ascending)
When I use this code, many items are missing in the combo box.
There are 62 Employee names, that the role code contains "HYW",
But in the combo box there are only 42 employee names, that the last employee names are missing, may be due to the Delegation issue.
Please, help me out how can i achieve it, I need to display all the 62 Employee names that contains "HYW." If the items are adding also, I dont want to face any issues in further, because the list has more than 5000 items.
Thanks in Advance!
