web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Why Max(Autonumber) fr...

Power Apps

Answered

Why Max(Autonumber) from Dataverse doesn't update

(0) Share

Report

Report

Posted on by Finnair

255

I have Autonumber column in Dataverse and I use that column as a base for an Rownumber field. For testing I have done a button, where I set a new variable for Max(Rownumber) in Dataverse table. The variable works fine when I open the app and press the button, but when I submit new records to the Dataverse table, and press the button after that, the variable value doesn't update.

I wonder why?

I have also tried Last() function, but the result is the same.

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Finnair 255 on at

Like
a
(0)

Report
Copy link

Link copied!

Update:

If I update Dataverse connection, the button works fine. Next thing is to include Dataverse connection refresh in the button...
Verified answer

v-dezhili-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Finnair ,

You can try to refresh the data source first under the OnSelect property of bottom, and then use the Max() or Last() formula.
Refresh(EmployeeContacts);Set(Var,Last(EmployeeContacts).ID)

Best Regards,
Dezhi

Join the conversation