Gallery and Sharepoint List not update after record edit

(0) Share

Report

Posted on by cesarllebron

Hi,

I'm building an app for production record, and have three main screens, all connected to a sharepoint list

1. New Form

2. Edit Form

3. View Form (Where Gallery is)

In the View Form, I have a customized gallery to show specific items within the sharepoint list can be edit, at the edit form.

For every row it has an icon for edit.

1. In the icon, On Select Property has Select(Parent);Set(VarFormType1,Gallery5.Selected);Navigate('EditReporteProduccion Moldeo', Transition.None);

2. In the Gallery5, On Select Property has VarFormType1

3. In the Form "EditFormaMoldeo", On Item Property has VarFormType1.

4. In the Form "EditFormaMoldeo" has a saved button, On Select Property has SubmitForm(FormaMoldeo)

After you press the edit icon at the gallery, it takes you to the edit form with all the information from the record, and works fine.

The problem is that when you edit the record, and press saved button, It will not edit the gallery and neither the sharepoint list, and sometimes leaves spaces in blank at the gallery.

I want to edit the record, show in the gallery as updated and also in the sharepoint.

Please Help!!!, Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

mmollet 3,187 on at

Like (0)

Report

Setting a global variable in this case is uneeded and will just confuse you and add more steps and things to manage in your code. You could either just set the item in your form to Gallery5.Selected or you could pass it in as the 3rd parameter in your navigate function like {VarFormType1: Gallery5.Selected}. The first option will simplify what you are doing by quite a bit. Less code = easier to understand usually.

If your Select(Parent) calls something else that could also make your code confusing. For example if the Parent's OnSelect does something it will be ran and executed before your set call (which you dont need as stated above) and also before your navigate as well. That entire line could simpley be:
Navigate('EditReporteProduccion Moldeo', Transition.None);
Also make sure to set the item property on your form as mentioned above to:
Gallery5.Selected

Do this and see what happens.

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

@cesarllebron

How are you submitting the edit form. Do you have a button to do that and if so what is the OnSelect property?

Was this reply helpful? Yes No
cesarllebron 56 on at

Like (0)

Report

Hi,
Thanks for the quick reply. I did the changes, simplify the code, and move the information from the gallery to the edit form not problem.

But still, when I do a change as example, change the production number from 100, to 1000, the gallery is not update, remains in the 100 (as original)

Was this reply helpful? Yes No
cesarllebron 56 on at

Like (0)

Report

Hi,

In the edit form, I have a button (Save Data),

On Select property has SubmitForm(FormaMoldeo) - "FormaMoldeo" is the name of the form that is connected with the sharepoint list named "Moldeo Production Report".

But when I press the save button not make the change in the gallery and neither the sharepoint list

Was this reply helpful? Yes No
Verified answer

mmollet 3,187 on at

Like (0)

Report

I would maybe try to remove that form and add it back again. You could also create your own custom form using controls and then patch instead of submit form.
For example I tried to use a form for this screen and it was a pain in the ass so I just created my own using controls and have had 0 issues at all since. Here is the custom form end result, looks the same as a form:
This can take some time to set up but then you control how every bit of it works rather than using an out of the box solution that may or may not be working how you think it does.

You could also write a patch statement and just use the fields in that statment and keep the form.
Patch('Moldeo Production Report', ID = Gallery5.Selected.ID, {column1: formdatainput1.text, column2: formdatainput2.text, column3: formdropdown.selected.value, etc....}). This will almost guarantee work. Basically you are using the form as input but using a patch statement rather than submit form call to submit it.

Was this reply helpful? Yes No
cesarllebron 56 on at

Like (1)

Report

Thanks for the answer,
I'll do so!

Was this reply helpful? Yes No