FlowField Search on List Pages

(0) Share

Report

Posted on by ericb27

I have been adding flowfields for lookup data to various list pages. For example here is a snip it from a table extension to add a lookup to a customer name.

field(50221; TSCustomerName; Text[100])
{
Caption = 'Customer Name';
FieldClass = FlowField;
CalcFormula = lookup (Customer.Name where("No." = field("Customer No.")));
}

I then added the field to the list page in a page extension.

field("TSCustomer Name"; TSCustomerName)
{
ApplicationArea = All;
Visible = True;
}

I noticed after users reported that these flow fields are not searchable from the search field on list views in the Business Central Web Client. You can filter them however. Am I missing something or are these fields not searchable at all?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

Suresh Kulla 50,247 Super User 2025 Season 2 on at

Like (0)

Report

I believe that is true since they are flowfields, you can filter only.

Was this reply helpful? Yes No
ericb27 15 on at

Like (0)

Report

My fear seems to be confirmed. So is the only solution to add the columns directly to the table and copy values from the other table on trigger?

Was this reply helpful? Yes No
Suggested answer

Teddy Herryanto (Th... 14,284 Super User 2025 Season 2 on at

Like (0)

Report

If you want to use the search field, you need the value on the table. Talk to the users and see if it is alright to use the filter.

Depending on how you design it, you will need to put the trigger in a couple of places.

Was this reply helpful? Yes No
Suggested answer

Steven Renders 5,672 Moderator on at

Like (0)

Report

There's an idea that you can vote for here:

experience.dynamics.com/.../

Was this reply helpful? Yes No
Miljan Milosavljevic 15 on at

Like (0)

Report

Just voted for this Idea,.I hope it will make it to the some of the next releases.

Was this reply helpful? Yes No