Power Platform Community Forum Thread Details

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

Categories:

Building Power Apps

Hi @Markswan20

Try this:

Sort(
 Filter(
 TableComms,
 'Created By'.Email=User().Email,
 'Log Date'>=dte_StartDate_2.SelectedDate,
 'Log Date'<=dte_EndDate_2.SelectedDate,
 visible="Yes" // This part will only select records where visible=Yes
 ),
 'Log Date',
 SortOrder.Descending
)

If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻