Textbox replaced a dropdown and need update the list with the text in the textbox

[thressac]

Hello!

I have a dropdown field that I want to delete and put in a textbox that will auto populate the user.  I'm able to auto populate the user.  My problem is, when I delete the dropdown field I get an error on the datacard update.  What do I need to input here to ensure that the list item will get updated with what is in the textbox?

[timl]

You would need to replace this with a reference to your new textbox control. This would be something like the following:

YourTextbox.Text

[thressac]

Thank you for the quick response @timl !

That's what I thought and tried that but get "Expected Record Value" error.  I can provide screenshots if needed.

Thank you!

[timl]

You're welcome @thressac!

What data source are you using and what's the data type of the field that you're trying to update?

[thressac]

@timl , the dropdown field is coming from a sharepoint list and the data type is Complex.  I hope I answered what you are needing. 

[timl]

@thressac - what exactly is the complex field that you're working with - a choice column, lookup column, person/group, or something else?

[thressac]

Choice column

[timl]

@thressac  - if you set the update property of your card to a formula in the following format, that should hopefully solve the problem.

LookUp(Choices([@YourSharePointList].YourSPChoiceColumn), 
       Value=txtYourTextBox.Text
)

[thressac · Accepted solution]

I was over thinking it.  I just made the choice field a single line of text in SharePoint.