cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
tonyzhang0510
Level: Powered On

Copy Last Item Button

For my form, most of the times i want to keep most the fields the same and just change the name. How do i have a button that copies the field data of the last item that was submitted and i can submit the item as a new item?

1 ACCEPTED SOLUTION

Accepted Solutions
Merlijn
Level 8

Re: Copy Last Item Button

You can use the property 'default' of the textfield.

 

Sort your source in a descending order (this way it works with large collections), then get the first record of that source and select the field:

 

First(SortByColumns(SOURCE;"id field";Descending)).FieldName

firstlast.png

 

 

With this formula you can set the default values the same as the last entered record.

View solution in original post

2 REPLIES 2
Merlijn
Level 8

Re: Copy Last Item Button

You can use the property 'default' of the textfield.

 

Sort your source in a descending order (this way it works with large collections), then get the first record of that source and select the field:

 

First(SortByColumns(SOURCE;"id field";Descending)).FieldName

firstlast.png

 

 

With this formula you can set the default values the same as the last entered record.

View solution in original post

tonyzhang0510
Level: Powered On

Re: Copy Last Item Button

Nvm, figured it out. Thank you.

Helpful resources

Announcements
thirdimage

Power Apps Super User Class of 2020

Check it out!

thirdimage

New Badges

Check it out!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors
Users online (5,937)