Answered

Navigate and edit record with highest ID

(1) Share

Report

Posted on by Miguel_Lujan

Hi,

I created a table style gallery that contains a button to duplicate a record.
All works well, but when I run the OnSelect, it takes me to the original record in the form, not the copied record.
So my question is, how do I find and navigate to the copied record (=highest ID) so I can edit the copy?

My current OnSelect of the button:

Patch('MySharepointList',Defaults('MySharepointList'),{Title:ThisItem.'MyTitle'});
Set(SelectedItem, ThisItem);
Navigate('New order')

I tried the functions Last and Max but couldn't get it to work, any help would be great.

Thanks in advance!!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

timl 37,212 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Miguel_Lujan

If SelectedItem is the record that you're showing in your edit form, you can try this:

Set(SelectedItem, Patch('MySharepointList', Defaults('MySharepointList'), {Title:ThisItem.'MyTitle'} ) ); Navigate('New order')

Was this reply helpful? Yes No
Miguel_Lujan 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Tim, thank you so much for your fast reply and your elegant solution! 👍

Was this reply helpful? Yes No
timl 37,212 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

You're welcome @Miguel_Lujan - glad to help!

Was this reply helpful? Yes No