Edit gallery and add new rows

[Jasmin_Sch]

Hi everyone,

I created a repeating table using gallery for my work packages with several items.

I found a way to edit an existing work package via gallery.

I displayed a package names via gallery – after selecting one it leads me to another gallery which is filtered and shows me only the belonging items:

Filter('Arbeitspakete Items';AP_x002d_ID='Gallery Auswahl Arbeitspaket'.Selected.ID)

To edit the items I put this on the OnChange property of the items inside my gallery:

Patch(' Arbeitspakete Items';ThisItem;{Title:InputTitel.Text;Prio:'Input Prio_1'.Selected})

this works!

But I also want to add another row to my gallery to add items to my work package via button. This is where I am totally stucked.

I cant take the function of my button in my “create a new work package screen” because the gallery there is connected with my collection items. The gallery in my “edit screen” is connected with my sharepoint list items.

This is the function of my button in my “create a new work package screen”:

Patch(Items;ThisItem; {LineTätigkeitBezug:InputTitelTätigkeitBezug.Text;LinePrio:'Input Prio'.Selected.Value});;Collect(Items; {LineTätigkeitBezug:""; LinePrio:"" })

Actually I want to edit an existing work package like I used to create it in a gallery. Does anyone has an idea for this?

Thank you very much!

[v-albai-msft]

Hi @Jasmin_Sch ,

What do you mean about “put this on the OnChange property of the items inside my gallery”? Do you mean that you have added a TextInput control inside your gallery and you are now editing its OnChange property?

Do you have two screens and each screen has one gallery? Which gallery do you want to customized?

Actually, I cannot understand your scenario and your requirement from your current information. Please provide more screenshots about your two gallery and it is better if you can give mesome example based on the data from your screenshots.

Best Regards,

Allen

[Jasmin_Sch]

@v-albai-msft Thank you so much for trying to help me on this complicated topic. You are right, my description is very hard to understand. That is why I made you a description in a attached pdf.

What I want at the end: I want to edit an existing work package in the same layout/form using gallery as it is in the „new work package screen“.

But how can I save the changes I made (put them into my collection) and add a new row?

I hope I could make myself clear now :):)

Thank you!!!!!

[Jasmin_Sch]

@v-albai-msft 

PS

I limited the functions in my pdf to 2 items (Action Item and Projekttyp) to make it easier to read through....:)

[Jasmin_Sch]

@v-albai-msft @Can you please help me with this? 

[Spamrancher]

@Jasmin_Sch , if you're trying to Patch a new record, the second argument of the Patch function needs to be "Defaults(Items)", I believe. I might be missing your point, though.

[Drrickryp]

@Jasmin_Sch 

Have you seen @RezaDorrani 's video? He addresses this issue. https://m.youtube.com/watch?v=8I0Pt_8I6k8 

[Jasmin_Sch]

@RezaDorrani @Drrickryp @Spamrancher 

thank you for answering!

I already tried to implement this video but it doesn’t work or I just can’t figure out how to model it ... I desperately start to give up on this now. I did a complete repeating table form exactly as in Shane youngs Video Part 1 (https://m.youtube.com/watch?v=xgznk4XlPCo)
basically I want a combination out of Youngs Video how to edit a repeating table (part 2) and @RezaDorrani Video. So when I am choosing my existing work package and want to edit it again and move to my edit screen (just like in Shane’s Video) I want to see my items in a gallery and edit them (like in Rezas Video)....

[RezaDorrani]

@Jasmin_Sch 

So you need a mixture of Reza and Shane 🙂

Not sure if that exists LOL.

I just released a new video today on editable grid using Dataverse for Teams. Video description includes link to download solution package to import into Dataverse for Teams. You can install and see the entire code base.

https://youtu.be/vRn7br2OaxE

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Thanks,
Reza Dorrani, MVP
YouTube
Twitter

[Drrickryp · Accepted solution]

@Jasmin_Sch 

I believe I have come up with a solution for you.  It involves a hidden form behind a gallery but it is much easier to work with than you are currently doing. The formulas for the Items property of the gallery are shown above it. The gallery is sorted descending by its ID by default so that a blank row will appear at the top of the form. There is a single text box that will filter for company name, city and state. There is a save icon that submits a form and a trashcan icon for deleting the row.

The form is on the same screen (it doesn't have to though) and is hidden.  The user will never see it and it contains all of the fields in the gallery. The dataset is the same as the gallery and the Item property is Gallery1.Selected.  Each control (textinput box in the cards of the form has its default property set to reflect the text in the gallery's control if it is edit mode.  When the Blank row button is pressed, the underlying dataset is patched using a single  blank field and the Defaults() element of Patch().  The blank field will appear at the top of the form.  As the user fills the fields in the gallery, the entries are mirrored in the form.  When the save button is pressed, the form is submitted with all the values entered from the gallery.  If the user doesn't complete the entry, they can come back and edit it again and save it.  There is no need for any complicated patch formulae, collections or variables.

The inspiration for this solution is from @RandyHayes brilliant video Forms Plus found here   https://www.youtube.com/watch?v=w724AECyMxo where a "ghost" form is used for submitting data, maintaining all of the built in features of the OOB edit form for the app.  There is much more in this video and I can't recommend it highly enough.  It really changed my approach to app design!