Forum Discussion
Solved
Filter a list on multiline text column
In a modern list in SharePoint Online I have a list with two columns:
Name - Single line of text
Description - Multiple lines of text
If I filter by Name I can easily see all rows for a particular name. What I also want to do is filter to all rows where the Description field contains "calibrations" or "blue houses" or whatever I am looking for.
Description is a free form field and I don't know what people will put there. I also don't know what I will be looking for so I need to do a text search.
What is the easiest way to do this?
- Use the list search bar instead of filter. If that doesn’t work you might not have many other options since search via powerapps would only provide startswith.
However If the list will never go beyond 2000 records you can utilize powerapps with search functions against the field.
2 Replies
- Use the list search bar instead of filter. If that doesn’t work you might not have many other options since search via powerapps would only provide startswith.
However If the list will never go beyond 2000 records you can utilize powerapps with search functions against the field.The search bar should be exactly what I need. I didn't realize that the scope was just the list. I thought it would search the entire site, or even all SharePoint sites.
Thanks
