Notifications
Announcements
Hello everyone,
There is the original SharePoint ID column, but I want to create a column to format the ID as:
"ID000040" and if it is ID = 1 it will appear like this = "ID000001".
Would this be possible in PowerApps?
@Gorilla_8
If you are doing this on the creation of a record and are using a Form, then you can utilize the OnSuccess action of the Form and add a formula such as this:
UpdateIf(yourDataSource, ID=yourForm.LastSubmit.ID, {yourOtherColumn: "ID" & Text(yourForm.LastSubmit.ID, "000000")} )
I hope this is helpful for you.
@RandyHayes
Thanks for the help, but I tried here, and didn't show the ID
The supplied formula should be working for you.
Where have you placed the formula and what does your formula look like at this point?
I put this code on OnSuccess on the form:
UpdateIf(FichaDeDemanda; ID=FormGeralNew.LastSubmit.ID; {IDTeste: "ID" & Text(FormGeralNew.LastSubmit.ID;"[$-pt-BR]000000")} );;ResetForm(FormGeralNew)
Works great here and your formula looks fine. So, what kind of column is IDTeste ?
Also, is your form actually submitting successfully?
So, what kind of column is IDTeste ?
Its a text simple column
yes, it is
I don't know what to tell you... This is a very simple formula that works well.
Are you using SubmitForm to submit the form or are you bypassing that?
You can attempt to troubleshoot by placing this in the OnSuccess as well:
UpdateContext({testOut: "ID" & Text(Form1.LastSubmit.ID, "000000")})
Put this as the FIRST line of your formula (before you resetform).
Then after submitting, look at your variables and see what testOut is set to.
This is strange because what Randy says should work correctly.
On the off chance, the only other thing I can suggest to is to wrap your reference to FormGeralNew.LastSubmit.ID in a call to Value, which would ensure that Power Apps recognises that as a number.
UpdateIf(FichaDeDemanda; ID=FormGeralNew.LastSubmit.ID; {IDTeste: "ID" & Text(Value(FormGeralNew.LastSubmit.ID);"[$-pt-BR]000000")} );; ResetForm(FormGeralNew)
@RandyHayes and @timl Didn't work for me guys...
What is the formula for the submit button you are using?
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.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 796 Most Valuable Professional
Michael E. Gernaey 327 Super User 2025 Season 2
Power Platform 1919 268
