Updating View Form with Updated SharePoint Data, not from the Gallery in the App

[mkusler]

I have an app that collects various bits of information and then stores the information in a SharePoint list. This app works just fine. However, I have a second app that connects to this data source and has a gallery view of all the submissions from the first app as it serves as work queue for the user. 

Item:

SortByColumns(
Filter('Daily Picking Data - NEW DRAFT', Fulfillment.Value = "Incomplete"),
"Created",Descending)

OnSelect:

Navigate(DetailsScreen,ScreenTransition.Fade)

The idea is that the user clicks on each item within the gallery and is taken to a details screen that contains a form view of the information collected from the first app. On this screen is an edit form that contains two boxes, a place to put initials and a place to mark fulfillment complete.

DataSource:

[@'Daily Picking Data - NEW DRAFT']

Item:

Gallery5.Selected

Once the user performs their physical task, enters their initials and then selects "Complete" from the dropdown list they hit submit and they are taken back to the other screen where the gallery is and the item disappears.

However, on a third screen I maintain a list of all the "Completed" items in case they need to go back. However, on this screen the "Initials" and "Fulfillment Status" fields are not showing the updated values which are in SharePoint. 

How can I ensure there values are being read from the updated SharePoint source and not the data as it was in the Gallery? I have tried a few different things that I have seen on the forum, but have not had success with any of them.

[WarrenBelz]

Hi @mkusler ,

What are the Items of the gallery?

[mkusler]

They represent each row of my SharePoint list...

Items:

SortByColumns(
Filter('Daily Picking Data - NEW DRAFT', Fulfillment.Value = "Complete"),
"Created",Descending)

[WarrenBelz]

@mkusler ,

Is that the gallery on the third screen? I was assuming it was the first one.

[mkusler]

Yes. The difference between the two is one shows incomplete and the third screen shows completes, but when you select an item to view details,it isn't showing the updated data that was submitted to SP. I am pretty new to all this, thanks!

[WarrenBelz]

@mkusler ,

Interesting - it should refresh as it is pointing directly at the list. It may however take a few seconds. What code are you using to update the list?

[mkusler]

I'm guessing that I am not using any code to update the list.

Should I build some sort of refresh command into the edit form that contains the two bits of info that are updated by the user?

[WarrenBelz]

@mkusler ,

If you want data to update in a gallery based on a List, you need to write the new data to that list. I am assuming you save the edit form?

[mkusler]

I have a button with a simple "SubmitForm" command, that updates the SP list. That is it.

[WarrenBelz · Accepted solution]

@mkusler ,

That was the code I was referring to - you are updating the list and the gallery should refresh. Your filter is 

Filter(
   'Daily Picking Data - NEW DRAFT', 
   Fulfillment.Value = "Complete"
)

I am assuming the records that are updated are in the Filter? If so, you can refresh the List

Refresh('Daily Picking Data - NEW DRAFT')

but this should not be necessary and affects performance.