Solved! Go to Solution.
Hey David - Do those formulas work to return items?
Yes for Goal 1 no for Goal 2, 3,4,5. when selecting goal 1, the Strats are populated correctly, and the then the gallery is populated with the correct tactics. When I select goal 2, the strategies are populated correctly, but the gallery is void of any tactic data.
Apologies, misread that.
If I use Filter('[dbo].[Tactics]', Strategy_Id=ComboBoxStrategyFilter.Selected.Strategy_Id) It works for goal 1 no problem, but not the other goals.
If I use Filter('[dbo].[Tactics]', Goal_Id=ComboBoxGoalFilter.Selected.Goal_Id) it works for all the Goals correctly but obviously no filter on the Strategy. so I do get all the related tactics per Goal.
If have then tried to combine the two in the following;
(Filter('[dbo].[Tactics]', Goal_Id=ComboBoxGoalFilter.Selected.Goal_Id && Strategy_Id=ComboBoxStrategyFilter.Selected.Strategy_Id),Tactic_Name)
no joy though.
Data Problem!! I checked the DB and we were using a Strategy_Id (Unique) in the Tactics Table where it should have been the Strategy_Number (not unique). Changed that updated all rows and all working! Apologies for wasting your time and thank you .
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
At the monthly call, connect with other leaders and find out how community makes your experience even better.