Answered

Gallery Filter Created By and Assigned to

(0) Share

Report

Posted on by UltimateShine

So im on literally the final step to my app build and have run across this problem.. I have filtered my list so that the user can see only what they have created in the app and what I have manually assigned to them directly via sharepoint. However... On my screen I see my own items and also all the items that I am manually assigned to others because of the 'Created By' field. How can I hide or filter away items that I have created but ARE NOT assigned to me?

Currently my Gallery code is as follows:

Filter('Datasource', 'Created By'.Email = UserEmail || 'Manually Assign To'.Email = UserEmail)

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

zmorek 3,272 on at

Like
a
(0)

Report
Copy link

Link copied!

If(User().Email <> "youremailhere@email.com",
Filter('Datasource', 'Created By'.Email = UserEmail || 'Manually Assign To'.Email = UserEmail),
Filter('Datasource', 'Manually Assign To'.Email <> User().Email)
)
UltimateShine 7 on at

Like
a
(0)

Report
Copy link

Link copied!

Interesting, im getting a double blue line error on the 3rd row:
Filter('Datasource', 'Manually Assign To'.Email <> User().Email)

When I read the code it makes sense to me but Powerapps must have its own mind.
v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @UltimateShine :

double blue line represents the delegation problem, it is recommended to use this formula to replace:

With( {TheEmail:User().Email}, Filter('Datasource', 'Manually Assign To'.Email <> TheEmail) )

In addition,If the problem has been resolved,please consider marking @zmorek 's solution as a 'Solution' to help others.

Best Regards,

Bof