Hello all,
I am creating a PowerApps that has a SQL connection.
In this app, I have a combo box (ComboBox6) that has column values from column named Nbr. The user would select the Nbr from this combo box, and based on that selection, I would like to have another combo box (ComboBox7) that takes that selected value, and then searches/filters down the values from another column in the same SQL table where the Nbr column for said record is the same as the selected Nbr in ComboBox6. Couple strange things, though...
Here is my Items property of ComboBox6, which is how I am able to get the values in the Nbr column
And looking at ComboBox6, you can see it works correctly:
So, when a user selects the Nbr they need, I want ComboBox7 to show me the Id of the record that has the selected Nbr. However, I noticed something interesting when trying to get the 'vDbo.vProcessOrder'[@Id] in combo box 7:
So, almost identical formula except it is for the Id column instead of the Nbr column.... but this is what I get inside of the combo box:
There are options to select, but they are all blank (there are no blank values in the Id column). What is going on here? It seems like it is returning a whole table instead of those column values. Why would this behave differently? How could I get the Id values?
Thanks,
Zachary
