Hi All,
I have an form that, amongst other things, shows a dropdown list of Regions and Countries. Details of this form include:
When i try to submit my form I get an IConvertible error. Not sure what that is but I suspect that one of my dropdowns is causing this (the Regions one is my guess). Screenshots below:
The error message:
Code that might help :
How Items property of Region dropdown is displayed:
Update property of Region dd:
Items property of Country dropdown:
Update property of Country dd:
I have no clue how to decipher this error or convert this appropriately. As always, any help is appreciated!.
Solved! Go to Solution.
So I eventually gave in and re-did the entire process of adding a dropdown from scratch - and lo and behold it now works!
I have no clue why however, I did exactly what I did before - but I can't complain, it works is what matters. For those wondering what process I followed I found a video that basically recreates the same steps I use for creating a cascading dropdown (SubmitForm ver.) : https://www.youtube.com/watch?v=Qzpjq008cBY
If I had to take a guess, I'd say that this is the culprit.
I'd try changing that like so to see if it makes a difference:
usr_Region_dd.Selected.Name
Hi @timl
Thanks for replying! I tried changing it to .Name but still getting an error.
The only option I see after adding a dot on the word selected is `Result` which (I assume) has to do with the fact that I alphabetically sorted the region list. The results of the sort is stored in one column called `Results` - Im just not sure how to write back the results into the SP List.
@timl - No not the same error. If I change it to ...Selected.Result I get an `Expected Record value.` error.
"Expected record value" sounds as though Power Apps thinks that the region field is a lookup. Can you confirm that Region is definitely a 'single line of text' field?
Hi timl
In Sharepoint? it's definitely set as a `Single line` field. right now Im trying to find a way to take the Result table's ... result... and shove it into a variable or something that I can then use to save back into the SP list.
So I eventually gave in and re-did the entire process of adding a dropdown from scratch - and lo and behold it now works!
I have no clue why however, I did exactly what I did before - but I can't complain, it works is what matters. For those wondering what process I followed I found a video that basically recreates the same steps I use for creating a cascading dropdown (SubmitForm ver.) : https://www.youtube.com/watch?v=Qzpjq008cBY
User | Count |
---|---|
252 | |
106 | |
94 | |
50 | |
39 |