Update data source using a text field

[Future_Vision]

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?

[AmirBakht]

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

[Future_Vision]

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

[Future_Vision]

"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?

[Future_Vision]

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

[GAbraham]

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

[Future_Vision]

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?

[Future_Vision]

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?