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 / powerApps is reformatt...
Power Apps
Unanswered

powerApps is reformatting text fields as number

(0) ShareShare
ReportReport
Posted on by 1

Hi, 

 

I'm really new to this... 

 

I've connecting my powerApps to an Excel sheet where a couple of the fields only have text values in them, but powerApps has defaulted them to number format. 

It means that on my Edit screen, you can only input a number. I changed the format in Properties to Text which lets me enter a value, but then when I go back to the Browse gallery or the details page, it doesn't update the record. And then when I go back on the Edit screen, the text value I've input is gone. 

 

What am I doing wrong?

Categories:
I have the same question (0)
  • v-yuxima-msft Profile Picture
    Microsoft Employee on at

    Hi @Tus87 ,

     

    The Data card field type within Edit form is based on the field types in the Excel table.

    Could you please check whether you have format the text column as text  as the screenshot shows next?

    I set them in the excel table,set the Number column as Number,the Text column as Text, and then test there is no the issue as yours.

    What do you mean “when I go back on the Edit screen, the text value I've input is gone”?

    20190307excel1.jpg

    20190307excel2.jpg

     

    Hope this can be helpful.

     

    Best Regards.

    Yumia

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Thanks for posting in the community @Tus87 - can you review the above reply and update the thread if it was helpful?

     

    Thank you,

     

    @Anonymous 

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!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 528

#2
WarrenBelz Profile Picture

WarrenBelz 426 Most Valuable Professional

#3
Valantis Profile Picture

Valantis 306

Last 30 days Overall leaderboard