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:

Connecting to Data

All responses (7)

Answers (0)

Future_Vision 634 on at

Like (0)

Report

Re: Update data source using a text field

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?
Future_Vision 634 on at

Like (0)

Report

Re: Update data source using a text field

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?
GAbraham 29 on at

Like (0)

Report

Re: Update data source using a text field

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

Like (0)

Report

Re: Update data source using a text field

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

Like (0)

Report

Re: Update data source using a text field

"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 634 on at

Like (0)

Report

Re: Update data source using a text field

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

Like (0)

Report
Re: Update data source using a text field

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