So I am wondering is the following achievable,
I have set of data which looks like this
The user than selects a cell from each row
I than need each of those selected cells in each row to be calculated to give a total score
In the example above (the red highlighted cells would equal 6) however this figure could than vary based on the selected cell in each row changing
Is there a formula available that would allow for the total value to adjust based on the selected cells from each row
App is built in canvas
Hope that make sense.
Thank you for you assistance
How are you currently accomplishing the selection of cells for each row in PowerApps? This would impact the solution.
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
Hi @AzJackson ,
Do you mean that:
1)you will select one field in each row?
2)you want to calculate the sum of the selected fields?
Could you tell me whether these fields are number type?
I assume that yes.
I suggest you use collection and gallery in your issue.
I've made a similar test for your reference:
1)set the app's OnStart:
ClearCollect(test,AddColumns(datasourcename,"selectedvalue",0)) //add a column to record the selected value
2)insert a gallery to display the table
set the gallery's Items:
insert multiple labels inside the gallery to display the fields
set their Text like this:
3)in my test, these fields named Title1,Title2,Title3,Title4,Title5,Title6,Title7
set Title1's OnSelect:
set Title2's OnSelect:
Others are similar.
Then the selectedvalue field will be filled in the selected labels' data.
4)set Title1's Color:
set Title2's Color:
Others are similar.
Then only the selected field will be red.
5)insert a label to display the result, set the label's Text:
This will be the result that you want.
Yes thee user will select one cell from each row and yes I would like to calculate the total sum of the selected cells
Can I build this without it being linked to a data source / data connection and use just the data inputs from within the app?
as the outputs do not need to be stored it just needs to be a "calculator" type function
Check out new user group experience and if you are a leader please create your group
Next call is happening on April 21st at 8a PST.
May the fourth be with you, join us online!
See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.