Get segment membership with power automate

(1) Share

Report

Posted on by d811eec6-d5bc-442b-...

Hi,

We would like to export all the members of our segment that contains all the bounced emails in the last few months, in an Excel file to send to our accounting dept to make validation if they are still customers or not with Power automate. What table in Dataverse would give us the segment membership?

I can probably make a flow that triggers once a month and that gets the membership list of the segment, but I can't find the table that contains the members.

Thanks!

All responses (3)

Answers (1)

d811eec6-d5bc-442b-... 56 on at

Like (0)

Report

Get segment membership with power automate

Hi,

I have not used HTTP request yet in my short career so I'm a bit usure about using that.

My first thought was to set up a Journey in Real-time that started with a marketing trigger named Bounced emails. Then I would have made a cloud flow that would be triggered when the Journey trigger was triggerred (by bounced emails) and my bet is that I would be able to get all bounced contacts from there and list them in an Excel. My only conceran about this is that I also want to get the bounced reason and I'm not sure the marketing trigger is passing that information.

I didn't get bounced emails since I started this flow so I don't know if it works properly, but I hope to see in the next days!

Thank you for your recommendation, I will try it if my solution does not word.
Dengliang Li Microsoft Employee on at

Like (0)

Report

Get segment membership with power automate

Hi,

Has the issue been solved?
Have there been any updates? Please feel free to ask me if you have any questions!
If it has been resolved, can you mark the response as an answer?
Verified answer

Dengliang Li Microsoft Employee on at

Like (0)

Report

Get segment membership with power automate

Hi,

The segment members are stored in the msdynmkt_MembersList table, and you can send a Post request through the WebAPI, specifying a specific segment id in the payload.

Returns a JSON object containing the segmentation member's id.

Create a Customer Insights - Journeys segment using the Web API - Dynamics 365 Customer Insights | Microsoft Learn

You can send a request in Power Automate Flow to get the members IDs and then get information about each member.

expression: json(body('HTTP')['ResultText'])['members']

If my answer was helpful, please click Like, and if it solved your problem, please mark it as verified to help other community members find more.
If you have further questions, please feel free to contact me .

Best Regards,
Dengliang Li