Microsoft Dynamics 365 | Integration, Dataverse...

Filtering Data in Power Apps

(0) Share

Report

Posted on by Hannes87

Hello,

i want to create an app with two Excel Sheets:

1) Contains a list of Shops

2) Contains the employees at every shop

So there are two screens. On the first screen you select the shop and on the second screen you see all the employees at the selected shop with their data.
On the second screen there are also two filters that filter the month and year, so you can see which employee worked in which year and month at the

shop.

For filtering the selected shop on the second screen i tried the code:

Filter(
    Assignments;
    Month.Value = drpCurrentMonth.Selected.Value &&
    Year.Value = Text(drpCurrentYear.Selected.Value) &&
    Shop.Value = galShopList.Selected.Name )

Unfortunately the code did not work. Can you please tell me how to use the right code/ filter to transition to the second screen with the right

data from the selected shop and how to filter the months and years?

Thanks!

All responses (2)

Answers (0)

Suggested answer

Almas Mahfooz 11,003 User Group Leader on at

Like (0)

Report

Filtering Data in Power Apps

Assuming Assignments is your table name.

Month and Year are fields from Assignments table,

and galShopList is your gallery

drpCurrentMonth and drpCurrentYear are drop down fields inserted outside of gallery data selection.

Try this.

Filter(Assignments,
    Month = drpCurrentMonth.SelectedText.Value &&
    Year = drpCurrentYear.SelectedText.Value &&
    !galShopList.Selected.Name )
Suggested answer

Leah Ju Microsoft Employee on at

Like (0)

Report

Filtering Data in Power Apps

Hi Partner,

Are you using a canvas app?

If so, you need to ask questions in the following forums for further help:

https://powerusers.microsoft.com/t5/Building-Power-Apps/bd-p/PowerAppsForum1