web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Flowing field from dif...
Small and medium business | Business Central, N...
Suggested Answer

Flowing field from different table

(0) ShareShare
ReportReport
Posted on by Johnson_Patrick 102

Hi,

I want to flow a field from Table1 to Table2 based on few conditions and display it in a list page which is based on Table2. 

I wanted to create the field has a flowfield but the 'conditions' for the field fetches more than 1 record. I suppose, we cannot just show the first record field value from the filter conditions using a flowfield? 

Should i rather create field has a variable in page and populate it onopen/onaftergetrecord of the page? 

or create physical field in the table and populate it onopen/onaftergetrecord, which is the best approach for this?

Thanks

Johnson Patrick

 

Categories:
Dynamics 365 Business Central
I have the same question (0)
  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 21,698 Moderator on at

    Hi,

    If the conditions for the field in Table2 fetch more than one record from Table1, creating a flowfield might not be suitable. Here are two alternative approaches you can consider:

    Create a field as a variable in the page: You can create a variable in the page and populate it with the desired value during the OnOpen or OnAfterGetRecord trigger of the page. This approach allows you to control the logic and fetch the specific value based on your conditions.

    Create a physical field in Table2: Another option is to create a physical field in Table2 and populate it during the OnOpen or OnAfterGetRecord trigger of the page. This approach stores the calculated value in the table itself, allowing you to reuse it without recalculating each time.

    The choice between these two approaches depends on factors such as the complexity of the logic, the need for data persistence, and performance considerations. Evaluate your specific requirements and determine which approach suits your scenario better.

  • Johnson_Patrick Profile Picture
    Johnson_Patrick 102 on at

    Hi,

    Thanks for your reply. The two mentioned approaches doesnt work for me, as i need the value to the physically stored in the table and trying to fetch all the values onpageopen was causing me too much delay in opening the page.

    I followed the flowfield Lookup method and even though the conditions on the FF fetched multiple records, it always displayed the field of interest on the first record.

    See below my code for the FF :

    pastedimage1684143090952v1.png

  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 21,698 Moderator on at

    You can use Calcfield on OnAfterGetRecord trigger of that page.

  • Johnson_Patrick Profile Picture
    Johnson_Patrick 102 on at

    but why though? when i have flowfield defined on the table.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,990

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,576 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,028 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans