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

Notifications

Announcements

Season of Giving Solutions is Here!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Using ER (Electronic R...
Finance | Project Operations, Human Resources, ...
Suggested Answer

Using ER (Electronic Reporting) I would like to change the filter to find records that CONTAINS a value

(0) ShareShare
ReportReport
Posted on by Sophs@4Sight 241

I have an ER Report that is working fine with the following filter on a record

Filter(TableRecords.DirPartyLocation,TableRecords.DirPartyLocation.PostalAddressRoles="Remit to")

but I need to change the filter to show the record that contains the value "Remit to" and not where it is = (Equal)

I have tried the following but it returns an error 

Filter(TableRecords.DirPartyLocation, Contains(TableRecords.DirPartyLocation.PostalAddressRoles,"Remit to"))

I have the same question (0)
  • Suggested answer
    Alireza Eshaghzadeh Profile Picture
    Alireza Eshaghzadeh 14,743 Super User 2025 Season 2 on at

    Hi Sophs.

    Please try to use Where function instead of Filter.

  • Sophs@4Sight Profile Picture
    Sophs@4Sight 241 on at

    Good day Alireza

    On the report it is working fine with the following filter on a record

    Filter(TableRecords.DirPartyLocation,TableRecords.DirPartyLocation.PostalAddressRoles="Remit to")

    but I need to change the filter to show the record that contains the value "Remit to" and not where it is = (Equal)

    I have tried the following, but it returns an error. 

    Filter(TableRecords.DirPartyLocation, Contains(TableRecords.DirPartyLocation.PostalAddressRoles,"Remit to"))

    also tried: 

    WHERE(TableRecords.DirPartyLocation,(CONTAINS(TableRecords.DirPartyLocation.PostalAddressRoles,"Remit to"))) 

    this query does not give a validation error on the formula designer but gives an error at runtime: "Filtering is not supported. Validate the configuration to get more details about this".

    Thank you.

  • Suggested answer
    Alireza Eshaghzadeh Profile Picture
    Alireza Eshaghzadeh 14,743 Super User 2025 Season 2 on at

    Hi Sophs,

    Can you elaborate that why you need to use contain function?

    Can you fulfil this with and/or function also?

  • Sophs@4Sight Profile Picture
    Sophs@4Sight 241 on at

    Hi Alireza

    Our ER report needs to print two different addresses on the report. 

    The first address selects from the customer addresses where the Purpose = 'Invoice' and the second address selects from the customer addresses where the Purpose = 'Remit to'. 

    The problem is if we use Filter with = 'Invoice'.  The purpose field can have multiple Purposes.  So the field's value for Purpose contains 'Business;Invoice;Remit to'.  If I try to find records where it is = 'Invoice' it wont find the address.  I need to find where Purpose contains 'Invoice'.

    Thank you

  • Suggested answer
    Alireza Eshaghzadeh Profile Picture
    Alireza Eshaghzadeh 14,743 Super User 2025 Season 2 on at

    Hi Sophs@4Sight,

    I dont think that you use contain function for LogisticsLocationRoleType Enum type.

    You can try with OR function to check it helps:

    WHERE(Tables.DirPartyLocation

    , OR(Tables.DirPartyLocationT.PostalAddressRoles="Invoice", Tables.DirPartyLocationT.PostalAddressRoles="RemitTo"))

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

News and Announcements

Season of Giving Solutions is Here!

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 December Top 10 Community Leaders!

These are the community rock stars!

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

#1
Abhilash Warrier Profile Picture

Abhilash Warrier 836 Super User 2025 Season 2

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 441 Super User 2025 Season 2

#3
Martin Dráb Profile Picture

Martin Dráb 346 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans