Unanswered

New Form with Based on Selected Item from Gallery

(0) Share

Report

Posted on by Jseo

I have a main gallery with the option to add a new record and edit a record.

I would like to have it so when you click into an old record you can add another line into your database with the default values being the old record plus any adjustments you made. I would like to not lose the old record after editing, but rather create a new record

For example (old Record):

Name: Jim

Date: 10/2/2020

New Record:

Name: Jim

Date: 12/2/2022

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

WarrenBelz 156,306 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Jseo ,

It would be something like this to add the existing name

Patch( SPList, Defaults(SPList), {Name: ThisItem.Name} )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Jseo 26 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz ,

Sorry for the question being so vague.
The pencil in red allows me to edit the the record. I would like the paper airplane in blue to open a "new form" that creates a new record in my SQL database, but keeps the current record that I selected from my Gallery to be the default for the fields.

Ideally I would like the settings to look like an "Edit Form" but with a "New Form" functionality. (something similar to below)

My settings for the form are below, which do not work. Can I use your patch in any of these settings?

Was this reply helpful? Yes No
WarrenBelz 156,306 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Jseo ,

You would set Variables for the values in the current record, then use those as the Default for the items in your new form.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Jseo 26 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz ,

I am not too sure how to do that.

My new Form settings are:
I want my ticker in my "New Form" to be populated by the record I selected in my "Browse Gallery". I get a behavior error.
Could you tell me where I am going wrong?

Thanks a lot!

Was this reply helpful? Yes No
WarrenBelz 156,306 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Jseo ,

You cannot run a Patch in the Default of a control - you need to trigger it on an event (OnSelect of a button, OnChange of a control etc), so OnSelect of the gallery would be a good place. Please also read this Microsoft document on Variables

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No