Unanswered

Filtering for two tables for dropdown option

(0) Share

Report

Posted on by Geeam

I want to populate a drop down depending on the user is Admin or not from two tables:

1) SALESMAN: Columns ID(GUID), NAME(Single Line of Text) , LOCATION(Single Line of Text -showing all the locations Salesman Assigned to) and UserRole(Single Line of Text)
2) PERIOD: Columns ID(GUID), YEAR(Single Line of Text) , LOCATION(Single Line of Text-- Values are if admin then all the Locations from Period Table else as in the second argument,

like:

if (UserRole="Admin", Filter(Period, Year=Year dropdown) for the Location field,
with({var_UserAssignedLocations: showcolumns(filter(Salesman, name=user().displayname),Location)}, filter(Period, year = YearDropDown.selected.value, Location in var_UserAssginedLocations)))

(Thanks Akshansh-Sharma for the very useful solution in this community for the second option)

How to best accomplish it, as some or the other error is being thrown for the if statement!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

anandm08 1,936 Super User 2024 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!
hi @Geeam you can try something like this code:
If( UserRole = "Admin", Distinct(Period, LOCATION), // Filter for all locations if user is admin Filter( Distinct(Period, LOCATION), LOCATION in var_UserAssignedLocations && YEAR = YearDropdown.Selected.Value ) )

Was this reply helpful? Yes No
Geeam on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks a lot anandm08 for the quick response. I want year dropdown value for the admin also as Office Locations can change over the year. So need filter for the first argument too. Also, should I create var_UserAssginedLocations somewhere before as in the above example it is created by the With statement.

Was this reply helpful? Yes No