User needs to display all the items that will end with the character “PRO.”

Scenario: To filter a list of items that ends with a particular list of characters, a user may create a custom Item Saved Search and set a formula expression:

Solution

1. Go to Lists > Search > Saved Searches > New > Item.
2. Under Criteria subtab add the below Filter:
   a. Field = Formula (Numeric) | Formula = case when {‌name} like ‘%PRO’ then 1 end | Formula (Numeric) Field = equal to
   Value = 1
   b. Set
   c. Done.
3. On Results subtab, Add fields according to you needs.
4. Rename the search.
5. Save & Run.
   
   Please Note: This search could be used as a report also used to restrict for a specific role/user using workflow. Also the character could be changed according to the requirements.