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.
Solved! Go to Solution.
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.
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
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)
Read the announcement for more information!
Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.
Features releasing from October 2019 through March 2020
Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications