web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Cannot be sent to Shar...
Power Apps
Answered

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

(0) ShareShare
ReportReport
Posted on by 31

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?

I have the same question (0)
  • v-jefferni Profile Picture
    Microsoft Employee on at

    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,

  • cater25 Profile Picture
    31 on at

    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.

  • v-jefferni Profile Picture
    Microsoft Employee on at

    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,

  • cater25 Profile Picture
    31 on at

    Hello.

     

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

  • Verified answer
    v-jefferni Profile Picture
    Microsoft Employee on at

    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,

  • cater25 Profile Picture
    31 on at

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 542 Most Valuable Professional

#2
Haque Profile Picture

Haque 206

#3
Kalathiya Profile Picture

Kalathiya 201 Super User 2026 Season 1

Last 30 days Overall leaderboard