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 / Comparison of two comb...
Power Apps
Unanswered

Comparison of two combo boxes and output

(0) ShareShare
ReportReport
Posted on by 376

Hi together,

 

I have a SP-list with multiple columns and a PowerApp as FrontEnd for the users to put in their data.

 

Now I`d like to check two seperate fields (both are comboboxes) for their combination and giving an output in field 3, e.g.

 

 

Selection Field 1 = Ice
AND
Selection field 2 = small

Output field 10 = 1.50

OR

Selection Field 1 = Ice
AND
Selection Field 2 = Large

Output field 10 = 2.00

 

How could I do this?

Categories:
  • mmbr1606 Profile Picture
    14,629 Super User 2026 Season 1 on at

    hey @IvenSch 

     

    you can try the following:

     

    Onvisible of screen:

    ClearCollect(PriceData,
     {Field1: "Ice", Field2: "small", Price: 1.50},
     {Field1: "Ice", Field2: "large", Price: 2.00},
     {Field1: "Coffee", Field2: "small", Price: 1.00},
     {Field1: "Coffee", Field2: "large", Price: 1.50}
    );
    

     

     

    OnChange Property of ComboBox1 and ComboBox2:

    UpdateContext({PriceOutput: LookUp(PriceData, Field1 = ComboBox1.Selected.Value && Field2 = ComboBox2.Selected.Value, Price)});
    

     

    Text Property for Outputlable:

    PriceOutput

     

    Be aware that you would need to rename to your needs.

     

    Let me know if my answer helped solving your issue.

    If it did please accept as solution and give it a thumbs up so we can help others in the community.



    Greetings

  • IvenSch Profile Picture
    376 on at

    Which "Onvisible of screen" do you mean?

    IvenSch_0-1715843862773.png

     

    My Output Field actually is a text box. I cannot find Onvisible there.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 345 Super User 2026 Season 2

#2
M Bilal Khan Profile Picture

M Bilal Khan 312

#3
Mohsin Ali Profile Picture

Mohsin Ali 252

Last 30 days Overall leaderboard