cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Ömer
Resolver I
Resolver I

Gallery Filtering by explicit User

Hello everyone I have a quick question.

I want to filter a gallery explicitly by the user who uses the app. I have an Office 365 connection and I want to explicitly say in the gallery that the user can only see their entries. On the internet I saw a video where this formula was used:

 

Filter(DataSource; Created By E.Mail User.....

but unfortunately it does not work for me.

 

My filter function looks like this

 

Filter(DevelopmentIdea;Or(txt_Search.Text in Customer; txt_Search.Text in Title;txt_Search.Text in RequestedFrom);IdeaType.Value=Drp_DevelopmentType.Selected.Value)

 

Now I want to filter the explicit user here. How do I do that?

 

1 ACCEPTED SOLUTION

Accepted Solutions
Nogueira1306
Super User
Super User

Search(Filter(DevelopmentIdea;'Created by'.Email = User().Email;IdeaType.Value=Drp_DevelopmentType.Selected.Value);txt_Search.Text;"Customer";"Tilte";"RequestedFrom")

 

Try using search for text inputs

 

https://docs.microsoft.com/en-us/power-platform/power-fx/reference/function-filter-lookup

 

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!

Buy me a coffee!

Check my User Group (pt-PT)!

Last Post on Community

My website!

View solution in original post

4 REPLIES 4
Nogueira1306
Super User
Super User

Search(Filter(DevelopmentIdea;'Created by'.Email = User().Email;IdeaType.Value=Drp_DevelopmentType.Selected.Value);txt_Search.Text;"Customer";"Tilte";"RequestedFrom")

 

Try using search for text inputs

 

https://docs.microsoft.com/en-us/power-platform/power-fx/reference/function-filter-lookup

 

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!

Buy me a coffee!

Check my User Group (pt-PT)!

Last Post on Community

My website!

Ömer
Resolver I
Resolver I

Hello thank you for your help i tried it but i got this Error Message Created by is not recognized

Insert the name of your field there. If you are using a Sharepoint list, that will be the field created by (that displays the user that created the record)

Ömer
Resolver I
Resolver I

Hello your solution worked i maid a mistake from my side. I am workig with a german version so i had to change created by into the german version to erstellt von and then it worked languange barrier 

 

thank you 🙂

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (1,414)