Hi everyone, after a long conversation with AIs available, I come here begging for help as no solution could be found.
I have a form on PowerApps that has 3 fields. The first field is a combobox and I have populated the dropdown with a list from Sharepoint. I am trying to add the answer of the form to another sharepoint list, but I keep getting an error on that first field. When I removed the formula of the first field the answers populate the list successfully with no errors or warnings.
Here are the formulas I have tried:
1 - Name: Text(If(!IsBlank(ComboBox.Selected), ComboBox.Selected.Name, ""))
I get the error: The function "Text" has some invalid arguments. Expected text or number. We expect text or a number at this point in the formula. This error will occur if you use a function that requires either text or a number but you supply. for example, a boolean value
2- Name: If(!IsBlank(ComboBox.Selected), ComboBox.Selected.Name, "")
Incompatible type. The item you are trying to put into a record has a type that is not compatible with the record
3- I also tried Name: ComboBox.Selected.Value at some point and others that I lost track of the errors. Some of the formulas were accepted but then got a network error ( Network error when using Patch function. The specified column is generated by the server and can't be specified). I have checked the column name is correct *cries uncontrollably*
Here's the code the runs just fine and populates my list:
Patch(
'Hot Stuff Nominations',
{
*formula that keeps failing goes here*
Reason: TextInput.Text,
'Core Value': Concatenate(
If(Checkbox1.Value,"We passionately believe in what we are doing, ", ""),
If(Checkbox2.Value, "We continue to innovate, grow and develop, ", ""),
If(Checkbox3.Value, "We are upfront in what we say and do, ", ""),
If(Checkbox4.Value, "We take pride in delighting the customer, ", ""),
If(Checkbox5.Value, "We value each other’s strengths and effort for the team, ", "")
)
}
)
Ps. the "Name" column on Nominations list is configured to be a single line of text type.
Thank you in advance for any help or enlightenment.
