
I'm trying to create a powerApp that will be used by multiple people. My first question is how to have an "app Number" I will call this the charter number. Each time a user starts a new charter, the charter number will increase. My second question is for each user, every time they save the charter the version number will go up. For example: I'm the first user so my first save will be Charter 1.1. The next time I save it will be 1.2, etc. If someone else starts a charter, they will have Charter 2.1. If I complete a charter and start a new one, I will then begin at 3.1.
I'm not able to figure this out. I'm using the CountRows() function to get the records, but it's updating every save instead of staying the same for the appropriate user. Sorry if this is not enough information, I will try to explain in more detail if needed.
Thank you for any help,
Hi @JBennett12 ,
You can add the UserEmail field to the data source and set its value to User().Email when the user adds a new record.
Then you could use this formula to count the rows:
CountRows(DataSource,UserEmail=User().Email)
Best Regards,
Bof