Combo Box Drop down - SQL Primary Key filtering

(0) Share

Report

Posted on by Johnnyboy1

Hello,

1. I have linked to an SQL server and linked all my tables to the power app.

2. I can create drop-down or combo boxes with these tables and their respective row values within them.

3. I have then made the combo box dependant on the others value (this works for column values within the same table).

4. However when I try to select another table for it depend on it changes the actual data source to that table.

5. As I have set the fact tables with their primary keys in the SQL database I assumed the app would allow me to depend the dropdown on a fact table whilst still showing the value from the dimensional table.

As I have mainly used power BI, once you set the relationship up the intelligence does this for you.

I have been trying to find an answer, thinking the solution could be to create a collection, or a filter / lookup formula. Obviously if I put all these items in the same table that wouldn't be an issue, but this is not ideal for the SQL database.

Help appreciated.

Cheers

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

Your request is not clear. Do you want to pull one table based on the other? If so then a lookUp could be used. If you can restate you point

Was this reply helpful? Yes No
Johnnyboy1 14 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi eka,

I have 4 combo boxes as seen in attached source2. Each box data comes from a different table (source) from the same SQL database.

I want to filter based off the primary keys of the fact tables.

For example
see 2 tables below where plant codes is my primary key in SQL

Plant Items             Plant Code                                                        Plant Codes      Description
Steel                            HM                                                                           HM                      Heavy Material
Wood                         LM                                                                             LM                       Light Material
Rubber                      CH                                                                             CH                        Chemicals
Foam                          CH
Detergent               CH
Poly                             HM

I want to be able to have a combo box for plant codes as the description, which would then filter the next combo box only showing the primary key selected. (ie, if the first combo box selects HM (heavy material) I want the next combo box to only show poly and steel as options)

Was this reply helpful? Yes No
Verified answer

eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

You can start watching this cascading dropdown from Shane Young.
https://youtu.be/pkZG2boN7jQ

With the issue of filtering Sql primary key, I will advise you insert another column in your sql table. Then on your form include a number field that would be used for the filtering.
Kindly watch the video first. Also screenshot of your table would give clear view what you have pasted here.

If you like this post, give a thumbs up. Where it solved your issue, Mark as a solution

Was this reply helpful? Yes No