Power Platform Community Forum Thread Details

I have a sharepoint list that's used in an access database and a PowerApp. The Account number field is used throughout the access database. When a new Account is added to the PowerApp, I need it to auto-assign the next highest available Account Number. In access I would use: =Nz(DMax("CompanyNum","tblCompanies",""),0)+1

How would I do this in PowerApps?

Table: tblCompanies_2

Field: CompanyNum

I've only been using PowerApps for a week or so - FYI - so far from savvy.

Thanks!

Categories:

Building Power Apps