Thank you for choosing Microsoft Community.
It sounds like you’re facing a common challenge when dealing with multi-value Person or Group columns in SharePoint. Here are a few steps you can take to resolve this issue:
Use the Filter function: Instead of Search, you can use the Filter function combined with ForAll to iterate through the list of technicians. This approach allows you to check each technician’s display name individually.
Concatenate Display Names: Create a calculated column in SharePoint that concatenates the display names of all assigned technicians into a single text field. This way, you can use the Search function on this text field.
Here’s an example of how you can use the Filter function with ForAll:
Filter(
'Work Orders',
ForAll(
Technician,
StartsWith(DisplayName, txtbox_all_tasks_search.Text)
)
)
If you prefer to use a calculated column, you can create a new column in SharePoint that concatenates the display names of all technicians. Then, you can use the Search function on this new column:
Create a Calculated Column:
Go to your SharePoint list.
Create a new column of type “Calculated”.
Use a formula to concatenate the display names of all technicians.
Use the Search Function:
Search('Work Orders', txtbox_all_tasks_search.Text, ConcatenatedTechnicianNames)
These approaches should help you filter work orders by the assigned technicians more effectively. Let me know if you need further assistance!
If this fixes the issue, please mark as resolved to help others with find it.
Happy to help
Robu 1
