In an app in PowerApps it could be necessary to filter the data by the current user, who is using the app. To achieve this set the Items property of the Gallery to something like this:

SortByColumns(Filter(Timesheet, Author.Email = User().Email), “Date”, If(SortDescending1, Descending, Ascending))

The trick is in the Filter function (also see https://powerapps.microsoft.com/de-de/tutorials/function-filter-lookup). By using the formula

Author.Email = User().Email

only data created by the current user is shown.

Instead of the Email member you can also use the FullName member. In this case the formula looks like

Author.FullName = User().FullName

Advertisements