[SalesForce] Flow failing in Field Service Lightning Mobile App but not when run in Browser

I have a flow that is setup to be ran through the Field Service Mobile app. Recently I have made some updates to it, specifically having two fields that are set by the flow be set by formulas instead of just values set by the User in the Flow.

When I built it out and ran it through the Flow Debug mode on my desktop there were no errors and everything functioned fine. When I field tested it from within the Field Service Mobile app however, I get an error saying "Hmm, something's wrong with the YourFormular formula. Please contact your admin.".

The formula is syntactically correct and runs fine in other contexts and as I stated above, the entire Flow runs without issue when run via a debug and sets all values and creates all records as expected.

I have checked out the list of Functions that do not work in Flow formulas (https://help.salesforce.com/articleView?id=flow_considerations_design_formulas.htm&type=5) and none of the functions I am using are listed.

The entire formula is also 255 characters and does not hit the limit nor does it reference any other formula fields.

The only functions I am using are: DATETIMEVALUE(), DATEVALUE(), TEXT(), YEAR(), MONTH(), DAY(), VALUE(), MID(). The resources referenced in the formula are all set in a previous step and are both Date/time values.

Thank you in advance and if you need more info let me know.

EDIT: Adding in my formula.

DATETIMEVALUE( TEXT(YEAR(DATEVALUE({!Start_TimeLabor})))+"-"+ TEXT(MONTH(DATEVALUE({!Start_TimeLabor})))+"-"+TEXT(DAY(DATEVALUE({!Start_TimeLabor})))+" "+TEXT(VALUE(MID(TEXT({!Start_TimeLabor}),12,2)))+ MID(TEXT({!Start_TimeLabor}),14,3)+":00")

Best Answer

This is because there is a VERY limited number of formulas available on flows on the FIeld Service Lightning (FSL) App.

Here's Salesforce's List: https://help.salesforce.com/articleView?id=mfs_flow_considerations.htm&type=5

But incase that link dies:

IMPORTANT Formula functions are case-sensitive. Make sure to use the formatting listed.

Math Operators

  • + (Add)
  • - (Subtract)
  • * (Multiply)
  • / (Divide)
  • () (Open and Close Parenthesis)

Logical Operators

  • == (Equal), only == , not =
  • != (Not Equal), only != , not <>
  • < (Less Than)
  • > (Greater Than)
  • <= (Less or Equal)
  • >= (Greater or Equal)
  • && (And), only && , not AND
  • || (Or), only || not OR

Date and Time Functions

  • DAY
  • MONTH
  • NOW
  • WEEKDAY
  • YEAR

Text Functions

  • BEGINS
  • CONTAINS
  • FIND
  • LEFT
  • LEN
  • LOWER
  • RIGHT
  • SUBSTITUTE
  • TRIM
  • UPPER
  • VALUE

Logical Functions

  • ISBLANK
  • ISNUMBER

Math Functions

  • ABS
  • CEILING
  • FLOOR
  • LN
  • LOG
  • SQRT

Advanced Functions

  • REGEX
Related Topic