I am looking for some help with creating a Gallery within a power app.
The Gallery is simply named 'Gallery5' which takes draws most of its information from a Sharepoint list named 'StandardsOffered'. Also within that Gallery I have a label named 'ThisCar' which takes its information from the 'Cars' sharepoint list and returns the vehicle number so essentially taking information from 2 different sharepoint list - everything is good to this point.
In the 'StandardsOffered' sharepoint list there is a Column which contains the Vehicle numbers - numerous entries (these are added by a separate power app. There is also a column which records how many times a vehicle has been called which is named 'CalledCount'
What I need is a textbox or label with gallery5 that will lookup the vehicle number which is in the 'ThisCar' label (Taken from the 'Cars' Sharepoint list) and then return the sum of 'CalledCount' for that vehicle from the StandardsOffered sharepoint list.
Can this be done and if so how????
Solved! Go to Solution.