Display only current user records using powerfx in canvas app gallery
Most of the times you need to filter records of a gallery in canvas app to display only records created by current login user. So how can you do this.
You can use below PowerFX for the gallery. The below power fx uses search functionality with filter to only fetch created by user is current login user.
Search(
Filter('Travel Requests','Created By'.'Primary Email' = User().Email),
TextInput1.Text,
"sanj_requestnumber",
"sanj_name"
)
Hope this helps.
Follow my blog for more trending topics on Dynamics 365, Azure, C#, Power Portals and Power Platform. For training, Courses and consulting, call to us at +91 832 886 5778 I am working more for community to share skills in Dynamics 365 and Power Platform. Please support me by subscribing my YouTube Channel. My YouTube Channel link is this : https://www.youtube.com/user/sppmaestro