Answered

Filter formula on OnStart Property

(0) Share

Report

Posted on by samcorg07

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?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (2)

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

@samcorg07

Set(Useremail, User().Email) and use Useremail to filter your Data source throughout your app.

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com on at

Like (0)

Report
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.

Was this reply helpful? Yes No
samcorg07 5 on at

Like (0)

Report

What if I wanted to just use the Owner not Usermail? Also, I'm not using any SharePoint

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com on at

Like (1)

Report
Hi @samcorg07,

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.

Was this reply helpful? Yes No