Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Power Platform Community / Forums / Microsoft Dataverse / View Column Formulas P...
Microsoft Dataverse
Unanswered

View Column Formulas Previously Created

(0) ShareShare
ReportReport
Posted on by AHILLCC 37
I am VERY new to Dataverse (like 1 day into it new). I have an app that references tables.  It was created back in 2021.  I didn't create it, but I am trying to work with it.  It has a couple of columns that are obviously using formulas to create numbers; however, I can't figure out where I can see the formulas.  It doesn't work like Sharepoint Lists, where I could look at List settings, or Excel, where I could view the formula in a formula bar.  The images below explain what I see.
 
The Customer Number Column results in an automatically incrementing number that raises by one each time a new row is added.
 
I think the column was set up using a formula because the Data Type seems to have been determined by creating a formula since it is not editable.
 
I just need to see the formula that was used to create the column.  Is this possible?  
 
Any suggestions would be greatly appreciated!
Categories:
Tables
  • bscarlavai33 Profile Picture
    bscarlavai33 243 on at
    View Column Formulas Previously Created
    Yeah it doesn't seem like its a formula field. A formula field lets you edit the formula.
     
    Data type isn't editable when editing any field anyways. Like ankit mentioned, it does seem like some sort of custom solution to autonumber the field.
     
  • Suggested answer
    ankit_singhal Profile Picture
    ankit_singhal 305 on at
    View Column Formulas Previously Created
    I think they have implemented auto numbering for this column and we have multiple ways to implement this. Maybe there is a custom code which is triggered on create the records and set the numbering. Another way is using XRM tool box for auto numbering and using the Power Platform auto number feature. 
     
    Note: Please mark verified, if it is useful for you 
     

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

Quick Links

September 2024 Newsletter…

September 2024 Community Newsletter…

Community Update Sept 16…

Power Platform Community Update…

Tuesday Tip #2 Global Search…

Welcome to a brand new series, Tuesday Tips…

more Community News

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 142,008

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,531

Leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans