Submitting EditForm-filter error

[pketeldijk]

I have an app for collecting and editing data from a SharePoint list. The app consists of three screens. A Main Screen, Detail Screen and an Edit Screen.

On the Main Screen in my items gallery (GalleryMainItems) I filter data based on Status (Open-In progress-On hold-Completed). I use another gallery (GalleryMainButtons) for displaying 4 buttons from a list Status (column: list_Status) for filtering on (Open-In progress-On hold-Completed). Status is a lookup from a column in the main list WorkorderListPiket. The app is always opened with the Open filter (Status).

I use the following code which works fine for filtering in my items gallery:

Filter(WorkOrderListPiket, Status.Value = GalleryMainButtons.Selected.list_Status)

When submitting data in the EditScreen (EditForm) the user is navigated back to the Detail Screen to see the changes he made. When the Status is changed I get the following message: "Getting your data..." on the Detail Screen. The Status is changed though when I go back to the Main Screen.

I know this is because I use a filter (based on Status) on the Main Screen and use Gallery.Selected to get the data. If I take out the filter on the Main Screen everything shows up fine in the Detail Screen when submitting the EditForm. How do I get the changes to show up in the detail screen when I make a change to Status?

[eka24]

Kindly check the Default Mode of the Form if it is View. You can Insert 3 buttons and Put:

ViewForm(YourFormName)
EditForm(YourFormName)

NewForm(YourFormName)

To change the mode to new, edit and view

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.