Answered

Detail screen records disappears

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

My app has is showing data when I submit data but when navigating back from the BrowseGallery to that item the records disappears.

The only time it doesn't do this is when I enter the columns in the BrowseGallery, but when I re-edit the app the data disappears and I would have to reenter the data through the BrowseGallery again in order to see the data, but doesn't show on the phone app.

Button Icon that goes to detail screen from Gallery:

Set(glbCurrentRecord, ThisItem); Navigate(DetailScreen1)

DetailForm:

Item: glbCurrentRecord

DataSouce: Bincount (SQL table)

EditForm:

Item: glbCurrentRecord

OnSuccess: Back(); Set(glbCurrentRecord, Self.LastSubmit); Notify("Success: form was successfully saved", NotificationType.Success);

Thanks,

Jvang

Categories:

Building Power Apps

I have the same question (0)

All responses (19)

Answers (1)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@Anonymous

Didn't mean to drop off on our last thread on this topic...been trying to catch up on backlog here.

Not that PowerApps cares too much on the order of evaluation of a formula, but let's first make the OnSuccess action of your form:

Set(glbCurrentRecord, Self.LastSubmit); Notify("Success: form was successfully saved", NotificationType.Success); Back();

What do you mean by "...when I enter the columns in the BrowseGallery..." ??

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@RandyHayes,

On the last Question you told me to enter in the columns that weren't showing data (ThisItem.ColumnName) in the BrowseGallery field which then reflects the data on the detail/edit screen. It works, however, when logging back into PowerApps it disappears and I'd have to reenter the data in order to see the current records.

Thanks,

Jvang

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Anonymous

Ah yes...this would be true. The values you are holding on to in the submit would ONLY be relevant to the current session. If you exit the app and go back in, they would all be starting from scratch - and blank.

So if that is the issue that you are seeing, then perhaps I have misunderstood what you are trying to do.

What is it that you are trying to achieve then? Always having the form show that same information from a record, or only once something is submitted?

If you are going to a "browse gallery", then this is a list of records. If you are clicking on one and then going to a View form, then it should show what was selected in the Gallery. If then editing, it should be what was viewed.

So based on that...what is it that you are trying to do different?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@RandyHayes,

I am just trying to do an inventory app that would allow the user to enter in data and edit data and be able to view how much is in each location. Just a simple app that would be better tracking for inventory.
I want the form to show records from SQL and write back to SQL which it does, but the records disappear.

Thanks,

Jvang

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Anonymous

So this is where we need to be in sync on the terminology. You mention to have the form "show records", but a form does NOT show records, it shows a record. A Gallery would show records, but it is not a form. I do recall all of our prior posts on your scenario, and there was always some question on the large amount of columns and how you were storing data. But, beyond that, you still had a unique part number and if you wanted to show all the bins and their counts for that part number, then a form would do just that.

The Gallery, however, should be a list of Parts, not bins or anything else. Once selected from the Gallery, the form should be showing with the values of the columns in your data. Are you stating that this part of the scenario is NOT working, that when you click on a gallery item, the edit form does NOT show the correct values of the columns from the datasource?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@RandyHayes,

Yes, aside from the BrowseGallery which I only want to show PartNumber, Total QTY, and DateModified.
When Navigating from that Partnumber to see the details screen, only the PartNumber, Total QTY, and DateModified shows data. The other data in the columns are not shown. (Unless I enter them in the BrowseGallery)

Thanks,

Jvang

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@RandyHayes,

For Example:
When opening the App this is what I see. The columns data are not reflecting from the SQL table in the detail/edit form.
The yellow highlight are data I have entered from the browsegallery. The purple are data that I didn't enter and are not show in the detail/edit form.

BrowseScreenDetailFormSQL table

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@Anonymous

But yet you are seeing a01b and a02a! Were those used in your gallery somehow?

Let's first make sure that you have the "Explicit Column Selection" feature turned off in your app. Go to your settings and features and turn that off. SQL is a datasource that will honor that setting and will only gather columns demanded. Since you are setting the variable in the Gallery to the current record, there is no demand for the other columns...and thus will not have values.

So, let's make sure that is off first.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@RandyHayes,

Ok, it has been turned off.

Thanks,

Jvang

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Anonymous

Did that then show you the data you were missing??

Was this reply helpful? Yes No