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,

Can you share how you are setting the price field previously?

Regards
Ankur

[Patrick Niessen]

Hi Ankur, 

thanks for taking the time.

This is the flow.  The issue is the field "Recurring Price".  If the type in the table is set to "Price" it doesn't work.  I then deleted those fields and recreated them with type "Decimal".  Now its correctly inserted.

[Ankur Bawiskar]

Hi Patrick,

it worked for me when I gave Cost -> USD;101

format -> currency code; cost

you can try for one field

screenshot below

Mark ✅ Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.
Thanks
Ankur

[Patrick Niessen]

Hi Ankur,

where exactly did you set this format?

Best

P