web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Power Apps

Power Apps

Answered

Power Apps

(0) Share

Report

Report

Posted on by Daniela_Andrade

56

Hello!

I am a new Power Apps user and I am facing difficulties with Comb Boxes.

I am buiding na app in which the user chose the item he/she wants to open a purchase order for.

I have a Comb Box where the user will choose the item he/she wants to buy, and I have another Comb Box (liked to the first one) that I expect the product code to appear automatically when the user chooses the item. But I can't succeed with that.

Could you give me na idea of how this can be done?

The database is an excel spreadsheet at One Drive and the data are in different columns in this file.

Thank you.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

KrishnaV 5,023 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Daniela_Andrade ,

This behavior is called cascading, see the below video explaining step by step to implement that:
https://www.youtube.com/watch?v=pkZG2boN7jQ

I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Regards,
Krishna
If this post helps you give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Daniela_Andrade :
Colud you tell me does these combo boxes all multiple selections?
I assume these combo boxes do not allow multiple selctions.
The point is DefaultSelectedItems property,I'v made a test for your reference:
1\My data source(YourTable)
2\Add a combo box(ComboBox3)
Items

YourTable.ProductName

OnChange

Reset(ComboBox3_1)

DisplayFields

["ProductName"]

SearchFields

["ProductName"]

3\Add an other combo box(ComboBox3_1)
Items

YourTable.ProductId

DefaultSelectedItems

Filter( YourTable, ProductName = ComboBox3.Selected.ProductName ).ProductId

DisplayFields

["ProductId"]

SearchFields

["ProductId"]

I think this link will help you a lot:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/controls/control-combo-box#key-properties
Best Regards,
Bof

Was this reply helpful? Yes No

Join the conversation