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... / How to use a flowfield...
Small and medium business | Business Central, N...
Suggested Answer

How to use a flowfield in requestfield from report?

(0) ShareShare
ReportReport
Posted on by InsertX 450

Hi,

So i've created a report that has to contain some requestpage fields. Now i've created 2 fields that are dates just by using global variables.

Now i also want to to make sure they can select the currency by using a flowfield based on the Currency table.

In what way can i implement this?

I have the same question (0)
  • divyeshchitte Profile Picture
    divyeshchitte 968 on at

    You can apply the SetFilter on "DATE FILTER" in Currency Table and obtain the Output.

    Can you please elaborate more to provide you detailed answer.

  • Suggested answer
    Teddy Herryanto (That NAV Guy) Profile Picture
    Teddy Herryanto (Th... 14,284 Super User 2025 Season 2 on at

    Can you elaborate more on what you are trying to do ?

    Do you want to select the currency ? If yes, why use flowfield ?

  • InsertX Profile Picture
    InsertX 450 on at

    I actually might be mistaken about using a flowfield. So what i am trying to do is:

    You can add options to your requestfields of your report. Now at the moment i have 2 fields in there where i can select a date. Now I want to add a third field where i can pick one of the values in the Currency table. So when i click the field the Currency table with all it's stored lines should appear like you would be using a filter.

  • Suggested answer
    divyeshchitte Profile Picture
    divyeshchitte 968 on at

    to do this

    1)  Add new  variable        CurrencyCode: Code[20]; in the report

    2) Add field in request page and give TableRelation. You can use this CurrencyCode var in report to filter the records.

                       field(CurrencyCode;CurrencyCode)

                       {

                           TableRelation = Currency.Code;

                       }

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,917

#2
Jainam M. Kothari Profile Picture

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

#3
YUN ZHU Profile Picture

YUN ZHU 1,025 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans