Is there any way to show Cities list values as Choice column choices. For Example: If Client ABC is chosen and Client Contact List has 5 contacts for Client ABC then those should be the only choices available. Empowering technologists to achieve more by humanizing tech. User.

SharePoint Calculated Column Formula, and; SharePoint Column Validation. SharePoint List Display Form. A. Column name: Equipment List The type of information in this column is: Lookup Get information from: Equipment Master List In this column: "Equipment Name" (dropdown selector of all the column names on the other list) Allow multiple values (to be selected) [TICKED] there are some notes lower down too..

I would like to limit the multiple-choice based on the client chosen. Created on February 5, 2018. I have a list of Cities.

Limit Multiple choice of one column based on another column. Find out more about the Microsoft MVP Award Program.

=IF(OR([1]="",[2]="",[3]=""),"Pending",IF(AND([1]="Approved",[2]="Approved",[3]="Approved"),"Approved","Rejected")). LinkedIn | Twitter, https://support.office.com/en-us/article/Create-list-relationships-by-using-unique-and-lookup-columns-80a3e0a6-8016-41fb-ad09-8bf16d490632?ui=en-US&rs=en-US&ad=US, SharePoint Choice column based another list, SharePoint 2013 - Setup, Upgrade, Administration and Operations, https://support.office.com/en-us/article/Create-list-relationships-by-using-unique-and-lookup-columns-80a3e0a6-8016-41fb-ad09-8bf16d490632?ui=en-US&rs=en-US&ad=US&fromAR=1. However I am having trouble actually creating the formula's in PowerApp and then making it actually work on the list. SharePoint List Edit Form.

Hi I need to make Sharepoint Event, and there I have a Choice column: City. Test out your formula in an Excel table first--once you get that debugged (SharePoint is a terrible platform for testing formulas, so I don't recommend starting there), change your field names to match SharePoint's field naming convention and your field should work. Blog | Viewed 13k times 0. In conclusion, we have learned how to How to “Show / Hide fields based on choice field selection using JQuery in SharePoint 2016 / 2013“. Connect and engage across your organization. Tell us about your experience with our site .

You can refer to this site: https://support.office.com/en-us/article/Create-list-relationships-by-using-unique-and-lookup-columns-80a3e0a6-8016-41fb-ad09-8bf16d490632?ui=en-US&rs=en-US&ad=US&fromAR=1, Regards, Sjoukje.

State is populated with a list of states while City is populated with a list of cities.

SharePoint Online; Microsoft 365 and Office; Search Community member; Search Search the Community. I have a SharePoint 2010 List with two columns, State and City. Site Feedback. Apologies if this has been answered somewhere else, I have spent a lot of time searching for an answer with no luck. Microsoft 365 Apps or Office 365 Business. I need to make Sharepoint Event, and there I have a Choice column: City. leave the Default value blank. The City list also has a State column.

Hi Thanks for your feedback, it helps us improve the site. But if you take it to the next level and you want a lookup column to depend on another lookup column and create some sort of a conditional lookup column, …

Great!