I'm currently using a calendar function/form that lets the user browse for an Employees jobs on a selected date. If the date matches any jobs they have on that date then they're populated in the browse gallery for the user to see.
What I'm trying to do now is if there are no jobs to display for that employee on the selected date then i want to display a label to inform the user that the employee is "Available" on that date.
I've been trying various isEmpty formulas on my Browse Gallery but can't seem to get the syntax correct.
Any help is greatly appreciated.
Solved! Go to Solution.
You can use the CountRows function using the AllItems property of the gallery to determine the visibility of this label. If your gallery is called 'BrowseGallery1', you can set the Visible property of the label to:
CountRows(BrowseGallery1.AllItems) = 0
You can use the CountRows function using the AllItems property of the gallery to determine the visibility of this label. If your gallery is called 'BrowseGallery1', you can set the Visible property of the label to:
CountRows(BrowseGallery1.AllItems) = 0
So simple yet so effective, excellent solution Carlos.
Thank you.
Use this code in the Visible property of the gallery. The IsEmpty function checks if the the gallery has any values and returns a true or false results.
IsEmpty(BrowseGallery1.AllItems)
If you would like a full tutorial on how to create a gallery that shows a message when empty I've provided a link below.
Link to article:
Show A Message If A Power Apps Gallery Is Empty - Matthew Devaney
User | Count |
---|---|
124 | |
87 | |
86 | |
75 | |
69 |
User | Count |
---|---|
214 | |
181 | |
140 | |
97 | |
83 |