Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Pages - General Discussions
Answered

Table permissions

(0) ShareShare
ReportReport
Posted on by 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:
  • Tumi Profile Picture
    8 on at
    Re: Table permissions

    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 

  • Verified answer
    Fubar Profile Picture
    7,966 Super User 2025 Season 1 on at
    Re: Table permissions

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

  • VaidasG Profile Picture
    469 on at
    Re: Table permissions

    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 👍

  • ragavanrajan Profile Picture
    7,036 Most Valuable Professional on at
    Re: Table permissions

    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.

  • Fubar Profile Picture
    7,966 Super User 2025 Season 1 on at
    Re: Table permissions

    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 

  • ragavanrajan Profile Picture
    7,036 Most Valuable Professional on at
    Re: Table permissions

    Hi @VaidasG 

     

     The simple answer is 

     

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

     

    ragavanrajan_1-1656541250636.png

     

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

     

    ragavanrajan_0-1656539813634.png

     

    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.

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Pages

#1
Fubar Profile Picture

Fubar 69 Super User 2025 Season 1

#2
oliver.rodrigues Profile Picture

oliver.rodrigues 49 Most Valuable Professional

#3
Jon Unzueta Profile Picture

Jon Unzueta 43