cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kuglarz96
Frequent Visitor

Use submited form as a template to new one on demand

Hi,

 

I created a custom form app , with more than 30 fields to populate and save to sharepoint list.

Due to a lot of fields to populate, I want to create an option to populate new form fields with existing submited form, on user demand, becouse some of them often could be the same.

 

I created a dropdown with currently has following code:

Items:
sharePointListName.uniqueName       /* it gets all already submited forms uniqueNames to dropdown choice */

Now i want to create a button, which after clicking on it, will update all form fields based on already submited form selected in dropdown. Updated fields should be still able to modify. 

Do you know what should I type in OnSelect property of a button ?

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
yashag2255
Dual Super User II
Dual Super User II

Hi @kuglarz96 

 

Yes, you can achieve this by setting up the configuration as:
 
Button -> OnSelect -> Set(ShowLastSaved,true)
 
Now, you can update the Default property of the datacards as:
DataCards -> Default -> If(ShowLastSaved, Last(SPListName).ColumnName, Parent.Default)
 
Here, you need to update the highlighted part with the SP list name and the column that you are trying to fetch in specific datacard.
 
Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

View solution in original post

2 REPLIES 2
yashag2255
Dual Super User II
Dual Super User II

Hi @kuglarz96 

 

Yes, you can achieve this by setting up the configuration as:
 
Button -> OnSelect -> Set(ShowLastSaved,true)
 
Now, you can update the Default property of the datacards as:
DataCards -> Default -> If(ShowLastSaved, Last(SPListName).ColumnName, Parent.Default)
 
Here, you need to update the highlighted part with the SP list name and the column that you are trying to fetch in specific datacard.
 
Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Thank you @yashag2255 !

 

That wasn't exactly solution for my issue, but based on this I found it by myself:

BUTTON OnSelect:
Set(UseTemplate,false);
Set(UseTemplate,true)

DATA FIELD Default:
If (
    UseTemplate,
    LookUp(mySharePointList, uniqueName = Dropdown1.Selected.uniqueName, DataFieldColumnName ),
    Parent.Default
)

DROPDOWN OnSelect:
Set(UseTemplate, false)

Helpful resources

Announcements
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Top Solution Authors
Top Kudoed Authors
Users online (1,983)