Get segment membership with power automate

(1) Share

Report

Posted on by Élizabeth Côté

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!

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

Dengliang Li Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Dengliang Li Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Élizabeth Côté 36 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No

Join the conversation

Community site session details

Get segment membership with power automate

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Winners!

Women in Power Builds Momentum

Congratulations to the July Top 10 Community Leaders

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates

Community site session details

Get segment membership with power automate

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Winners!

Women in Power Builds Momentum

Congratulations to the July Top 10 Community Leaders

Subscribe to this forum!

Select categories

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates