I recently updated a Flow I have that creates several records based on one record being created (it's kicked off by Process Builder). This flow is triggered by the creation of a Needs Assessment (custom object), and one of the actions is to create a Build (another custom object). I wrote two formulas to add up a bunch of Number fields on the Needs Assessment and copy the sum onto a field on the Build. When I test this Flow in action however, neither Build field is being populated at all, and I'm not running into any error messages.
Now, the Formulas in question are fairly long and quite large, as they add up many many number fields (in fact, one of the two is actually summing two separate Formulas because I was hitting a character limit when I tried to do it in one), but I anticipated that I would hit an error when saving my Flow if they were actually invalid.
Does anybody know if Formulas written in visual workflow would raise an error upon saving if they were too long/large? If that's not the issue, does anyone have any other troubleshooting tips?
Best Answer
Two possible workarounds.