Delegation problem when checking the User().Email = People or group field and Countrows()

(0) Share

Report

Posted on by johnjohn123

3,514

I have the following formula to do a filter :-

where the To & Cc are people or group sharePoint fields which allows multiple selection.. but my formula is raising a delegation error.. can anyone advice on this please? now i am storing the User email inside a variable named varUseremail.

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (16)

Answers (0)

Sort by

Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hey! In filters you cant use ||

Try:

If(varItemID > 0, Filter(varDataSource, ID = varItemID),
SortByColumns(Filter(ProlemForm, 'Created By'.Email = User().Email, ...

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Was this reply helpful? Yes No
johnjohn123 3,514 on at

Like (0)

Report
Copy link

Link copied!

@Nogueira1306what is your formual... it is the same as the one i am using!!

Was this reply helpful? Yes No
Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

You cant use || inside a filter.

Was this reply helpful? Yes No
Ram Prakash Duraisamy 5,864 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Try Using User().Email else go to settings --> change the count for 500 to 2000
if not working try using FIRSTN or LASTN because Powerapps filter will be based on Performance based.

Was this reply helpful? Yes No
johnjohn123 3,514 on at

Like (0)

Report
Copy link

Link copied!

@Nogueira1306so there is not way to make my formula delegable ? in other words i can not return the item created by the login user OR the user inside inside the CC or inside the To fields?
Thanks

Was this reply helpful? Yes No
Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

What you can do is:

SortByColumns(Filter(ProlemForm, 'Created By'.Email = User().Email, CountRows(Filter( CollectionName, Email = varuseremail),CountRows(Filter( CollectionName, Email = varuseremail)

I think your problem is on "To" and "CC"

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@Nogueira1306

Your statement is incorrect - || (OR) and && (AND) are ALL usable in Filters and any other datasource criteria.

They are preferred over any other logic (like If statements) in criteria.

@johnjohn123

Yes - you can make your formula delegable. But your formula logic is not correct based on what you want.

Was this reply helpful? Yes No
johnjohn123 3,514 on at

Like (0)

Report
Copy link

Link copied!

@RandyHayes i want the filter to show the items that are :-

1) Created by the user
2) OR the user is defined inside the To user
3) OR inside the Cc users..

so why my formula is not correct?

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@johnjohn123

Let me refine your statement and tell me if it is correct:

1) Created by the user - Return ALL records in the ProblemForm datasource that were created by the user

2) OR the user is defined inside the To user - If the user is in the To datasource Return ALL records in the ProblemForm datasource

3) OR inside the Cc users.. - If the user is in the Cc datasource Return ALL records in the ProblemForm datasource

Was this reply helpful? Yes No
johnjohn123 3,514 on at

Like (0)

Report
Copy link

Link copied!

@RandyHayes No .. if the user is defined inside the Cc users to only show the items which the user is defined inside the Cc users... same applies to the To!!

Was this reply helpful? Yes No