PowerApps · Data Table View Permissions

(0) Share

Report

Posted on by momureithi

Hello,

I have a screen that contains a data table that displays only the logged-in user's requests/data.

How can I set permissions for specific users to view all requests/data, including that which does not belong to them? E.g. allow a manager to view all requests for the staff that reports under them when they log in?

Thanks.

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Sort by

eka24 20,925 on at

Like
a
(1)

Report
Copy link

Link copied!

You did not show how your formula looks like but try
If(User().Email="Manager1@ggg/com" Or "Manager2@ggg/com" ,
YourDatasource,
Filter(YourDatasource,EmailColumn=User().Email))
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
v-siky-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @momureithi ,

How did you restrict user only viewing his own data? By formula in app or by permission level of data source?

What is the data source?

Please share more information about your scenario so that we can provide further assistance.

Sik

Was this reply helpful? Yes No
momureithi 74 on at

Like
a
(0)

Report
Copy link

Link copied!
Hello @v-siky-msft,
My apologies for missing out on that.
I used the formula below to restrict a logged-in user to view their data only.

Filter(dataSource,'Submitted By: '=_myProfile.DisplayName)

I am using a SharePoint list as the data source.
My scenario is, a user submits a request from the app, the request details are sent to the SharePoint list, an automated approval flow is triggered.
The purpose of having the screen/dashboard is to give a user a view of the requests they have made over time and their individual status.

I hope this helps. Thanks.

Was this reply helpful? Yes No
Verified answer

v-siky-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @momureithi ,

Thanks, I got it.

Please try to use the following code to get all direct reports' name.

ClearCollect(col_DirectReport, Microsoft365Users.DirectReportsV2(User().Email).value.displayName)// App.OnStart

Then modify your code as below.

Filter(dataSource,'Submitted By: 'in col_DirectReport.displayName)

Note: Office365Users connector has renamed as Microsoft365Users.

Note: In operator isn't delegable for SharePoint, try to increase the data limit from 500 to 2000, if the SharePoint list has more than 2000 rows data, the above code can only retrieve back the first 2000 rows.

Sik

Was this reply helpful? Yes No
momureithi 74 on at

Like
a
(0)

Report
Copy link

Link copied!

Many thanks, @v-siky-msft.

Is there any chance I can specify email addresses in cases where I want more than the direct report to view the data? Say I want 2 or more people to have these permissions...?

Was this reply helpful? Yes No
v-siky-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @momureithi ,

Do you mean you still want to view request of other specific users, apart form your direct reports?

If so, just add the specific user's Display Name into col_DirectReport collection like this.

ClearCollect(col_DirectReport, Microsoft365Users.DirectReportsV2(User().Email).value.displayName, {displayName: "The User Name"})

Sik

Was this reply helpful? Yes No
momureithi 74 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @v-siky-msft.

Really sorry for my delayed response.

My scenario is, over & above the logged-in user being able to view his/her respective data, I would like to have (different user 1), (different user 2), (different user 3), etc, to view all requests.

I hope this clears up my need. Thank you.

Was this reply helpful? Yes No