I am using SharePoint online and am having trouble with the formulas since they are not exactly like Excel or InfoPath.

This custom list I am creating has a lookup column for office locations and I want the field to filter only the offices in the same state as the team member. Can someone help me with this, details below. I hope I explained this right.

Lookup List (Office Locations) - Columns in list 1. LocationID 2. State

List (Custom List) - Columns in list 1. Preferred Location 2. State

1 Answer 1


Dannielle, I believe you will have to do it progamatically. Ideally, you should get the "state" of the user (using some API maybe), and then filter the list based on that state and then display it. There are many ways to do this and perhaps you can do it with javascript.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.