Table permissions

(0) Share

Report

Posted on by VaidasG

469

hi,

Is it possible in power pages to apply table permission per web page..?

Meaning, I would like to have table limited to Account access type in web page A, and Global access in page B...

Much appreciated 🙂

Categories:

General topics

I have the same question (0)

All responses (6)

Answers (1)

ragavanrajan 7,044 Most Valuable Professional on at

Like (0)

Report

Hi @VaidasG

The simple answer is

1. Create necessary table permissions when you are creating permission make sure you create access type as "Contact"

2. Add web roles to the table permission. Example below

3. Then Go to contacts > related > Assign a web role to the specific user. This will restrict the data if you use a list component to display the data.

More details here:

https://docs.microsoft.com/en-us/power-apps/maker/portals/configure/assign-entity-permissions

Hope it helps.
------------

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

Was this reply helpful? Yes No
Fubar 8,338 Super User 2025 Season 2 on at

Like (0)

Report

If what you are looking for is not what Raga posted, then possibly what you are after is using Web Page Access Control Rules (WPACR), creating one for each respective page and setting the rule to Restrict Read, and then associating that WPACR to a respective Web Role

Was this reply helpful? Yes No
ragavanrajan 7,044 Most Valuable Professional on at

Like (0)

Report

Yes, @Fubar forgot to add that. Thanks

have a look at the below thread for reference.

https://powerusers.microsoft.com/t5/Power-Apps-Portals/Web-Role-with-multiple-Web-Page-Access-Control-Rules-not-working/m-p/868412#M6468

Hope it helps.
------------

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

Was this reply helpful? Yes No
VaidasG 469 on at

Like (0)

Report

Thanks @ragavanrajan and @Fubar

This interesting stuff, but my challenge was a bit different...

I have two web pages.
1st - displaying entity records and has table permission set to Account level. Displaying records for Contacts->Account(Parent)
2nd - creating new entity record and while doing so, triggering multiple cloud flows... Last step of last flow (when all data is processed and authorised) is associating newly created record to the Account. Until this process is complete, I cannot see new record in my record list, and I cannot perform other actions to newly created record (My table permission is Account level!).

If I create table permission at Global level to help 2nd step, it overrides Account permission and in step 1 I can see all records (Not good 😢 )...

So my question was about the ability of applying different access permissions to a different web pages (same table, same user - different page, different permission applied)???

Thanks in advance 👍

Was this reply helpful? Yes No
Verified answer

Fubar 8,338 Super User 2025 Season 2 on at

Like (1)

Report

If you need records to be created straight away Flow is not appropriate as the DataVerse Flow is asynchronous and you need something synchronous. Realtime Workflow or Plugin is probably what you need.

Note: if you are setting Global so you can see a record that is created by the Flow - then this is probably not appropriate. Records created directly to DataVerse (which is what Flow will be doing) are not available on the Portal until the next check by the Portal Cache (depending on where in the portal cache cycle the record is created this can be up to a few minutes and the MSFT SLA on this is actually 15mins).

Was this reply helpful? Yes No
Tumi 8 on at

Like (0)

Report

I am also encountering the same issue.
I have two pages that uses one table , when I set permissions for Page 1 it overrides permissions on Page 2.

How do I solve this ? Please assist

Was this reply helpful? Yes No