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 / Microsoft Dynamics 365 | Integration, Dataverse... / Flow Trigger Filter Ex...
Microsoft Dynamics 365 | Integration, Dataverse...
Answered

Flow Trigger Filter Expression

(0) ShareShare
ReportReport
Posted on by danielst 80

Hi,

I have a quick question regarding filter expression in a flow.
I would like the trigger to fire only when the statuscode is set to 'Quality Manager'.

pastedimage1613640923891v2.png

pastedimage1613641081110v3.png

What's wrong with this solution?

pastedimage1613641131191v4.png

Thanks in advance!

  • Verified answer
    meelamri Profile Picture
    meelamri 13,212 User Group Leader on at
    RE: Flow Trigger Filter Expression

    Change statuscode eq 200.010.002 to statuscode eq 200010002.

  • danielst Profile Picture
    danielst 80 on at
    RE: Flow Trigger Filter Expression

    Thank you!

    The value in 'Modify List Value' is grayed out and cannot be changed for me.

    But the Value is 200.010.002.

    Now I have written:

    statuscode eq 200.010.002

    But now I get the following error message:

    Exception parsing statuscode eq 200.010.002 submitted for attribute filterexpression of callback registration. Target entity: kcrm__new_qualitycheck. Exception: Microsoft.OData.ODataException: Syntax error at position 22 in 'statuscode eq 200.010.002'.

      at Microsoft.OData.UriParser.ExpressionLexer.ValidateToken(ExpressionTokenKind t)

      at Microsoft.OData.UriParser.UriQueryExpressionParser.ParseExpressionText(String expressionText)

      at Microsoft.OData.UriParser.ODataQueryOptionParser.ParseFilterImplementation(String filter, ODataUriParserConfiguration configuration, ODataPathInfo odataPathInfo)

      at Microsoft.OData.UriParser.ODataQueryOptionParser.ParseFilter()

      at System.Web.OData.Query.FilterQueryOption.get_FilterClause()

      at System.Web.OData.Query.FilterQueryOption.ApplyTo(IQueryable query, ODataQuerySettings querySettings)

      at System.Web.OData.Query.ODataQueryOptions.ApplyTo(IQueryable query, ODataQuerySettings querySettings)

      at System.Web.OData.Query.ODataQueryOptions`1.ApplyTo(IQueryable query)

      at Microsoft.Crm.ObjectModel.EdmModelEvaluator.EvaluateFilterExpression(String filterExpression, ODataQueryOptions queryOptions)

      at Microsoft.Crm.ObjectModel.EdmModelEvaluator.EvaluateFilterExpression(String filterExpression)

      at Microsoft.Crm.ObjectModel.CallbackRegistrationService.<>c.<.cctor>b__34_0(EdmModelEvaluator evaluator, String testValue)

      at Microsoft.Crm.ObjectModel.CallbackRegistrationService.ValidateInputEntity(IBusinessEntity entity, ExecutionContext context, IFeatureDetailContainer featureDetailContainer)

  • meelamri Profile Picture
    meelamri 13,212 User Group Leader on at
    RE: Flow Trigger Filter Expression

    A little trick to easily generate a filter for power automate. You can use fetchXml Builer tool availble on XrmToolBox: 

    pastedimage1613642715021v1.png

  • Verified answer
    LuHao Profile Picture
    LuHao 40,886 on at
    RE: Flow Trigger Filter Expression

    Hi danielst,

    'Quality Manager' is the label of the option, it can be repeated, we need to use its value instead of label.

    We have to see the value in the classic customization.

    pastedimage1613642356867v1.png

    Take the Lead entity as an example, find its statuscode field.

    pastedimage1613642405935v2.png

    Then we can edit the option to see its value.

    pastedimage1613642441523v3.png

    Finally enter statuscode eq 1 in the flow. (No quotation marks.)

  • Verified answer
    meelamri Profile Picture
    meelamri 13,212 User Group Leader on at
    RE: Flow Trigger Filter Expression

    Hi danielst,

    You need to compare with the statuscode value. It will be something like: "statuscode eq 7000000"

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,261 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 233,017 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Get batch job history log from D365 FO to Power Automate
Gross and Net Weight of Shipments feeding back into Sales Order (from External Source)

Product updates

Dynamics 365 release plans