
Hi, I am totally new to this PowerApps.
I am trying to developed a simple New Entry Form in PowerApps for my SharePoint List.
Once the Power Apps startup, it will be a Entry screen per below:
As you can see there is a Title/Risk ID field in the form which it ties to the default Title column in my SharePoint list below:
My question is, how can I made the Risk ID field in the Power Apps entry form to automatically determine which is the last ID in the SharePoint and automatically increment the value and populate as a default in the entry form, so that when users launch on that entry page, there will be default ID available.
Your help is very much appreciated here.
Hey @law90 you can use the below formula for autoincrement of values :-
you need to use this formula on On select property of the button from where you are redirected to the form page
Set(variable name ,Value(Last(database name).'column name '+1));
after that you need to use it in particular column default value as -
variable name which you have used in the above formula.
I hope that it will resolve your query.
Thanks and Regards
Rutuja Khairnar