Share
ReportHi All,
I have a training app where the user can register for various training modules (at various locations).
There is a SharePoint list, and Gallery1 is the register.
To the left, there is also a second gallery Gallery2 to filter on location.
Within Gallery 1, it shows all info, location, date, etc. There is also a "capacity" label to show total availability for the module, and a "remaining capacity" label that counts down the free spaces left until zero (then the register button disables).
The app has grown to be quite popular and more and more training modules are being added. I have been asked to provide a count in the left hand location filter gallery (gallery2) to show "remaining capacity" for each location to allow users to quickly navigate to the locations that have training spaces left for registration.
I am struggling to get the count to work on two conditions.
So far I have this on the text property of my label to count remaining overall availability per location:
If(LocationLabel.Text = ThisItem.Locaton,
Sum(RemainingCapacity.Text))
However, no dice (and to be honest, I'm probably way off the mark).
Any suggestions?
Thanks,
DW
All responses (
Answers (
405
