Another filtered lookup question

asapboston 

In SharePoint Online, you can create a filtered lookup by using Power Apps to customize the form for your Candidate list. With Power Apps, you can add logic to your form to filter the choices in the Property dropdown based on the selected value in the Position dropdown.

Here’s a high-level overview of how you can set up a filtered lookup using Power Apps in SharePoint Online:

1. In your Open Positions list, create a new Single line of text column called PositionProperty. Use a workflow or Power Automate flow to populate this column with the concatenated values of the Position and Property columns separated by a hyphen.
2. In your Candidate list, create two new Lookup columns called Position and Property. Set the Get information from field for both columns to your Open Positions list and set the In this column field for the Position column to the Position column in the Open Positions list and for the Property column to the Property column in the Open Positions list.
3. In your Candidate list, click on the Power Apps button in the command bar and select Customize forms. This will open the Power Apps editor where you can customize the form for your Candidate list.
4. In the Power Apps editor, select the Property data card and go to the Advanced tab in the right-hand pane. In the DataField property, change the value from Property to PositionProperty.
5. In the Update property of the Property data card, enter a formula that uses the Split function to split the selected value of the PositionProperty column at the hyphen and return only the second part of the split string (i.e., the Property value).
6. In the Items property of the Property dropdown control within the Property data card, enter a formula that uses the Filter function to filter the choices in the Property dropdown based on the selected value in the Position dropdown.

Once you have set up your form with these customizations, save and publish your changes. Now, when you add a new item to your Candidate list and select a Position from the Position dropdown, the Property dropdown will automatically update to display only properties that need Executive Chefs based on the selected Position.

In SharePoint (not Online), you can create a filtered lookup by using a combination of calculated columns and the Cascading Dropdowns feature in the Lookup column settings.

Es wäre von Vorteil wenn genauere Informationen vorhanden wären.

Hope its helps!