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?
I've only been using PowerApps for a week or so - FYI - so far from savvy.