Forum Discussion
sm8224
Sep 14, 2021Copper Contributor
Sharepoint List Help
Hello, I am trying to create a sharepoint list, where one of the option is to enter a two digit state. I currently have an =OR statement that works just fine: =OR(State="AR",State="AZ",State="C...
jefmeyer
Sep 14, 2021Iron Contributor
sm8224 - What is your field type? Couldn't you use a Choice field and just have the two code options in the data for the Choice? Are you setting this up in the column validation? If you don't want a choice column, have you considered creating a customized form for the list in Power Apps?
- sm8224Sep 14, 2021Copper ContributorI am using single line of text. i tried the choice type, but i dont like it. its not very clean, and opens up a large window, with the option far to the left of the screen. if it worked like a normal drop down list, that would be great. I have not tried a customized form in power apps. i'm new to using lists in general for now. Beyond that, so there does not seem to be a clean way to validate one of the state abbreviations? thanks