avoid delegation from multi person field

(1) Share

Report

Posted on by arshad2

how can i avoid the delegation issue to filter the current user from the multi person column

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Sort by

WarrenBelz 155,949 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @arshad2 ,

Can you please post all of that in Text.

Was this reply helpful? Yes No
AJ_vizMan on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @arshad2 - As i can understand, you are using User().Email to get the current user logged in App.
You can do one thing - on 'On Start' property of App use below
Set(Myprofile, User().Email)

And now use 'Myprofile' instead of User.Email() in the formula you are using.
Check if it helps in avoiding delegation

Was this reply helpful? Yes No
WarrenBelz 155,949 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

@AJ_vizMan ,'

That will not help- User().Email is Delegable - the problem is the in Filter searching the multi-person field (which is not Delegable). It may be possible to do some pre-filtering if I have that code in Text.

Was this reply helpful? Yes No
arshad2 51 on at

Like
a
(0)

Report
Copy link

Link copied!

hi @WarrenBelz ,
gallery1:
this is to filter the gallery with the status and current user:

gallery2:
display upon selection of the gallery 1:

is this what you are looking for?

Was this reply helpful? Yes No
WarrenBelz 155,949 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@arshad2 ,

Actual Text (saves re-typing)

Was this reply helpful? Yes No
arshad2 51 on at

Like
a
(0)

Report
Copy link

Link copied!
sorry about that:

If(ThisItem.Filter="All",ClearCollect(Applicants,Sort(Filter('Transport Applicants','Approved By'.Email=User().Email),ID,Descending)),ClearCollect(Applicants,Sort(Filter('Transport Applicants','Department Approval Status'.Value=ThisItem.Filter,'Approved By'.Email=User().Email),ID,Descending)));

If(ThisItem.Filter="All",ClearCollect(FinalApplicants,Filter('Transport Applicants',User().Email in 'Transport Approved By'.Email)),ClearCollect(FinalApplicants,Filter('Transport Applicants','Transport Approval Status'.Value=ThisItem.Filter,User().Email in 'Transport Approved By'.Email)));
ClearCollect(transappli, Applicants,FinalApplicants);

ClearCollect(transappli, Applicants,FinalApplicants);

If(IsEmpty(transappli),UpdateContext({NoData:"No Record Found"}),UpdateContext({NoData:""}));

Was this reply helpful? Yes No
WarrenBelz 155,949 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@arshad2 ,

Actually no opportunity to "pre-filter" as one of the options is a single item (so you simply cannot do it).

Was this reply helpful? Yes No