Announcements
What would be the way to use the OnStart Property on a Canvas App to filter out Users so that the record would be connected to the logged in user as a Owner?
@samcorg07
Set(Useremail, User().Email) and use Useremail to filter your Data source throughout your app.
Hi @samcorg07,
Do you want to display records only by current user?
If so, I think @Drrickryp has given a correct direction. I just do something extra.
If you have a column containing the owner email in your data source, you just need to create a collection to include the records by current user.
Set the OnStart property of the App as below:
ClearCollect(colUser,Filter(DataSource,UserColumn=User().Email))
Then apply this collection to the place where you want to refer to the data source.
What if I wanted to just use the Owner not Usermail? Also, I'm not using any SharePoint
You need to use the AsType function to compare the 'Full Name'. However, the Office 365 full name could have middle name whereas Dataverse does not include the middle name, so you might have issues comparing on full name. A safer comparison is to use Email instead.
Remember to connect the Users table as a data source in your canvas app in order for the filter to work.
Filter(Accounts, AsType(Owner, Users).'Primary Email' = User().Email)
Note that Accounts is my data source, you should replace it with your table name.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 536
WarrenBelz 426 Most Valuable Professional
Haque 305
