web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Pages / Where is role membersh...
Power Pages
Answered

Where is role membership stored in Dataverse?

(0) ShareShare
ReportReport
Posted on by 53

I'm trying to have an application workflow where authenticated users can apply for a the ability to have more access on our site.  They submit a form that adds a record to a Dataverse table.  When new records are added, I have that fire off an approval workflow.  I would like to have that workflow automatically grant the user another role if their application is approved.  It didn't look like there was an existing connector to do that, so I thought I could just add or update a record in the Dataverse, but I'm having trouble finding where role membership for external users would be stored.  Hopefully someone who sees this can help with that.

Categories:
I have the same question (0)
  • Fubar Profile Picture
    Super User 2026 Season 1 on at

    Your Portal Users are Contact records in Dataverse/Dynamics 365.  Web Roles are a many-to-may relationship to the Contact record.  

    If you use the Portal Managment app and open a Contact record and select the Portal Contact form you will see a Web Authentication tab with a grid for Web Roles (or you will find it listed under the Related tab)

  • mdenn Profile Picture
    53 on at

    Where are those many-to-many relationships stored?  I need to make the change in a Power Automate Flow, not by manually going into the Portal Management app.

  • mdenn Profile Picture
    53 on at

    I'm trying to do something similar to this solution, but I'm not seeing these connectors in Power Automate now.  Is there a new name for those?

     

    Solved: Assign Web Role for the Portal contact - Power Platform Community (microsoft.com)

  • mdenn Profile Picture
    53 on at

    I tried the Relate Power Automate connector for the Dataverse, but I get an error about "the odata.context annotation is missing from the payload" when I try to do this.  I'm not really seeing much about that error when I search other than some posts from 3 years ago, related to a version issue.  I don't really see other options in that connector, so I'm not really sure what would need to be changed...

    mdenn_0-1683662472208.png

     

  • Jeroen J Profile Picture
    on at

    Experiencing exactly the same. Did you manage to solve it?

  • Verified answer
    mdenn Profile Picture
    53 on at

    I was just recently able to get it to work with getting a list of the web roles, filtering to the row I needed with "adx_name eq '(role name)'" in the filter field, and going through each that came back.  I now have an issue with the page permissions not working right, but that might be just some bug in the platform or something.

    mdenn_0-1685717891539.png

     

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Pages

#1
sannavajjala87 Profile Picture

sannavajjala87 42 Super User 2026 Season 1

#2
Valantis Profile Picture

Valantis 33

#3
11manish Profile Picture

11manish 20

Last 30 days Overall leaderboard