I've got a form that pulls data and spit it out into a sharepoint list. I changed the column type of a few fields in the Sharepoint list to be text rather than number, so that I could limit the number of characters put into the field.
But now after I've done that, all of the fields linked to the columns that I changed from number to text now contain a 0 when you open the form rather than being empty. I changed the column types back to number, and there is no default value, but it's still happening. How can I revert the fields back to being blank by default?
If I'm desparate I can just throw a blank text input on top of the field to feed it data, but there are a lot of fields that will need changing and I'd rather just fix the issue.
Solved! Go to Solution.
Refreshing the data sources seemed to fix the issue while I was in the Powerapps editor, but it didn't seem to fix the live version.
I instead just removed the "Parent.Default" from each field and that seemed to fix the issue.
Its surprising that in your case this is happening. Beause I tried the exact same thing with SharePoint.
-Created a custom list
-Created a column with datatype number (whole number with no deciaml places)
-Addeded values - numbers are allowed and saved
-Changed the datatype to Single Line Text
-Added Values - now allowing text still using powerapps
-Added Same column again on form with new datatype
-Old data card is still allowing only numbers
-Newly placed card(same field) allowing text and behaving exepcted...
My conclusion: Once you change the datatype, PowerApps is not able to change the card datatype, it is still pointing to the old data type and not updating to new datatype. I beleive thats a bug.
Perhaps you will have to do the same... remove the earlier card and add it again. It will work.
Thanks for reaching out!
I've tried the scenario:
I then tried editing a record and clicking submit, and the value updated in the gallery as expected. (So far so good!) Then, I continued:
At this point, the record I submited seemingly lost the value for TargetField from the Text Input and the Gallery. Not so good.
However, I went View -> Data sources, and refreshed my data sources, and everything started working again as expected. Have you tried refreshing the data source in PowerApps?
I think the scenario I tried is likely different, since I was editing records and not adding new ones. But, perhaps refreshing the data source is still the answer.
Thanks,
Refreshing the data sources seemed to fix the issue while I was in the Powerapps editor, but it didn't seem to fix the live version.
I instead just removed the "Parent.Default" from each field and that seemed to fix the issue.
User | Count |
---|---|
212 | |
94 | |
85 | |
49 | |
38 |
User | Count |
---|---|
271 | |
104 | |
102 | |
60 | |
59 |