Showing results for 
Search instead for 
Did you mean: 
Kudo Kingpin
Kudo Kingpin

Edit a record based on a user

Hello there, I am looking for an advice:


Here is my issue, I have an app which is basically a daily report, this report is like a sbumision form and I have 3 buttons one per person, so at the end in my one drive I have a table with all of the record. but now I need to add a gallery to edit any submitted record. but I want that gallery only show the items that the person added.  For instance:


Supervisor 1 = username.()fullname


and maybe add another button "Edit" with the onselect property = if current user is = botton1, then show the gallery in edit mode only their records.


Or maybe any other way easier?




thanks in advance



Power Apps
Power Apps

Have you tried the User().FullName function? You can pass the full name when you create a record, and then in your filter, use the same function and filter your date.


Filter(DataSourceName, username = User.FullName)


Thank you very much for your prompt reply, I will try that one, this filter should be applied in a gallery control or in a form edit?


Bacause in a gallery control I can see mine records in a list and I would like to switch using a navigation bar, and in a form edit I can not see anything

Hi quick question, how can I incorporate the user formula into my gallery which is supposed to be filtered based on the current user:


SortByColumns(Search(TCandA, TextSearchBox1.Text, "Assessor","Country","Date"), "Assessor", If(SortDescending1, Descending, Ascending))



Helpful resources

PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

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