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:
- Employee Name [Person or group]
- Employee ID [Number]
- Role Code [Single line of text]
Combo box Items property:
SortByColumns(ShowColumns(Filter('Employee list',IsBlank('Role Code')=false && "HYW" in 'Role Code'),'Employee Name'),"Title",SortOrder.Ascending)
There are 62 Employee names, that the role code contains "HYW",
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!