{"id":1021,"date":"2017-11-08T16:29:57","date_gmt":"2017-11-08T22:29:57","guid":{"rendered":"http:\/\/www.idubbs.com\/blog\/?p=1021"},"modified":"2017-11-08T16:29:57","modified_gmt":"2017-11-08T22:29:57","slug":"sharepoint-me-filter-in-powerapps","status":"publish","type":"post","link":"https:\/\/www.idubbs.com\/blog\/2017\/sharepoint-me-filter-in-powerapps\/","title":{"rendered":"SharePoint [Me] Filter in PowerApps"},"content":{"rendered":"

SharePoint has a couple of built-in filters for column values: [Today] and [Me]. These allow users to filter views by dynamic data. For example you can create a view called AssignedToMe and set a filter like so: <\/p>\n

\"image\"<\/a><\/p>\n

Using this approach site admins don\u2019t need to create views specific to each user, but can use the [Me] filter on a single view that applies to each individual user. As a user visits the view, they see only the records that are specific to them. <\/p>\n

How does one do this in PowerApps when filtering data? Good question. This came up during our Minnesota SharePoint User Group (MNSPUG<\/a>) meeting today and good old Brian Caauwe knew the answer: rather than using [Me] we use the User function<\/strong> in PowerApps. <\/p>\n

On a gallery or data table object, our Items property might have a formula something like this: <\/p>\n

Items = Filter(‘IT Request’, AssignedTo.DisplayName=User().FullName<\/strong>) <\/p>\n

Note: When bringing fields over from SharePoint, PowerApps translates the CreatedBy and ModifiedBy fields to something a little different. That might be a little confusing when getting started. <\/p>\n