Unanswered

Filtering Gallery by Current User and a Related Data Field

(0) Share

Report

Posted on by zorban

Hello,

I built an app and now I would need to filter the gallery by the current user and by the category that the user is assign to.

Table 1 has the fields Category, current user's email address

Table 2 has the fields Category, assigned user's email address

A user can be assigned to multiple categories.

How could I accomplish this?

Thank you for the help in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (0)

Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (0)

Report

Example:

Filter( Your_List, 'Created by'.Email = User().Email)

Instead of 'Created by' you can use other fileds such as 'Assigned to', 'Modified by'. That field MUST be a Person field or contains the 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

Check my LinkedIn!

Check my User Group (pt-PT)!

Last Post on Community

My website!

Was this reply helpful? Yes No
zorban 8 on at

Like (0)

Report

Thanks @Nogueira1306, but this does not satisfy the requirements. It does not include the filter for the category that the user is assign to.

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

Like (0)

Report

Filter( Your_List, 'Created by'.Email = User().Email, Cattery = "Category")

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

Check my LinkedIn!

Check my User Group (pt-PT)!

Last Post on Community

My website!

Was this reply helpful? Yes No
zorban 8 on at

Like (0)

Report

Thanks @Nogueira1306, but this still does not satisfy the requirements. It does not include the relationship for the category and the user that is assign to.

Was this reply helpful? Yes No
v-bofeng-msft on at

Like (0)

Report
Hi @zorban :

Do you want to get something like this?

Filter( Table1, CurrentUsersEmailAddress=User().Email && Category in Filter(Table2,AssignedUsersEmailAddress=User().Email).Category )

Best Regards,

Bof

Was this reply helpful? Yes No
zorban 8 on at

Like (0)

Report
Thanks @v-bofeng-msft ! It is very close, but still getting an error: The specified column is not accessible in this context." The error is for this part of the expression:
Filter(Table2,AssignedUsersEmailAddress=User().Email).Category

Was this reply helpful? Yes No
v-bofeng-msft on at

Like (0)

Report
Hi @zorban :

Could you tell me the exact names and data types of these four fields? Also do they allow multiple selection?

Best Regards,

Bof

Was this reply helpful? Yes No
zorban 8 on at

Like (0)

Report

Hi @v-bofeng-msft ,

Table1 Category Text, Current user email Text
Table2 Category Lookup, assigned user email Email

I also created the category as a text filed on Table2 but getting the same error.
One record can have only one category on Table1. One user email can be assigned to multiple categories.
Thanks for the help!

Was this reply helpful? Yes No