Update Gallery after SubmitForm

(0) Share

Report

Posted on by Jerfsousa

Good evening everyone,

I've just started to develop some solutions using power apps and I face some difficulties all the time.

I have a Gallery and a Form, they are directly connected to an Excel file as database and when I tap one of registers from gallery, the data goes to form properly then I can change and save data using submitForm, no problem till here.

My problem is when I filter the gallery... for example: Filter(database; status=""), the filter works fine and when I tap the register on Gallery, the data goes to form correctly but, when I change something and submit the form, the gallery does not update! despite data is recorded on database properly.

Is there anything I am doing wrong? Should I use other procedure to save filtered data!? Is there any command to refresh the gallery?

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (1)

WarrenBelz 153,034 Most Valuable Professional on at

Like (0)

Report
Hi @Jerfsousa ,

What is the Items of the Gallery ? You can try

Refresh(DataSourceName)

but you should not have to do this

Was this reply helpful? Yes No
Jerfsousa 27 on at

Like (0)

Report

it is a switch case...

Switch(
cbUser.Selected.Base;
"Base1";Base01;
"Base2";Base02;
"Base3";Base03;
"Base4";Base04;
"Base5";Base05;
"Base6";Base06;
"Base7";Base07;
"Base8";Base08;
"Base9";Base09;
"Base10";Base10;
"Base11";Base11;
"Base12";Base12;
"Base13";Base13;
"Base14";Base14;
"Base15";Base15
)

Was this reply helpful? Yes No
WarrenBelz 153,034 Most Valuable Professional on at

Like (0)

Report

@Jerfsousa ,

OK - that is a bit adventurous and I am not surprised Power Apps does not know to refresh. You may have to do another switch statement to refresh the relevant table and maybe also the gallery.

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
Jerfsousa 27 on at

Like (0)

Report

Great, it is exactly what I need to know.. thanks! I suspected that I was doing wrong, but I am beginner and if you could help me, I would thank you so much.

What is the correct way to allow the user to filter and select data from Gallery, then edit using a form, save and get the gallery updated? Can you help?

Was this reply helpful? Yes No
WarrenBelz 153,034 Most Valuable Professional on at

Like (0)

Report

Hi @Jerfsousa ,

I am saying that to conditionally set your data source with that many options, on either a Form or a Gallery is not something that either control was really designed to do. Why not have one Table with a field for the "Base" number and then filter on this field - your controls would behave much more predictably.

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
Jerfsousa 27 on at

Like (0)

Report

Got it and it makes sense!

My problem is that I have more than 7600 records to be evaluated by 15 engineers (~500 records per engineer), thus I was looking to optimize my app and I have splitted the big database in 15 small parts. When the engineer access using a password, the app switch the database and show only his items.

I am not sure, but as far as I know, PowerApps + Excel has a limitation of lines (I heard something about 2000 lines). Is it true!?

Anyhow, what is the best practices to manage a database with more than 7600 records? Would divide the big database in small parts? The access control makes sense to you? If so, is there any better way to do?

Thanks for your attention one more time...

Was this reply helpful? Yes No
WarrenBelz 153,034 Most Valuable Professional on at

Like (0)

Report

Hi @Jerfsousa ,

Excel is a bit more problematic (although you should eb able to get the records with a single filter), however if you had SharePoint as your data source and a Text field with your Base reference, it would all work very well. In fact, if you have access to SharePoint, I strongly suggest you switch to that anyway.

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
Jerfsousa 27 on at

Like (0)

Report

Thanks Warren, you help is most appreciated!

Yes, I do have sharepoint available, do you know whether sharepoint is able to manage 7600 records? I am a little bit skeptical on this switch from 15 excel files to 1 list in sharepoint, but if you say it would work, I will follow your suggestion...

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,034 Most Valuable Professional on at

Like (1)

Report

Hi @Jerfsousa ,

SharePoint can manage up to 33 million records - I have several Lists between 50 and 100k. Providing you store your Base reference in a Single Line of Text column, you can query the List based on your drop-down selected value in a Delegable manner.

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
Jerfsousa 27 on at

Like (0)

Report

Thanks once more... I will perform some tests and find the best way for the solution.

Was this reply helpful? Yes No