web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Apps - Building Power Apps
Unanswered

Gallery row hidden if value in field = yes

(0) ShareShare
ReportReport
Posted on by 121

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:
I have the same question (0)
  • SpongYe Profile Picture
    5,603 Super User 2025 Season 2 on at
    Re: Gallery row hidden if value in field = yes

    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! 🍻

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 686 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 433 Super User 2025 Season 2

#3
wolenberg_ Profile Picture

wolenberg_ 266 Moderator

Last 30 days Overall leaderboard