web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Select Multiple Column...
Power Apps
Answered

Select Multiple Columns from Combobox Record

(0) ShareShare
ReportReport
Posted on by 505

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

Categories:
I have the same question (0)
  • Verified answer
    Drrickryp Profile Picture
    Super User 2024 Season 1 on at

    @niklasjegg 

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
Haque Profile Picture

Haque 85

#2
WarrenBelz Profile Picture

WarrenBelz 76 Most Valuable Professional

#3
Kalathiya Profile Picture

Kalathiya 38 Super User 2026 Season 1

Last 30 days Overall leaderboard