Sum of collection based on selection in the gallery

(0) Share

Report

Posted on by rbalza

235

Hi everyone, I am new to using powerapps. How can I sum the total of selected values in the gallery based on the collection when I hit the add button? Thanks, guys! Cheers.

Here's my add button code.

Collect(
 Col1,
 {
 'Job Category': DataCardValue31.SelectedText,
 'Entity Type': DataCardValue39.SelectedText,
 'Job Type': DataCardValue40.SelectedText,
 'Standard Invoice': DataCardValue4.Text,
 'Min Fee': DataCardValue5.Text,
 Qty: DataCardValue25.Text,
 'Complexity Value': DataCardValue3.Text,
 'Nominal Value': Value(DataCardValue5.Text) * Value(DataCardValue25.Text),
 Total: Value(DataCardValue5.Text) * Value(DataCardValue25.Text) * Value(DataCardValue3.Text)
 }
)

Categories:

Building Power Apps