I set up a gallery, added some text inputs, and the data link is to a Azure sql database.
Overall everything works as planned: I am able to add/edit/delete the rows in the gallery.
The issue I'm having is frequently when I enter a text input and start typing, the characters are not being accepted. Sometimes it is necessary to click on the text input box several times to get the characters to be accepted and show in the text input.
I have set up the onChange event of the text input to store the updated value in the Azure sql database.
Solved! Go to Solution.
Hi @eColumbia99 ,
Could you please share a bit more about your scenario?
Do you mean that the Text Input box could not accept the character you entered from your keyboard in your Gallery?
Based on the needs that you mentioned, I have made a test on my side, and do not have the issue that you mentioned. Please make sure the Format property of the Text Input box is set to following:
TextFormat.Text
In addition, please consider remove the formula from the OnChange property of the TextInput box, instead, please add a "Save" icon inside your Gallery, set the OnSelect property to following:
Patch(
'[dbo].[SQLTable]',
Defaults('[dbo].[SQLTable]'),
{
Column1: TextInput1.Text,
Column2: TextInput2.Text,
Column3: TextInput3.Text,
...
...
}
)
If the issue still exists, please consider re-create a new Gallery within your app, then try above solution again, check if the issue is solved.
Best regards,
Hi @eColumbia99 ,
Could you please share a bit more about your scenario?
Do you mean that the Text Input box could not accept the character you entered from your keyboard in your Gallery?
Based on the needs that you mentioned, I have made a test on my side, and do not have the issue that you mentioned. Please make sure the Format property of the Text Input box is set to following:
TextFormat.Text
In addition, please consider remove the formula from the OnChange property of the TextInput box, instead, please add a "Save" icon inside your Gallery, set the OnSelect property to following:
Patch(
'[dbo].[SQLTable]',
Defaults('[dbo].[SQLTable]'),
{
Column1: TextInput1.Text,
Column2: TextInput2.Text,
Column3: TextInput3.Text,
...
...
}
)
If the issue still exists, please consider re-create a new Gallery within your app, then try above solution again, check if the issue is solved.
Best regards,
User | Count |
---|---|
224 | |
100 | |
95 | |
57 | |
31 |
User | Count |
---|---|
283 | |
114 | |
108 | |
63 | |
60 |