Announcements
So basically I'm trying to make a button appear if a particular Excel entry is present, and hidden if the entry is absent. For example, let's say if John's name is present in an Excel column named "Name" then the button to navigate to the second page where the list is going to be displayed (as a gallery) appears. If his name is not present in the column, the button stays hidden.
if you're using a gallery, make sure you're adding the button into the gallery and then one option you could do, is to go into the Visible property of the button and use code similar to this:
If(IsBlank(ThisItem.'Name'),true,false)
If the above doesn't work replace IsBlank with IsEmpty and see if that works
@cfnor,
If you want to check whether the name occurs somewhere in the column 'Name' you could use a CountRows() & Filter() within the Visible property of that button:
//This will return true if a record with the correct name has been found CountRows( Filter( //Change the datasource and hardcoded value of "John" to you specific case Datasource, Name = "John" ) ) > 0
If this solves your question, would you be so kind as to accept it as a solution.
Thanks!
When I edit the Visible property from "true" to this formula, a delagation warning appears.
Hi @cfnor,
Should you use the Excel Business connector, the Filter will be delegable and in this case the filter output should not return more than 2000 records. CountRows() is not delegable, meaning it cannot count 'higher' than 2000. In case of the OneDrive connector you will have to make sure that the Excel table does not contain more records than your Data Row Limit since it does not support delegation - see app settings (max 2000).
Alternatively, you could use:
!IsBlank( LookUp( //Change the datasource and hardcoded value of "John" to you specific case Datasource, Name = "John" ) )
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 382 Super User 2026 Season 2
Mohsin Ali 329
WarrenBelz 187 Most Valuable Professional
