Abhishek Sharma

May 22, 20201 min

Fetch SystemUsers having specific Security Role in a Single PowerAutomate/ Flow step

Here's the Web API query :

https://<org>.crm.dynamics.com/api/data/v9.1/systemusers?
 $select=fullname,internalemailaddress,systemuserid
 &$orderby=fullname
 &$expand=systemuserroles_association($select=name,roleid)
 &$filter=(systemuserroles_association/any(t:t/name eq 'System Administrator'))

Here's how to use it in a single step:

    6590
    3