@smoupre - The simplest method is to create a flow from within a Solution using the "Common Data Service (current environment)" option. I did a test on this and it work perfectly. See points and screen shots below.
- Go to the maker site of https://make.powerapps.com and select the correct environment.
- Choose "Solutions" on the left.
- Create a solution.
- Open the solution and select "+New" from the top and choose "Flow".
- This will launch Power Automate.
Note: I'm not sure what your trigger is to kick off the flow. In my screen shots below, I just used the Flow Button to start it.
- Search for the "Common Data Service (current environment)" using the search field.
- Once you select it, choose "List Records".
- Now comes the cool part: Since you are using the "CDS (current env)" option, there are multiple ways to filter the records. Below you can see I am using Fetch Xml.
- To get the Fetch Xml code you need, just do an Advanced Find in Dynamics 365 and start with Contacts, then choose "Marketing Lists" as the related entity.
- I chose the filter of "Name" equals "<enter your marketing list name>"
Dynamics 365 - Advanced Find
- Click the "Download Fetch Xml" and open it in Notepad.
- Copy the Fetch Xml and paste it in the "Fetch Xml Query" field.
- It will look like this:
Power Automate - Filter with Fetch Xml
I tested the output of this by putting the values into an HTML table:
Power Automate - Output within HTML Table
Here is the resulting output within the HTML table:
Power Automate - HTML Table output
