Linking 2 MS Lists with more than 1 filter

Thacker, Josh 1 Reputation point
2022-12-07T19:37:23.587+00:00

i have one list with names in one column and numbers in one column.

Example

Josh 1
josh 2
josh 3
bob 6

second list has a link to show available names in list 1 and second colloum to show numbers in list one

i would like a list that will allow me to pick a name and then only show me numbers associated with that name in list one

test josh dropdown with number's 1,2,3 not 6 because 6 is under bob in list 1

is that possible?

SharePoint Development
SharePoint Development
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Development: The process of researching, productizing, and refining new or existing technologies.
2,662 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Yi Lu_MSFT 17,456 Reputation points
    2022-12-08T09:49:44.283+00:00

    Hi @Thacker, Josh
    You could use the following formula to create two calculated columns to split name and number first: 

    =LEFT(Name,FIND(" ",Name)-1)  
  
=RIGHT(Name,LEN(Name)-FIND(" ",Name))

    As a result, you will get the two columns:

    268448-image.png

    Then in another list, you could use lookup column to look up names in [left name], use power app to list of choice for one column based on another column.

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.