Filtering gallery based on a dropdown, that is being filtered from a table in SQL

(0) Share

Report

Posted on by RRCORTEZ

We have a view created in SQL, that is pulling and filtering a bunch of information. My co-worker has filtered down the information to just the 'cast numbers' (basically just 8 digit numbers with a location associated with them) in the gallery, but we are looking to filter all these casts even more based on a dropdown from another screen. The drop down is associated with the companies/location of other sites, and the cast numbers also have a site number associated with them.

I have tried the following but it just simply returns information matching the original view which is - Items: GET_Casts_App

Filter(GET_Casts_App,Dropdown1.Selected.COM_Active)

I am sorry I am probably leaving out details, as I am still very new to all of this. I can help flesh this out more if anyone helping has questions.

thanks for your time!

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

rpersad 831 on at

Like
a
(1)

Report
Copy link

Link copied!
You can filter your gallery with multiple data
Filter(GET_Casts_App, Value('cast numbers text field'.Text) = cast numbers || Value('cast numbers text field'.Text) = Blank(), Dropdown1.Selected.COM_Active = Location || Dropdown1.Selected.COM_Active = Blank() )

Was this reply helpful? Yes No