Filter Different Data Sources

(0) Share

Report

Posted on by RenatoF

Hi,

how is it possible to filter datasource B based on values from datasource A.

For example:

1. in datasource A, I have document ID

2. in datasource B, I have document ID, description, quantity, etc.

Now in Screen 1 I have browsegallery 1 where I show values from datasource A and I want when I go to detail screen (which has connection to datasource B) to present data for selected ID from browse gallery 1.

On that detail screen (the one with datasource B) I would like to show either browse gallery or displayform, or data table just need to have filtered data based document ID from browse screen 1 from browse gallery1.

Best regards,

Renato.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Shanescows 2,218 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @RenatoF I have a video on PowerApps Multiple Data Sources that may help.

I don't cover this exactly but I do cover the mechanics of incorporating multiple lists and using them in dropdowns.

Here are your steps:
Screen 2 add a Form
Set the datasource to be DataSourceB
Set the Items to be LookUp(DataSourceB,DepartmentID = BrowseGallery1.Selected.DepartmentID)
That should cover it.

Was this reply helpful? Yes No
RenatoF 23 on at

Like (0)

Report
Copy link

Link copied!

Hi @Shanescows, this helps in case when I have in datasource B only 1 record connected with datasource A, but what if I hade in datasource B situation like this:

ID = 1
No = 1000
Qty = 5

ID = 1
No = 2000
Qty = 6

how to present both no = 1000 and no =2000

I tried with form and gallery but only show one of them.

Br,
Renato.

Was this reply helpful? Yes No
Verified answer

Shanescows 2,218 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!
Since you want to show multiple records I would use a Gallery and Filter.

Screen 2 add Gallery2
Set the Items to be Filter(DataSourceB,DepartmentID = BrowseGallery1.Selected.DepartmentID)
Just tested it and that works.

Was this reply helpful? Yes No