Unanswered

Filtering a gallery

(0) Share

Report

Posted on by Jaco_Els

Sort(Filter('The business grabber';'Department HOD EMAIL'.Value = User().Email And IsBlank('ASSIGNED TO'));Created;SortOrder.Descending)

Hi everyone i am stuck here.

The code is underlined in blue from And Isblank('Assigned to'... with a yellow triangle in the gallery.. I have tried || &&

I publish it and the detail doesnt show in the gallery.

anyone tell me how i can get this to work PLEASE!!!

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Sickle-Cell 600 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Jaco,

Truthfully, your code should work as I can't see any syntax errors. The blue lines and yellow triangles are regarding delegation warnings - how many records are you currently working with?

Was this reply helpful? Yes No
Jaco_Els on at

Like (0)

Report
Copy link

Link copied!

Less than the 2000 limit.. 204 records at the moment

Was this reply helpful? Yes No
Hassan_SZ_365 542 on at

Like (0)

Report
Copy link

Link copied!
Hi,
Correct Syntax for Logical AND: Ensure that you are using the correct syntax for the logical AND operator, which is && in Power Apps.
IsBlank Function Usage: When using the IsBlank function, ensure that you are passing a single value, not a column itself. If 'ASSIGNED TO' is a column in your data source, you should check each record individually to see if it is blank.
Delegation Warnings: Power Apps may underline filters in blue and show a yellow triangle if the filter criteria are non-delegable. That means Power Apps cannot delegate the action of filtering to the data source, and it will only operate on the local data already loaded to the app (up to 500 records by default, or up to 2000 if you have increased the data row limit for non-delegable queries).
Here is the corrected formula, assuming 'ASSIGNED TO' is a column that stores text or email addresses and you want to find records where it is not filled:

Sort( Filter( 'The business grabber', 'Department HOD EMAIL'.Value = User().Email && IsBlank('ASSIGNED TO'.Value) ), Created, SortOrder.Descending )

If 'ASSIGNED TO' is a complex type (like a Choice, Person, or Lookup), you may need a different approach, like checking for a default or null identifier.
Lastly, if the Filter function is non-delegable for your data source and you're working with more records than your app can handle locally, you might not see the expected records. In that case, you would need to find a delegable approach for filtering or reduce the scope of data so that it works within Power Apps' delegation limits.

Best Regards,
Hassan Raza

Was this reply helpful? Yes No
Ali_Sheraz_77 141 on at

Like (0)

Report
Copy link

Link copied!
Hi, jaco-Els
[
try this code if the 'assigned to' is person column

Sort( Filter( 'The business grabber', 'Department HOD EMAIL'.Value = User().Email && IsEmpty('ASSIGNED TO'.Email) ),Created,Descending)

]
Please give a thumbs up if this information is helpful.
Best regards,
Ali Sheraz

Was this reply helpful? Yes No
Jaco_Els on at

Like (0)

Report
Copy link

Link copied!

Hi Ali
nope same error
Thanks

Was this reply helpful? Yes No
Jaco_Els on at

Like (0)

Report
Copy link

Link copied!

Thank you Hassan going to try this

Was this reply helpful? Yes No