Answered

Multiple Filter Option

(0) Share

Report

Posted on by pbrainard

173

Below is a filter I'm using to control what is shown on a form. For most users, I only want records related to their department to show up, but for a few select people (not in a user group), I want to show everything. Give them admin access to the app interface. Can someone suggest the best way to incorporate that requirement into the below filter? They have specific job titles, how would it look to filter for MyProfile.Department or JobTitle= "1" || JobTitle "2" ?? Not sure that's even the best way.

Filter( 'WOMS System',(Gallery3_1.Selected.Value="All" || TaskStatus.Value = Gallery3_1.Selected.Value) && Department.Value=Office365Users.MyProfile().Department),

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

AsanKani 710 on at

Like
a
(0)

Report
Copy link

Link copied!
you can use this coding. Now you can filter using jobtitle. Here i am using 'in'. Because some staff job having multiple like "Team Leader, Engineer" or Team Leader, Administrator. If you have consider to filter Team Leader as your jobtitle means need to us in command.

you can try this below coding. I think I am understanding is right !!!

Filter( 'WOMS System',(Gallery3_1.Selected.Value="All" || TaskStatus.Value = Gallery3_1.Selected.Value) && ( Office365Users.MyProfile().Department = Department.Value || "JobTitle1" in Office365Users.Myprofile().JobTitle || "JobTitle2" in Office365Users.Myprofile().JobTitle)
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
pbrainard 173 on at

Like
a
(0)

Report
Copy link

Link copied!
Thanks!! I got it to work. I was getting errors with the in operator, but was able to use the:
Office365Users.Myprofile().JobTitle = "Job Title 1" ||
AsanKani 710 on at

Like
a
(0)

Report
Copy link

Link copied!
In future, may be have error (your job title multiple content) because you have using = operator. I have explain above statement. If you use in Operator use like below
"JobTitle1" in Office365Users.Myprofile().JobTitle
I think you have jobtitle is single. So, you have used = operator. Ok. as your wish. if job title as multiple like
"Team Leader, Engineer"
"Team Leader, Administrator".. this case you must use in operator, otherwise you can't get correct data.

Have a nice day.