Hi All,
I am now creating PowerApps and I would like to when I click on the add button in the new form, the column 'EqNo' will have an automated Equipment Number Generated. Due to the messy of the previous data, I would like to change the new auto number started from a fourth digit.
May I ask how can I achieve it?
Thank you.
My Sharepoint data which shows the EqNo last 3 characters was a 3-digit number originally and I would like from now on, when I add new data, the data in Equipment Number will be in a 4 digit and an English character will also be added. --> (New/6/G0001)

I have used a gallery to show the data.

An add button is added to the screen.


I would like the Equipment Number can be generated automatically in this new-form EqNo column.
May I know how can I achieve it?
Thank you.