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!

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Leah Ju Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

Almas Mahfooz 11,009 User Group Leader on at

Like (0)

Report
Copy link

Link copied!

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 )

Was this reply helpful? Yes No