Re: How can I get the list of Users my Model drive...

bhaski · ‎06-14-2023

How can I get the list of Users my Model driven app is shared with?

Amik · ‎06-14-2023

You can achieve this via Power Automate using the Get Role Assignments action by entering the App ID into the PowerApp Name field.

Note the output is JSON, but you can add another action to export the data into Excel for example.

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Imran-Ami Khan

bhaski · ‎06-14-2023

@Amik Unfortunately it does not work for me.

Amik · ‎06-14-2023

Apologies @bhaski, I should have read the question properly!

Model-driven apps use role-based security for sharing and I believe Get App Role Assignments action is only applicable for Canvas Apps.

Another option is to return all users associated to a Security role using a Gallery. For example apply the below to the Items property of a Gallery and set one of the Labels to ThisItem.'Full Name'.

LookUp(
    'Security Roles',
    Name = "Your Security Role Name"
).Users

And then leverage Power Automate to export that data into Excel for example.

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Imran-Ami Khan

bhaski · ‎06-18-2023

@Amik Thank you for your response. This is effective for a few security roles. But what if you have numerous security roles (in this case, 20)? Is there a PS script that can extract this data? I have several apps with multiple security roles, and entering each security role is a time-consuming process.

Amik · ‎06-19-2023

@bhaski - not that I am aware of. @LinnZawWin & @dpoggemann may possibly have a few ideas.

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Imran-Ami Khan

dpoggemann · ‎06-19-2023

Hi @bhaski,

Please see the following to get roles assigned to users which identifies users assigned to roles.

https://www.marksgroup.net/blog/dynamics-365-view-all-users-security-roles-at-once-with-the-user-sum...

Thanks,

Drew

Hope this helps. Please accept if answers your question or Like if helps in any way.
Thanks,
Drew

LinnZawWin · ‎06-20-2023

@bhaski

You can join the appmodule (Model-Driven App), role (security role) and systemuser (User) tables using the following FetchXML in FetchXML Builder tool to get the list of users who has the role which can access to the apps.

<fetch>
  <entity name='appmodule'>
    <attribute name='name' />
    <link-entity name='appmoduleroles' from='appmoduleid' to='appmoduleid' intersect='true'>
      <link-entity name='role' from='roleid' to='roleid' alias='role' intersect='true'>
        <attribute name='name' />
        <link-entity name='systemuserroles' from='roleid' to='roleid' intersect='true'>
          <link-entity name='systemuser' from='systemuserid' to='systemuserid' alias='systemuser' intersect='true'>
            <attribute name='fullname' />
          </link-entity>
        </link-entity>
      </link-entity>
    </link-entity>
  </entity>
</fetch>

The result would look something like this.

Regards
Linn (Microsoft Business Applications MVP) - Blog | X

Salv · ‎05-27-2024

Hi @Amik. I tried using the Get App Roles action in a workflow and got a failure and the message:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN""http://www.w3.org/TR/html4/strict.dtd">
<HTML><HEAD><TITLE>Bad Request</TITLE>
<META HTTP-EQUIV="Content-Type" Content="text/html; charset=us-ascii"></HEAD>
<BODY><h2>Bad Request - Invalid URL</h2>
<hr><p>HTTP Error 400. The request URL is invalid.</p>
</BODY></HTML>

Do you know what may generate this error and how to fix it?

Thank you

Amik · ‎05-28-2024

@Salv a workflow or Power Automate Flow?

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Imran-Ami Khan

How can I get the list of Users my Model driven app is shared with?

Helpful resources

Community will be READ ONLY July 16th, 5p PDT -July 22nd

Summer of Solutions | Week 4 Results | Winners will be posted on July 24th

Check Out | 2024 Release Wave 2 Plans for Microsoft Dynamics 365 and Microsoft Power Platform

Updates to Transitions in the Power Platform Communities