
Hello,
i have a quite specific need for my app. I have a Combobox where i can select an item from my SPO List. this works fine.
My list has multiple columns for different costs. E.g : tooling costs, equipment costs, per unit costs .(at least 15 differendt columns)
I want to be able to: Select which Cost Column i want to add into my calculation and display these columns in a text box.
Sometimes there can we all columns selected. sometimes only one. sometimes 3-10.
i have tried to use a combobox with "showcolums" but i cant figure out how to show the column name and the value.
I appreciate all help. Thanks!
BR Niklas
The solution is likely easier than you think. When a record is chosen in a combobox (or dropdown), all the fields in the selected record are available by reference, not only the one shown in the window of the control. So a calculation can be done as follows:
A Textbox control with the Default property: Combobox1.Selected.'per unit costs' * Combobox1.Selected.'units sold' will show a result for total costs. By placing the "." after Selected, PowerApps will present you with a list of the columns that you can chose from for your formula.