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!
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