How to use Flow Designer with "Price" field - insert fails

[Patrick Niessen]

Hi,

I am using Flow designer to trigger *on insert* into a "transaction" table, and write some information from this table into another table, e.g.   target_table -> Company = trigger -> transaction table -> company  OK.  

This works completely fine for all field except the Price field (field type Price) and I don't understand why.  

target_table -> Price     =     trigger -> transaction table -> Price    insert takes place for all fields, but no data in the target table Price field

It appears the Price is not a simple field but stores data in another table?

For the moment I have switched to using the decimal field instead of the Price field, and this works, but I would prefer to have the correct field type, also because of the formatting.

Can someone please advise how to solve?

[Ankur Bawiskar]

Hi Patrick,

I am glad to hear the comment has helped.
Saying this, I will appreciate if you close this thread, as answered.
Have a great rest of the day.

Regards
Ankur

[Patrick Niessen · Accepted solution]

The solution we found was to create a custom Action "CONVERT TO PRICE" and put that into the workflow before the insert/update.

[Ankur Bawiskar]

@Patrick Niessen 

Glad to know.

Great!  It looks like you marked your own response as the correct answer, which may be confusing to others that read this later.

If my reply helped you then please mark my response as correct and helpful.

Regards
Ankur