Cannot be sent to SharePoint list because it cannot be converted to a number.

(0) Share

Report

Posted on by cater25

Hello.

I would like to have a SharePoint list reflect a number entered in a text box or selected item in a dropdown.

The data card on the form has radio buttons that can only display text boxes or dropdowns.
Within the card there is both a textbox and a dropdown with a label in it, and the text property contains the following code

If(IsBlank(Textbox1), Dropdown1.Selected.Value, Textbox1.Text)

Then, if I enter "label1" in the update property of the data card, it will show that the dropdown item "Error" cannot be converted to a numeric value.

The data type I want my SharePoint list to reflect is "one line of text", how can I improve this?

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (6)

Answers (1)

v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @cater25 ,

Please try below formula in Text property first:

Coalesce(Textbox1.Text, Dropdown1.Selected.Value)

and then in Update property:

Label1.Text

Best regards,

Was this reply helpful? Yes No
cater25 31 on at

Like (0)

Report
Copy link

Link copied!

Thank you for your prompt reply.
I have tried and I get the following error statement as well with the update property.
This value "error" cannot be converted to a number.

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @cater25 ,

What's in Items of the Dropdown? You can also post a screenshot of the error, so I would know what causes it.

Best regards,

Was this reply helpful? Yes No
cater25 31 on at

Like (0)

Report
Copy link

Link copied!

Hello.

In the drop-down Items.
["Less than 40°C" , "Error"].

Was this reply helpful? Yes No
Verified answer

v-jefferni Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @cater25 ,

Was it originally a Number column? If you have modified the list columns after the Edit form deployed in your App, you will need to refresh the connection of this list and then add the form to your App again.

Best regards,

Was this reply helpful? Yes No
cater25 31 on at

Like (0)

Report
Copy link

Link copied!

Hello @v-jefferni .
I have changed the data type of a SharePoint list from originally being a numeric column to a numeric column during development.

Was this reply helpful? Yes No