Switching between text inputs

[Medziua]

Hello,

I'm currently facing this problem where every time I switch between text inputs after changing them, the app "refreshes" itself and updates data causing the next text input to unselect itself. It's troublesome to select each text input with a mouse again and again. It is essential for me to have this OnChange property on each text input because I need to calculate values in real time for the app to be useful. Is there any way I can avoid this and to comfortably switch between these controls without having to select them again? I need it to kind of work like an Excel where you easily switch between cells using Tab key. 
I used the Patch and LookUp functions in the OnChange property to update my Dataverse table with provided data. 

Any help would be greatly appreciated, thanks!

[WarrenBelz]

Hi @Medziua ,

I am assuming here that you have an editable gallery. This is standard behaviour for a Gallery that it resets all controls to their default whenever anything is triggered from inside it. The only way to keep the values is to Patch the value to a field in the underlying gallery Items data (and linking the control default to that field) , so that when it resets, the value will be retained.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications)   Visit my blog Practical Power Apps

[Medziua]

I'm not sure if I understand correctly, am I supposed to create an independent control above my vertical gallery and use the OnChange property to update data that is displayed on that gallery? This would be problematic because there is more than 100 inputs in my gallery. Even though I only have 3 text input controls created because vertical gallery filled the rest of the list with inputs for each record there is. It looks like this:

I also recorded the issue. At first I'm using the Tab key without changing inputs, which works just fine, but after changing values inside text inputs my focus on the second input disappears and I have to either click on it or start from the beginning using the Tab key and that's what I want to avoid. 

[WarrenBelz]

Hi @Medziua ,

The short answer is if you are instigating any event OnChange of a control in the gallery, it needs to including writing the data from that control to a field in the Gallery Items that the control has as the Default. 

[Medziua]

It works just as you said. OnChange property includes saving users input into a Dataverse table column called 'Obsada 1/2/3' for each text input respectively. Default properties of these inputs are all 'ThisItem.Obsada1/2/3'. All of my data has to be saved in a table because I need it to be displayed with each start of the app. 

Here's how the code on OnChange property looks like.

I want to get as close as possible to the speed of Excel where you can just switch between cells without having to wait for data update and without losing focus on cells that you're trying to edit right after you switch to them.

Not losing focus on the next text input after changing values and updating them is my main goal right now. 

[WarrenBelz · Accepted solution]

@Medziua ,

Then as far as I know, you are doing the best you can and there will always be a pause of some sort waiting for the data to write and the gallery to refresh, depending mainly on the speed of the user's machine and your network latency.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications)   Visit my blog Practical Power Apps

[Medziua]

Okay. Thanks for the help, I appreciate it a lot!