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

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps - Microsoft Dataverse / Leading Zeros in Prima...
Power Apps - Microsoft Dataverse
Answered

Leading Zeros in Primary Field

Like (0) ShareShare
ReportReport
Posted on 5 Jan 2021 16:36:45 by rbergan 199

I created a Dataverse Table for ZIP Codes. This table includes information such as Sales Tax Rate, City and State. The primary column for this table holds the ZIP Code and it is a Text column. Some ZIP Codes start with a "0".

 

I am adding the data to the Dataverse table via Excel. When I publish from Excel to the Dataverse table, the leading zero is removed.

 

Is there a way I can keep the leading zero, where applicable?

Categories:
Microsoft Dataverse
Tables
I have the same question (0)
  • Kanchan KB Profile Picture
    Kanchan KB 9 on 05 Jan 2021 at 17:52:26
    Re: Leading Zeros in Primary Field

    Hi @powerwood ,

     

    From the Data verse table  you can download the edit data in excel, that will download the template and you can add/edit data and then publish it.

    Kanchankb_0-1609869085722.png

     

     

    If this answers your question please "Accept as Solution" and hit like.

  • Verified answer
    SeanHenderson Profile Picture
    SeanHenderson 1,104 on 05 Jan 2021 at 16:52:53
    Re: Leading Zeros in Primary Field

    Hi @powerwood 

    From a view inside your app, you can use Excel Online to add the data and it will let you import the leading zeroes.

    SeanHenderson_0-1609865527171.png

     

    ---
    Please hit the "Accept as Solution" button if my post answered your question! If my post was helpful please consider giving it a "Thumbs Up."

     

  • rbergan Profile Picture
    rbergan 199 on 05 Jan 2021 at 16:43:23
    Re: Leading Zeros in Primary Field

    I found a workaround, though it is time consuming.

     

    In Dataverse table, select Data tab, then select the record to be changed and select the "Edit Record" option at the top of the page. Once in the edit screen, add the "0" to the beginning of the ZIP code, then "Save and Close". 

     

    This changes the ZIP Code in the data. 

     

    Is there a faster way? Luckily, I only need to change about 50, so it's probably faster to change them manually than to write something outside of Dataverse. But I'm curious if there is a faster way to do this in Dataverse. Or if there is a faster way that would make sense if there were more records to change.

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
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Tom Macfarlan – Community Spotlight

We are honored to recognize Tom Macfarlan as our Community Spotlight for October…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 885 Most Valuable Professional

#2
developerAJ Profile Picture

developerAJ 571

#3
Michael E. Gernaey Profile Picture

Michael E. Gernaey 352 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans