Filter by user

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Guys, i'm using this code:

If (Label5.Text = "Name" && TextSearchBox2_2.Text = ""; SortByColumns(Filter (DB_Sharepoint; User = "Name1" );"Employer";Ascending);
If (Label5.Text = "Name" && TextSearchBox2_2.Text = "Divergente"; SortByColumns(Filter (BDSharepoint;Status= "Divergente";User = "Name1");"Status"; Ascending);
Search(
 BD_Sharepoint;
 TextSearchBox2_2.Text;
 "User"
 )
))

My label5 is the name registered on office 365, basicaly i'm trying to builter my galery based on who is using
If name = Ed sheeran, will show only Items from John jones
If name = Naruto, will show only items from Game of thrones.

i have 5 employers that will use this app, so i have to filter for all 5 of them, so i will need to use 10 IF's, (If;cond;true;(If;Cond;True;(If;Cond;True;.......)
And when i use more than 3 ifs inside one if, it gives me an error.
Can somebody help me with this?

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

KrishnaV 5,023 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Nope you can use Switch for this:

Switch (TextSearchBox2_2.Text, "Divergente", "for user Divergente", "User-2", "for user User-2", "User-3", "for user User-3", "User-4", "for user User-4", "User-5", "for user User-5", "for all the user as default condition)

Was this reply helpful? Yes No