In my org
There are 15 fields of type "Hierarchy" on the User object. Out of these, one is the standard Manager field, and the rest 14 custom.
I have an approval process where I need to select one of these hierarchy fields from the "Automatically assign to Approver(s)" field using the "Related User" selection (screenshot). However, my required field is not available for selection, and only 10 fields appear in the dropdown, in alphabetical order, which are a mix of 3 standard fields and 7 custom hierarchy fields on User.
Where are the other 7 custom hierarchy fields on User and why are they not selectable? I have checked and they all have the same FLS. Only difference is that they were created much later than the other custom hierarchy fields.
Is the having 10 entries in the dropdown a Salesforce limit, and am I not getting the next fields because this is excluding the limit? Is this a bug? Anyone else has encountered this behavior, and perhaps knows of a logical explanation?
From this help link I see only the following information, but nothing to solve my problem.
Who can approve requests? Any of the following can approve or reject a request. A user or queue that the approval request submitter chooses. A queue specified by the administrator. A user listed in the Manager standard field on the submitter’s user detail page. A user listed in a custom hierarchy field on the submitter’s user detail page. Any combination of users and related users (users listed in a standard or custom field on the submitted record) specified by the administrator.