Gallery and form don't reflex new data, it took 2 minutes and a refresh to display new data

(1) Share

Report

Posted on by SK-18100053-0

Hi all

I'm creating a form using EDIT which link to GALLERY using "item = Gallery.Selected".

When creating new form or editing form then submitting using "SubmitForm(Form1) ", the data in the EDIT revert back to the data before editing for a few minutes before refreshing to show new data.

I checked the database (excel) it got updated straightaway no delay but it takes really long to reflex back to the apps.

Is there something forgot to do here and/or are there any fix and/or work around to fix this issue,

sorting like remove the selected record of the GALLERY and insert last submit data in to it>

1. Create new form, enter new data, then submit.

2. Nothing will show up for a few minutes, once it shows up, I edit it.

3. Once the data is reflected on the form, edit it with new data then submit.

4. The form and gallery revert back to old data for a few minutes

5. After a few minutes and a few refreshing the new data show up

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

WarrenBelz 153,079 Most Valuable Professional on at

Like (0)

Report
Hi SK-18100053-0
Firstly, Excel is a terrible data source and if you have access to SharePoint Lists, this is easy to solve. However if you have a unique value field in each record of your Table, you can make the Items of the Form
LookUp( TableName, YourIDField = Gallery.Selected.YourIDField )

Also if this does not work, you can add OnSuccess of the Form
Refresh(YourTableName)

Please click Does this answer your question 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 a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee

Was this reply helpful? Yes No
SK-18100053-0 8 on at

Like (0)

Report

@warrenbelz I agree that Excel is a terrible data source.

I started of using SP list, but later switched to Excel for more flexibility and ability to work with pre-existing data.

Moreover, in the app wherever possible e.g. OnSuccess, OnSelect i would put "Refresh(YourTableName)" function to refresh the data, but it just delay and will not update.

If you want to try this bug on you end it's easy (should take less than 10 mins).

I create a new template app using:

1. Start with page Design

2. Gallery connected to external data

3. From Excel and follow through to then end

Now we have one page of form with gallery connected to Excel and what I do next is

4. Duplicate the page into a new page

5. Change the connection of the new page to a different Excel's sheet.

Problem: on the original template page the submit button work normally, data is saved and reflexed straightaway on the GALLERY and EDIT of that page.

But on duplicated page which I've only change one thing which is the connection a different excel sheet as the data source this issue occur.

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

Like (0)

Report

Hi SK-18100053-0

I frequently field post questions on Excel Filters which are (particularly) either a bit complex or are on larger data sets, which technically should work, but simply do not (therefore it is difficult to provide any direction/solution). Excel has very limited Delegation capacity and (as you have discovered) sometimes does not refresh consistently to reflect changes. Unfortunately as a Database, Excel makes a very good Spreadsheet . . .

These issues simply go away if you are using SharePoint (or if you can afford the licences) Dataverse.

Was this reply helpful? Yes No