Filter data by user when they access the app

(0) Share

Report

Posted on by HannePanne

Hi,

I am currently making an app and the main table (with several other tables connected to it) has the a user connected to each record. I want to filter all views by user. Only way I have figured out is to add the User().FulleName on every filter, counter and so on.

Eg:

CountIf(

Companies,

User = User().FullName

)

I wanted to see if there was any possibilities to limit the access to data based on the user when they open the app, so I don't have to duplicate the same line of code everywhere to avoid any data being shown to the wrong user?

The tables I am using is stored in dataverse is that maskes any difference from other data sources.

Categories:

General topics

I have the same question (0)

All responses (1)

Answers (0)

fm_skeller 277 Moderator on at

Like (0)

Report

It appears as though this is not a Power Pages related question - but a question regarding Canvas apps?
On topic - you want to filter data based on the user - is there a particular reason for not using the security model to restrict access for users?

Was this reply helpful? Yes No