Answered

Filtering Data From Multiple Data Sets

(0) Share

Report

Posted on by Gdorm

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")

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Community Power Pla... on at

Like (0)

Report
i guess:
Sort( Distinct ( Filter( colApp, Approver.Email = varEmail && Filter ('Inventory_Updated', EditorStatus = "COMPLETED") ), Name) , Result )

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft on at

Like (0)

Report
Hi @Gdorm ,

Please try:

Sort( Distinct ( Filter( colApp, Approver.Email = varEmail && Name in Filter ('Inventory_Updated', EditorStatus = "COMPLETED").Name ), Name), Result )

Best Regards,

Bof

Was this reply helpful? Yes No
v-bofeng-msft on at

Like (0)

Report

Hi @Anonymous ,

Is the problem solved? Do you need any help?

Best Regards,

Bof

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@Gdorm is the owner of this topic

Was this reply helpful? Yes No