So basically in power apps I have a button and a control. The control is an Input.
The Input has to show the New ID that will be created. This ID should have the first three letters of the users first name and the number should be the one that follows next.
Ex. The name of the user is Angelina so the first part of the ID would be Ang. In sharepoint there is already a registry with the ID Ang1000 so this new registry should show Ang1001.
When the button is clicked in powerapps, in sharepoint a new registry should be created with the ID Ang1001. So the next time i open up PowerApps the input control should show Ang1002.
Also there is around 5 users atm, so how would it work if every user registry gets saved in only one table? There's another user lets say the name is Ariel so the Id should be something like Ari1000.
I hope I explained myself, if not please let me know and i can provide more info and even pic if necessary.

Report
All responses (
Answers (