Skip to main content
Formating formulas for readability
Source Link
Derek F
  • 64.1k
  • 15
  • 55
  • 104

I have a process builder I wanted to convert this process builder in to flow: In PB I have formula as "ISCHANGED([Opportunity].OwnerId ) && CONTAINS([Opportunity].Name, 'SQO') && PRIORVALUE([Opportunity].Owner.Profile.Name) = 'Sales -Tributary Sales Resources'" If

ISCHANGED([Opportunity].OwnerId ) 
&& CONTAINS([Opportunity].Name, 'SQO') 
&& PRIORVALUE([Opportunity].Owner.Profile.Name) = 'Sales -Tributary Sales Resources'

If I use same formula I get error as "The formula expression is invalid: Syntax error. Missing '=''

The formula expression is invalid: Syntax error. Missing '=''

When I convert this formula in flow it looks like this:

AND(
    ISCHANGED([{!$Record.OwnerId}),
    CONTAINS({!$Record.Name}[Opportunity].Name, 'SQO'),
    ISPRIORVALUE({!$Record.{!$Record.Owner.Profile.Name}}) && {!$Record.Owner.Profile.Name} == 'Sales - Tributary Sales Resources'
)

AND( ISCHANGED([{!$Record.OwnerId}), CONTAINS({!$Record.Name}[Opportunity].Name, 'SQO'), ISPRIORVALUE({!$Record.{!$Record.Owner.Profile.Name}}) && {!$Record.Owner.Profile.Name}== 'Sales - Tributary Sales Resources' ) II get the error The formula expression is invalid: Syntax error. Missing '='

The formula expression is invalid: Syntax error. Missing '='

I have a process builder I wanted to convert this process builder in to flow: In PB I have formula as "ISCHANGED([Opportunity].OwnerId ) && CONTAINS([Opportunity].Name, 'SQO') && PRIORVALUE([Opportunity].Owner.Profile.Name) = 'Sales -Tributary Sales Resources'" If I use same formula I get error as "The formula expression is invalid: Syntax error. Missing '=''

When I convert this formula in flow it looks like this:

AND( ISCHANGED([{!$Record.OwnerId}), CONTAINS({!$Record.Name}[Opportunity].Name, 'SQO'), ISPRIORVALUE({!$Record.{!$Record.Owner.Profile.Name}}) && {!$Record.Owner.Profile.Name}== 'Sales - Tributary Sales Resources' ) I get the error The formula expression is invalid: Syntax error. Missing '='

I have a process builder I wanted to convert this process builder in to flow: In PB I have formula as

ISCHANGED([Opportunity].OwnerId ) 
&& CONTAINS([Opportunity].Name, 'SQO') 
&& PRIORVALUE([Opportunity].Owner.Profile.Name) = 'Sales -Tributary Sales Resources'

If I use same formula I get error as

The formula expression is invalid: Syntax error. Missing '=''

When I convert this formula in flow it looks like this:

AND(
    ISCHANGED([{!$Record.OwnerId}),
    CONTAINS({!$Record.Name}[Opportunity].Name, 'SQO'),
    ISPRIORVALUE({!$Record.{!$Record.Owner.Profile.Name}}) && {!$Record.Owner.Profile.Name} == 'Sales - Tributary Sales Resources'
)

I get the error

The formula expression is invalid: Syntax error. Missing '='

Source Link

Flow formula is not working

I have a process builder I wanted to convert this process builder in to flow: In PB I have formula as "ISCHANGED([Opportunity].OwnerId ) && CONTAINS([Opportunity].Name, 'SQO') && PRIORVALUE([Opportunity].Owner.Profile.Name) = 'Sales -Tributary Sales Resources'" If I use same formula I get error as "The formula expression is invalid: Syntax error. Missing '=''

When I convert this formula in flow it looks like this:

AND( ISCHANGED([{!$Record.OwnerId}), CONTAINS({!$Record.Name}[Opportunity].Name, 'SQO'), ISPRIORVALUE({!$Record.{!$Record.Owner.Profile.Name}}) && {!$Record.Owner.Profile.Name}== 'Sales - Tributary Sales Resources' ) I get the error The formula expression is invalid: Syntax error. Missing '='