I'm trying to use the Data Table (beta) component in a flow, to display records from a record collection variable. The record collection variable is for opportunities, and the data table intends to display a couple of currency fields. However, the values displayed in the currency fields are always displayed with the Euro symbol in front (our default currency) even though the Opportunity Currency is defined and something else (see screenshot).
Does anyone know how to resolve this, so the symbol shown in the data table matches the currency of the record? I've tried using the otherwise excellent UnofficialSF Datatable and encountered the same issue with that.
To confirm, at the end of the flow when it creates records from the record collection variable, it uses the correct currency (i.e. the one defined from the Opportunity Currency field, not euros). Also, the warning in red text is my warning, which I'd like to remove by resolving the problem.
Davis Johnson (SolomonEdwards) Forum Ambassador
Hi Andrew,
I have a feeling this value defaults to the CurrencyISOCode on the current running user, but this is more of a guess at this point. You might be able to override this in an LWC datatable, but I think your only options for staying in flow are changing that value on the user to dynamically line up with the values in columns 4&5 (though, this wouldn't work at all for instances of 2 rows of different currencies!)