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


Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Power Apps June 2021

June Power Apps Community Call

Did you miss the call? Check out the recording here!

Top Solution Authors
Top Kudoed Authors
Users online (40,910)