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 Up Program - Build A Canvas App
Answered

Book Copy Filter Choices Not Working

(1) ShareShare
ReportReport
Posted on by 19
Hi All,
 
For this formula "Filter(BookCopies,CheckOutStatus=[@CheckOutStatus].Available)" does not filter out the books based on loan status.
 
Any solution?
 
Thank you all!
Categories:
I have the same question (0)
  • Bezanca Profile Picture
    183 on at
    Book Copy Filter Choices Not Working
    Good job for fixing your own issue  :)  
  • Verified answer
    CU08071747-1 Profile Picture
    19 on at
    Book Copy Filter Choices Not Working
     
    Thanks for coming through. 
     
    But what I did was this.
     
    1. Cleared all history in my browser
    2. Changed password,
     
    and all has worked perfectly using the same formula as shown in the training material.
     
    Thanks
  • Bezanca Profile Picture
    183 on at
    Book Copy Filter Choices Not Working
    Hey 

    Are you trying to filter the gallery based on a dropdown? 

    If so, try changing the formula to this (if you're using a classic dropdown)


    "Filter(BookCopies,CheckOutStatus=[@CheckOutStatus].SelectedText.Value)"
     
    Thanks,
     

     
     

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

Leaderboard > Microsoft Power Up Program Community

#1
w.p Profile Picture

w.p 578 Super User 2025 Season 2

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 295 Super User 2025 Season 2

#3
mmbr1606 Profile Picture

mmbr1606 252 Super User 2025 Season 2

Featured topics