Customer experience | Sales, Customer Insights,...

Sales Accelerator Segment can't be filtered with lookup field

(1) Share

Report

Posted on by CU21031328-0

Hello,

I wounder if you could help with my issue?

I have a Lead segment and a field Territory that I would like to use, but I'm not getting any value as usual:

On the other hand, if I'm using Advance find all proper values are available:

The 'Contains' criteria can be used on Segment instead, but the thing is that on one segment there is limitation with max 25 condition, and with this limitation we would need to spend 20 of those just for a single filed so it will be extremely useful if there is some additional configuration that I can set, so this field can be used on Segment like any other lookup all over the application.

Regards,

Jelica

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

RudyZhang Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi,

Our team tried to reproduce your operation, but ultimately could not produce the same problem.

You can try modifying the Form of the /Lead/ entity and if you can add Territory from the Form while creating /Lead/, then there might be an issue with the creation of the Segment.

Alternatively, you can create the Segment in the /Segment/ tab and see if your issue recurs, if your issue recurs, this is probably an internal product issue, and you are invited to seek help from Microsoft using the link below.
https://admin.powerplatform.microsoft.com/support

I hope my answer is helpful to you! If you have any other questions, please feel free to contact me.

Best Regards,
Rudy Zhang

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

CU21031328-0 17 on at

Like (0)

Report
Copy link

Link copied!

Thank you for you're response.

I already have this filed on the Lead Form (with expected behaviour)- that is not an issue.

The issue is only with it's usage on Sales Accelerator Segments when I am creating a query.

On the Sales Accelerator Segments only this Builder area is available (the one from the picture), so this is the only place where problem occurs.

Was this reply helpful? Yes No
Nud Dude 2 on at

Like (0)

Report
Copy link

Link copied!

I do have the same problem with a different field. When selecting the Owning Business Unit as filter condition the Value dropdown doesn't suggest any result. The field is avialable on the Opportunity form.

As a workaround I've tried to use the Owning BU by using Add related entity in the condition. But the entiy could get selected there too.

My workaround for now is to use the elated entiy owninguser and filter on the users businessunit which is the same as the Owning BU of the Opportunity record.

But this is not what I would like to suggest to users for the future. Anything I'm missing here?

Thanks and BR

Mario

Was this reply helpful? Yes No
CU17100957-0 2 on at

Like (0)

Report
Copy link

Link copied!

Thanks

Was this reply helpful? Yes No

Join the conversation

Community site session details

Sales Accelerator Segment can't be filtered with lookup field

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2025 Community Spotlights

Congratulations to the February Top 10 Community Leaders

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates

Community site session details

Sales Accelerator Segment can't be filtered with lookup field

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2025 Community Spotlights

Congratulations to the February Top 10 Community Leaders

Subscribe to this forum!

Select categories

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates