cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
amgravs2
Level: Powered On

Submitting forms: Expected String Error

I have an app where user choices are saved across multiple screens ot one summary table. An issue that I'm runniing into is that I am constantly receiving an error where, once the form is submitted, it calls out a field and says "expected string." I can fix this by changing the excel column data type to "Number" but once I successfully submit, PowerApps changes the column back to "General" and the cycle continues if I close out of the app.

 

Anyone else notice this/have permanent fixes?

1 ACCEPTED SOLUTION

Accepted Solutions
econoshift
Level: Power Up

Re: Submitting forms: Expected String Error

I had exact the same issue and I think I found the solution.

When I change the column format by selecting 'Number' with the drop down in the 'Home' menu in Excel and save the file in OneDrive, the number format will change back to 'General' eventually.

But, if you do that by the Format Cells dialog with specifics detailed, it prevents from changing back to 'General'.  Also, it may be a good idea to do that after saving the file in your hard disk and save back it in OneDrive as @CFursPApps mentioned.

 

 

View solution in original post

9 REPLIES 9
Community Support Team
Community Support Team

Re: Submitting forms: Expected String Error

Hi amgravs2,

 

Could you show me more details to help reproduce this issue on my side?


I assume that your app is based on an Excel table. You have a submit button to submit data to the Excel table.


I am not sure with this “PowerApps changes the column back to "General"”, could you show me a screenshot about it?

 

To test this issue, I create an app based on Excel table which is stored on Dropbox. I can write data back to the data from PowerApps without issues.


About the Excel table, I have a number column, and I configure the number column’s data type to “Number”.


Then auto create an app based on this table, try to save data to the table, succeed. Then I go to the Excel table to check the data type, it is Number, which doesn’t change back to “General” as you mentioned.

3.PNG

 

Please feel free correct me if my reproduce step is different with yours. And it would be great if you could provide more details about this issue.


Best regards,
Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
amgravs2
Level: Powered On

Re: Submitting forms: Expected String Error

Hi v-yamao-msft

 

freshjerky
Level: Power Up

Re: Submitting forms: Expected String Error

Any resolution to this? I have the same issue. Thanks.

grizzlegrazz
Level: Powered On

Re: Submitting forms: Expected String Error

I also have the same proble

freshjerky
Level: Power Up

Re: Submitting forms: Expected String Error

I have been unable to find a resolution. I have an inventory report that is submitted monthly. Without fail, every month, the app fails for the users. I have to go in and change the cell types from General to Number in the excel file and then they can submit. Last month, I got an opposite message where the error said it was expected a number, the field type was a number, and the entered value was a number. That was the straw that drove me to switch back to google forms. Its not as pretty, but it consistently works.

CFursPApps
Level: Power Up

Re: Submitting forms: Expected String Error

Hey guys!  Dunno if any of you have since found a resolution but I think I just did, so maybe this will help future users.  I, too, was just sitting here breaking my teeth, clenching, and then it occurred to me -- If your Excel table is hosted in OneDrive, you may recall that many of the standard features are disabled and don't necessarily write back to the *true NATIVE excel file* itself.  When opening your table in OneDrive, use the "OPEN IN EXCEL" option, change the format to Number and close the native Excel file.  If you check your OneDrive-hosted table, the format will have changed as expected.  I then, on a couple of occasions now, made changes in the app which FINALLY wrote back to the table successfully AND the hosted table format remains intact as "Number."  YAYYYY! 

 

Hope you have the same results!  

Masor
Level: Powered On

Re: Submitting forms: Expected String Error

I had the samen issue.

So I Opened the Excelfile in Excel desktop (not online) and format the cells as a number.

Save the Excel sheet.
This wil probably fix your issue

 

I worked for me 🙂

econoshift
Level: Power Up

Re: Submitting forms: Expected String Error

I had exact the same issue and I think I found the solution.

When I change the column format by selecting 'Number' with the drop down in the 'Home' menu in Excel and save the file in OneDrive, the number format will change back to 'General' eventually.

But, if you do that by the Format Cells dialog with specifics detailed, it prevents from changing back to 'General'.  Also, it may be a good idea to do that after saving the file in your hard disk and save back it in OneDrive as @CFursPApps mentioned.

 

 

View solution in original post

Highlighted
AAlvarez
Level: Powered On

Re: Submitting forms: Expected String Error

 

Hi everyone,

 

I also had this issue and none of the solutions outlined in this thread was able to resolve my problem. While trying to submit a form, I got the "Number expected" error even though the datacard contained a numeric value and the excel source table was properly formated. After each incident, I noticed that the Excel table changed its format to "General" and, as one of the users posted, I went thru that issue a lot but the solution was to simply reformat the column in Excel until days ago that nothing appeared to fix the issue. After a lot of frustrations (mine and my users) I deleted the datacard in my Form and then added it again and voila!! my app is up and runing again! I hope someone finds this information useful.

Cheers!

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (4,938)