Getting an Object must implement IConvertible error

[ali80]

Hi All,

I have an form that, amongst other things, shows a dropdown list of Regions and Countries. Details of this form include:

• The countries displayed depend on the region selected (i.e. if the Americas is chosen, then it will show countries like Brazil, USA etc. and not Japan for example).
• The Regions and countries list are stored in a collection generated in `OnStart`.  
• The data is saved to a SP List that has these fields set up as `Single Line text`.
• The data is saved using the `Update` property of the controls. 

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

[timl]

@ali80 

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

[ali80]

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]

@ali80 

If you set it to this, do you still get the same error?

usr_Region_dd.Selected.Result

[ali80]

@timl  - No not the same error. If I change it to ...Selected.Result I get an `Expected Record value.` error.

[timl]

"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?

[ali80]

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.  

[ali80 · Accepted 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