I have a SharePoint Security Group entity with Business Unit (lookup) field and SubGrid (System User).
How can I retrieve the Users on the SubGrid using List Records?
@Lym - Since you mentioned this is a CDS entity, then you could use the "Common Data Service (current environment)" connector with the "List Records" action. By using this particular connector, the "List Actions" options are greater. There is a FetchXML option to filter the list by a defined FetchXML query.
You would use the CDS Advanced Find to create the query, then use the "Download Fetch XML" button to get the xml. Once you have this, just copy/paste it into the "List Records" action.
Please note that you can only use the "CDS (current environment)" connector when is started from a Solution file.
Sorry to keep harping on this, but just something I'm passionate about. From the article I linked which specifically calls out "Dynamics 365 Customer Engagement":
Also, reference these articles:
I would recommend using the new CDS connectors (either one) going forward. Deprecated does not mean it's completely dead, it just means that it's going to be removed soon. Embracing these connectors now, even if there are small drawbacks which are being addressed, puts you in a better position long-term. Having to undo/redo/rework multiple flows due to changing connectors can be a headache.
And, yes, the Dynamics 365 connector will still work, but it's unknown how long this will be the case.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.