web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps - Building Power Apps Show items that were c...

Power Apps - Building Power Apps

Unanswered

Show items that were created by the user in PowerApps

Like (0) Share

Report

Report

Posted on 11 Oct 2022 14:50:24 by Prem4253

519

Hello,

I have a Gallery created to my PowerApps.

When users come to the Form, they can see all the records submitted by any of the users.

Is there a way, were we can restrict users to see other records? Only see records submitted by the Requester.

I have a column named as Requester Name, so the Requestor should only see records that are created by them in the PowerApps Gallery.

Whereas the Owner of the App, should be able to see all the records, submitted by everyone.

Please advise. Thank you for your help in advance.

Categories:

Using Apps Using Formulas

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Community Power Pla... on 11 Oct 2022 at 15:17:13

Like (0)

Report
Re: Show items that were created by the user in PowerApps

Hello,

Yes, you can do that, you will need to use a filter in the Items property of the gallery, however you need to consider these topics:
Power Apps does not have a "roles" logic built-in, you need to implement that via the formulas. For instance, if you want an "Admin" kind of role that sees everything you need to implement. As a suggestion for doing this, try to implement a list/table in which you keep track of who is who (e.g. user1@example.com is and Admin, user2@example.com is a requestor, user3@example.com is an approver)
user global variables to save user relevan information, such as the role, id (e.g. email) that can help to define what this user can do based on the role (e.g. see some or all records)
Set function in Power Apps - Power Platform | Microsoft Learn

So after considering the above, I could suggest a formula for the gallery items like this:
Switch(_UserVar.role, "Admin", requests //no need to filter "Requestor", Filter(requests, RequestorEmail =_UserVar.email) "Approver", Filter(requests, ApproverEmail =_UserVar.email) )

let me know if that helps

Was this reply helpful? Yes No