I am trying to create a app where if the user deletes the record it will archive it instead of removing it.
I have a text field in the table called visible which is defaulted to yes when the record is created.
I am using a Patch command to update this to No if the user requests it deleted / removed.
My Items property is using the following code.
Sort(Filter(TableComms,'Created By'.Email=User().Email,'Log Date'>=dte_StartDate_2.SelectedDate,'Log Date'<=dte_EndDate_2.SelectedDate),'Log Date',SortOrder.Descending)
I have a date function which allows the user to change the selected dates.
Is it possible to utilise the visible aspect of the Gallery to hide records that have No in the field.
Failing that where would it be placed within the code if it was required within the items.
Thanks


Report
All responses (
Answers (