Announcements
Hello, I have a form where people has the option to either lookup a user using a combobox (retrieves data from SharePoint Person) or type the name in a textbox if the combobox cannot find the user. I have set the property of the form to require all fields in order to submit. However, such would not be the case for the current scenario. I am trying to patch and then submit with a condition where either combobox1 or textbox1 will have a value. However, I am still kind of pretty new and so my formula is not working. What would be the best scenario to submit under such circumstances?
@syasmin25
Your only formula for this should be SubmitForm(yourForm)
What formula are you having problems with?
I do have that set up currently. The issue here is that the form wont submit blank field value. And I am trying to create a condition where either combobox1 or textbox1 will have a value.
When you say it wont submit with a blank field...is this because you have the field as required in the list or that you have made it required in the form?
The question is this though...what kind of column is the underlying field? If it is a person column, then it is going to need to have a valid person record submitted. If it is text, then you will be fine. But with the person, it needs to be valid. So having someone type into the textbox is going to be something that has to be checked before submitting.
Yes, I have set it up as required in the form. The combobox is a person column whereas the textbox is a single text column. I am trying to change the requirements by field instead of form and set up a conditional where either the combobox or the textbox will be blank. - Which is why I was initially asking about patching so that I could break it down individually. Is that not possible?
There is nothing that needs to be patched.
But my question was - what kind of Column is the underlying field in your list. The combobox is not a column nor is the textbox a column...those are controls. I am referring to the field in your datasource that will hold the person data that is selected in the combobox or the textinput control.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Haque 103
WarrenBelz 82 Most Valuable Professional
wolenberg_ 67 Super User 2026 Season 1