Hi @Pasaribu,

Thanks for the response.  It's a List Lookup.  Would you have a video to watch or Substring () language that you could show me?

Thanks!

Hi @Underdog 

You can specify a View for the List

In your SPO List, create a new View. create a filter for the View and save the view.

To filter your list, you will need another column e.g. Type. 

Switch to your new View (I'm using a view called "Test") then Edit the View

Set the Filter

Type - is equal to - "AFS". Scroll to top/bottom, click OK.

Test by switching the View. All Items - Test - All Items - Test

Return back to your form, add the View.

FYI, this is one possible method. 

Cheers

Hi @Garrett 

Thank you for the response.  I believe I'm pretty close to setting up your suggestion.  Would you know if one "List" column can reference another "List" column, or do I need to copy & paste into the new column?  For instance, the "List" column "Problem Owners Team" with "AFS", CORP, FRAP, etc. .. has the information I want in it.  I'd like to set up four additional columns ("Type - AFS", "Type - CORP", "Type - FRAP" & "Type - NF") to reference the "Problem Owners Team" column.

Your thoughts?

          Example:

          Column 1                             Column 2

        "Problem Owners Team"     "Type - AFS"

"AFS - Digital Workforce Mgmt"  "BLANK (would like to reference AFS - Digital .. .. .."

Hi @Underdog 

I think that that a single column should do the trick - "TYPE" column (feel free to change the column name). And the value in that column can be "AFS", "CORP", "FRAP" and "NF".

If you wanted to use them in the filter, you would need to create the other views. 

- Create View for "CORP", Filter is <Column "TYPE"> is equal to - "CORP"

You also can go ahead with your 4 columns method as perhaps you have other requirements or usage purposes which you didn't mentioned.

Cheers