Hi! I'm fairly new to PowerApps and not sure if what I would like is a possibility.
I want to retrieve distinct names from dataset A : colApp. However, I also want to add an additional filter from another data set(let's say dataset B for this example. The two data sets have column 'Plant #' that have the same data and can be used as the foreign key. Essentially, my dropdown results should only show Names where Approver.Email = varEmail in colApp (dataset A) and status = "confirmed" in dataset B.
Currently this is my distinct function on data set A. This works fine.
Sort(
Distinct (
Filter(
colApp,
Approver.Email = varEmail ),
Name)
,
Result
)
Here is my second filter on dataset B. I'm not sure how to incorporate it into the first filter.
Filter ('Inventory_Updated', EditorStatus = "COMPLETED")
