Answered

The Value cannot cannot be converted to a number

(0) Share

Report

Posted on by LyonsBI_BRL

214

I'm running into an issue when I am editing a record from the gallery. To give a bit of background, is that the customer record pulls the "Area" from a table within SQL where each Area is represented by a number (i.e. United States = 3, Canada = 1, United Kingdom = 10)

AreaID	Area
1	Canada
3	United States
10	United Kingdom

Under Update under the card, I have CountryAreaField.Text which is where it is throwing the error at

Under Default I have the following code below

LookUp(collectCountryListView,DefaultCountry = DropdownDefaultCountry.SelectedText.Value,Area)/*LookUp('[dbo].[vw_CountryList]',DefaultCountry = DropdownDefaultCountry.SelectedText.Value,Area)*/

I've tried changing it to Value(CountryAreaField.Text) though that doesn't seem to do anything. Any helpful suggestions would be greatly appreciated.

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

BCBuizer 22,854 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @LyonsBI_BRL ,

Look like a mismatch of columns.

Can you try:

LookUp(collectCountryListView,DefaultCountry = DropdownDefaultCountry.Selected.AreaID,Area)

If this doesn't work, can you share what the Items property of the DorpdownDefaultCountry looks like? For this to work, the user needs to select a text, but the dropdown should return the AreaID when referenced.

Was this reply helpful? Yes No
LyonsBI_BRL 214 on at

Like
a
(0)

Report
Copy link

Link copied!

@BCBuizer Just tried that and this time I get a warning on the DataCard. This change was made in the Default part of the card. Also my mistake it's NOT a dropdown it's a card. As it's referencing another card dropdown menu called DropdownDefaultCountry. The Items field calls the collection of collectCountryListView

Was this reply helpful? Yes No
BCBuizer 22,854 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @LyonsBI_BRL ,

I noticed there's a typo in your formula: SelectedText, where it should say Selected .

Can you please share what the Items property of DropdownDefaultCountry looks like and also which columns you have in collectCountryListView to get an idea of how the data is structured?

Was this reply helpful? Yes No
Verified answer

LyonsBI_BRL 214 on at

Like
a
(0)

Report
Copy link

Link copied!
@BCBuizer figured it out. Within the Update field for the Area label, the Update field should have been coded as below
LookUp(collectCountryListView,DefaultCountry = DropdownDefaultCountry.SelectedText.Value,AreaID)
By doing so this recorded the ID of the Area within the table
and the red X has now gone away

Was this reply helpful? Yes No