Unanswered

Update data source using a text field

(0) Share

Report

Posted on by Future_Vision

634

Here is what I am attempting to do. I have a combo box that lists products that the user chooses. In some cases there will be a new product that is not in the combo box. I want to allow users to enter the new product in a text box and submit the new product which gets added to the data source for the combo box. I imagine there would need to be some way to force a data source and combo box refresh. Is this possible?

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

AmirBakht 262 on at

Like (0)

Report
This idea may work for you or not, depends on your detailed requirements. However, try this,

Instead of putting the data source directly on the combo box, use a timer control to load the data into a collection
Put the source of the combo box as the collection instead
Use a separate screen or set of controls or however you prefer it to push the data from your text box into the data source
Depending on how your dependencies are, do either of the following to load the new value into the combo box
Trigger the timer control to run again and load the data again into the collection. The combo box would then get the new info
If its a simple entry and you can do it without needing much information from the data source, once the source is updated successfully, simply add the entry to the collection so that you do not have to make an extra call

Was this reply helpful? Yes No
Future_Vision 634 on at

Like (0)

Report

Hmmm. I'm just starting out with Power Apps and haven't run across collections yet. I'll have to dig deeper there.

Was this reply helpful? Yes No
Future_Vision 634 on at

Like (0)

Report

"Instead of putting the data source directly on the combo box, use a timer control to load the data into a collection"

How is this done?

Was this reply helpful? Yes No
Future_Vision 634 on at

Like (0)

Report

Anyone have an idea how to do this? I've been searching and have not found a solution.

Was this reply helpful? Yes No
GAbraham 29 on at

Like (0)

Report

Have you tried to refresh your data source in on visible property of your screen like Refresh(table name) ?

Was this reply helpful? Yes No
Future_Vision 634 on at

Like (0)

Report

I'm finally circling back to this. This doesn't seem to be working for me and the directions here are unclear. At least to me. Anyone else have any ideas?

Was this reply helpful? Yes No
Future_Vision 634 on at

Like (0)

Report

For the heck of it I tried something really simple. I did a Patch of the datasource with the value in the text box. Guess what happened? The value was added to the datasource and the combo box was automatically updated. Is it really that easy? Can anyone confirm or is this going to break when I deploy?

Was this reply helpful? Yes No