Assuming that the names of the two labels in question are lblPrice and lblCount, set the Text property of the new label to Value(lblPrice.Text)*Value(lblCount.Text)
Tip: as a shortcut, you can use 1*(lblPrice.Text) in place of Value() to change Text to a number in PowerApps.
Hi @adk :
Do you want to group data by product and price, and then get the quantity and total price?
Does price allow multiple selections?
I assume price do not allow multiple selections.I've made a test for your reference:
My data source:
1\Add a datatable and set it's Itmes property to:
RenameColumns( AddColumns( GroupBy( AddColumns( List3, "Theprice", Value(price.Value) ),/*Add the field Theprice to get the unit price of the product in text format*/ "products", "Theprice", "Group" ),/*Group records according to products and Theprice*/ "Count",/*Create new field Count*/ CountRows(Group), /*Calculate the number of records contained in each group*/ "count*price",/*Create new field count*price*/ CountRows(Group) * Value(Theprice) /*Calculate the total price*/ ), "Theprice", "price" /*Renamed Theprice to price*/ )
Thank you all!
In the example you can see what i want to achive:
In the app people can put in a number to order a product. There must be a total in the last column.
The product column is a dropdown list from SP, the price column is attached to that column.
Hi @adk :
Please try this:
1\Add a Blank Vertical gallery
2\Add a label control into this gallery
3\add a label into this gallery
4\Add a textinput control (TextInput2) into this gallery
5\Add a label into this gallery
We're excited to announce our first cross-community 'Can You Solve These?' challenge!
Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.
We are excited for the next Super User season.
FIll out a quick form to claim your community user group member badge today!
Features releasing from October 2020 through March 2021