Hi Guys, I had a fully functioning app a minute ago but suddenly everything brokedown. I got an invalid argument error randomly and upon further investigation, reference to a column appeared broken, I tried to fix it but but when I try writing column name
"ISSUE_x0020_ID' (which was working just fine 2 minutes ago) does not load while other columns from the same data source and table load just fine, this has completely broken my application and I cant figure out why ?
I have already tried refreshing and reconnecting my data set multiple times but no look thus far.
Solved! Go to Solution.
Says I have an invalid Argument, data source is excel connected by OneDrive. it doesnt let me reference "issue_x0020_ID" at all when I try to go and fix it while other column names show up in the dropdown just fine.
Thanks a lot for clarifying I wasnt sure what was happening. Would you be so Kind to share some guidelines, the issue_Id field was converted back to text and the error is gone. As a best practice for an autoincrement type field how should we format the column?
Of course, anything to help! I don't see anything inherently wrong with it being a string vs. a number; if you're worried about it, you could do your data validation in the app itself on that field. You could do something to validate the information in that DataCard with IsNumeric():
Check out new user group experience and if you are a leader please create your group
Check out how to claim yours today!
Test your skills now with the Cloud Skill Challenge.
We are excited to announce that Demo Extravaganza for 2021 has started!
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks