So let's start with that I'm new to PowerApps and I tend to watch YouTube videos to help guide me on how to build the way I need to haha.
But here's my current problem-set and what I need accomplished:
- SharePoint List dataset with multiple items that have the same name with different values, it was a "on-the-go" inventory sheet, example:
Buildings | Equipment | Amount |
| Building 1 | Monitor | 12 |
| Building 12 | Monitor | 3 |
| Building 2 | Monitor | 11 |
| Building 1 | Monitor | 9 |
- Cascading ComboBoxes because it needs to be grouped for singularity, then filtered down by equipment in buildings
- My current problem is that I need to display the sum of the equipment after those two ComboBoxes have been selected, see below for example:
ComboBox1: Which building you're selecting:
GroupBy('Tracker', "{Name}", "Buildings")
ComboBox2: Which equipment youre selecting from that building:
GroupBy(Filter('Tracker', Building = ComboBox1.Selected.'{Name}'), "Item", "TEST")
And this is where I'm at, I've tried doing labels and text input boxes for displaying the sum of the values from ComboBox2 but I fail every time. I would greatly appreciate some help with this one! And if I'm doing this in a way that isn't efficient, I'll take guidance on that too haha. Thank you all!
