Breaking news from around the world
Get the Bing + MSN extension
Now Available in Community - MBAS 2019 Presentation Videos
Catch the most popular sessions on demand and learn how Dynamics 365, Power BI, PowerApps, Microsoft Flow, and Excel are powering major transformations around the globe. | View Gallery
2019 release wave 2 Discover the latest updates to Dynamics 365Release overview guides and videos Release Plan | Early Access Availability
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Talent TechTalks | Upcoming TechTalks
In today’s blog we will explore how to filter records in PowerApps of Dynamics 365 CRM based on the logged in user in the PowerApps.
Now I have created a default Canvas app for Account entity. As you can see in below screenshot, the list contains all the account records belonging to different users:
Now we have to filter the records based on the logged in user in PowerApps. To achieve this please follow the below steps:
1. Create a default Canvas app for appointment entity by using Dynamics 365 CRM. You can refer our previous blog here.
2. Now, edit the “Item” property of BrowseGallery:
Owner = LookUp(
‘User Name’ = User().Email,
Please see the screenshot below:
The above formula filters the account records by implementing the condition if ownerid is equal to the logged in user by using the function User() in PowerApps.
The User() function in PowerApps returns the information as Email, Full Name and Image about current logged in user in PowerApps.
You can refer this blog to gets more details.
3. Now log in to the other user and you will see the app contains those account records which belongs to the user:
By implementing the above steps we can filter records of Dynamics 365 CRM in PowerApps based on the owner of the records.
Business Applications communities