Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities - Lets Get Started!
May 14th | Power Platform Community AMA: Power Apps Edition
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps - Power Query / I keep getting this er...
Power Apps - Power Query
Answered

I keep getting this error: DataFormat.Error: We couldn't convert to Number. I actually want it to show the "number" to become a text

(0) ShareShare
ReportReport
Posted on by MooseGooseLoose 41

I'm having a slight issue with converting numbers into text and back. Half of my Microsoft Forms is both text and numbers

 

Here are some examples

 

Screenshot 2023-07-24 134311.pngScreenshot 2023-07-24 134331.pngScreenshot 2023-07-24 134356.png

  • Verified answer
    MooseGooseLoose Profile Picture
    MooseGooseLoose 41 on at
    Re: I keep getting this error: DataFormat.Error: We couldn't convert to Number. I actually want it to show the "number" to become a text

    Fixed it myself

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

News and Announcements

Welcome to the Power Platform Communities - Lets Get Started!
May 14th | Power Platform Community AMA: Power Apps Edition

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Power Query

#1
ronaldwalcott Profile Picture

ronaldwalcott 2

Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans