I have a text field ID of type text. Data source for this field is SQL table with coulmn ID, type varchar(50).
Problem is that this field is not accepting text or characters like -. Even though it is of type text. Only numbers can be inputed.
Other column with type text works fine with mixed text/number/chars. Only this ID column is problem.
If I create a new record for ID in SQL table with mixed text/numbers, it is acceepted without problems.
More in screenshots:
ERROR ON INPUT
SQL COLUMN
PROPERTIES OF TEXT INPUT
Solved! Go to Solution.
Hi @Anonymous
I would try recreating this data card in order to reset it. That might clear the problem.
If you select the properties of the form and click fields > edit fields, you can delete the card and click 'add field' to add it again.
Hi @Anonymous
I would try recreating this data card in order to reset it. That might clear the problem.
If you select the properties of the form and click fields > edit fields, you can delete the card and click 'add field' to add it again.
This did the trick.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
User | Count |
---|---|
200 | |
47 | |
45 | |
45 | |
39 |
User | Count |
---|---|
279 | |
81 | |
81 | |
80 | |
67 |