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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

How to add custom filter in List page

(0) ShareShare
ReportReport
Posted on by 197

Hi All,

I got a new requirement to add new custom dimension filter in lookup same as legal entity in below screen shot.

6761.pastedimage1678290814463v1.png

I am able to create a dimension value lookup with a new form string control but not able to add the query range to Query.

Can anyone help on this?

Regards,

Swetha.

I have the same question (0)
  • Martin Dráb Profile Picture
    238,562 Most Valuable Professional on at

    You're asking in the General forum, therefore it's not clear which application you mean unless you mention it.\

    Isn't it about Finance and Operations?

  • Swetha Molagavalli Profile Picture
    197 on at

    Hi Martin,

    Yeah it is in F &O.

    Regards,

    Swetha

  • Martin Dráb Profile Picture
    238,562 Most Valuable Professional on at

    All right, I moved your question to Dynamics 365 Finance Forum.

    Unfortunately it's not clear to me either what you're trying to achieve or what problem you have with it.

    You may want to start by explaining why you're "not able to add the query range to Query".

  • Swetha Molagavalli Profile Picture
    197 on at

    Hi Martin,

    Thank you for quick response.

    Based on the multiple selection of dimensions through new control, list page grid needs to filtered based on the dimensions.

    I am not able to find a exact method to add the range because when i tired to create a event handler for new datasource OnQueryExecuting method facing error ""Form datasource <datasource> is not found in ProjProjectsListPage".

    Please help me to find the exact method to add the ranges.

  • Martin Dráb Profile Picture
    238,562 Most Valuable Professional on at

    Please tell us more about your code. Which form is it about, which event are you using, which data source are you trying to get and how?

  • Swetha Molagavalli Profile Picture
    197 on at

    Hi Martin,

    I am using ProjProjectsListPage  list page form. For this list page query added new data source and added new field in the grid.

    Now i want to filter new field based on the lookup values selected. I am trying to use OnQueryExecuting event handler to add the range. But facing error "Form datasource <datasource> is not found in ProjProjectsListPage".

    So i am struck here where to add the code to add ranges to the new filed.

  • Martin Dráb Profile Picture
    238,562 Most Valuable Professional on at

    I'm sorry, but I can't help you to find the bug, because I know nothing about your code. Consider sharing your code and explaining how you added the data source (e.g. whether it's joined to another data source).

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…

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 673 Super User 2026 Season 1

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 673 Super User 2026 Season 1

#3
Abhilash Warrier Profile Picture

Abhilash Warrier 391 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans