cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
thressac
Frequent Visitor

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

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?

1 ACCEPTED SOLUTION

Accepted Solutions
thressac
Frequent Visitor

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

View solution in original post

8 REPLIES 8
timl
Super User III
Super User III

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

 

YourTextbox.Text

thressac
Frequent Visitor

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
Super User III
Super User III

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
Frequent Visitor

@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
Super User III
Super User III

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

thressac
Frequent Visitor

Choice column

timl
Super User III
Super User III

@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
Frequent Visitor

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

View solution in original post

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

PA Community Call

Power Apps Community Call

Next call is happening on April 21st at 8a PST.

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!

secondImage

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors
Users online (45,002)