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:







©2019 by Dynamics365 CRM World. Proudly created with Wix.com