Hi,
I am working on an App that pulls data from an Azure DB. On the first page of the App, I want to have three drop downs: one that filters the gallery by product (dropdown called "Product"), one that filters the gallery by State, and one that filters the gallery by Plan.
Here is an example of the kind of data I am working with:
The way the DB is set up is each product has a column and in the column it states whether it is Covered, Not Covered, Preferred, Not Preferred, or Unknown. I also am incorporating a circle control that changes color based on the status of the product they filtered the gallery by. Here is the following coloring I want the circles to change based on the Product
Covered = Yellow
Not Covered = Red
Preferred = Green
Not Preferred = Red
Unknown = Black
For this I have the fill of the circles in the gallery set to this:
If(ThisItem.Product_A_Electronic = "Covered", Yellow, ThisItem.Product_A_Electronic ="Not Covered", Red, ThisItem.Product_A_Electronic = "Preferred", Green,ThisItem.Product_A_Electronic ="Not Preferred", Red, Black)
This is working properly, I just need to figure out how to filter this list using the three specified drop down and the data I have.
All help or suggestions are welcome!
Thank you!
