I'm having the problem of searching and filtering the person field.
I have a list of items that are assigned to a person. Now it should be possible to search for these persons.
This does not lead to success:
Search (SortByColumns (SharePointList,"Created", Ascending), SearchBox. text,"Name of the column with the assigned person")
It is a complex field, so I would have to go for a value. DisplayName, email, whatever.
But how do I get this included in the formula?
Search (SortByColumns (SharePointList,"Created", Ascending), SearchBox. text,"Name of the column with the assigned person".DisplayName)
This is not possible.
Additional columns are searched, this always works as long as it is not a complex column.
I've already built larger search queries elsewhere in the app, at first only with "filter". However, the "Search" function is much more effective and faster. That's why I wanted to use this function again. But with the people field.
If only the "filter" function is used, it must be possible to make suggestions after the third letter. Is this possible?
Best regards from Germany
Edit1: What I have to add, this is a gallery in which I want to search/filter.
Edit2: I used the Code function to display the functions.
It seems that Search function won't work with People and Group field. I have got the same result.
This formula won't work while searching in searchbox ("People" is a People and Group column name):
Search(SortByColumns('List Test',"Created", Ascending), TextSearchBox1.Text,"People")
But this formula works while searching:
Search(SortByColumns('List Test',"Created", Ascending), TextSearchBox1.Text,"Title")
Unlike Filter and LookUp, the Search function uses a single string to match instead of a formula.
It seems that Search handles differently from Filter. I will discuss this with others who are more familiar with this and update here is there is any result later.
is there another workaround available?
I have created a shopping and inventory system (backend App for admins). The items are assigned to people, not being able to search for them would be a very bad user impact.
In my SharePoint environment, it is not possible to apply the calculated column to the person column. Unfortunately, @Raf proposal is not a solution either.
A SharePoint workflow that automatically fills a tmp_column with required information is out of the question for my customer.
I would be happy to accept other suggestions or even solutions
I'm Using two O365 groups, to identify two user groups.
The first is just the simple user.
These users only see what has been assigned to them.
The second group are administrators, sales assistants and similar.
In the article overview there is a button, which is only displayed to the users of the second group.
With this button the second group navigates to a search screen.
On this screen, this group of people should be able to search for specific persons.