Customer experience | Sales, Customer Insights,...

Personalization not applying correct column formatting

(0) Share

Report

Posted on by mkirkpatrick

Hi - I am using a Trigger to personalize an email that is confirming a newly created Transaction record and reference the Amount column (which is Currency data type). When I preview the email and do a test send, the Amount shown as $75.00 in the Transaction record is displayed as 75 in the email. I have tried other fields like date fields and am presented with format dropdown when personalizing. Is this a known issue? It's problematic that it is not respecting the data type formatting.

Thanks

Mike

All responses (3)

Answers (0)

Suggested answer

RudyZhang Microsoft Employee on at

Like (0)

Report

Personalization not applying correct column formatting

Hi,

Thank you for your reply, we conducted the following test based on your reply.
1. Created an entity and a field of currency type

2. Added the field as dynamic content in the RTM MKT Email

3. View the preview and actual delivery results

However, according to our test results we are not able to reproduce your issue, may I ask if you're /Total Amount/ is a calculated field?

Also, please check if there are any customized settings or third-party plugins in your environment that are causing your issue.

If this issue is seriously affecting your business, you can use the link below to seek technical support from Microsoft.
https://admin.powerplatform.microsoft.com/support

I hope my answer is helpful to you! If you have any other questions, please feel free to contact me.

Best Regards,
Rudy Zhang
mkirkpatrick 98 on at

Like (0)

Report

Personalization not applying correct column formatting

Here is the field in the Transaction table showing currency:

Personalization in the email:

Amount from sample data in Transaction record:

How it appears in the email preview:

Hope this helps.
RudyZhang Microsoft Employee on at

Like (0)

Report

Personalization not applying correct column formatting

Hi,

We have analyzed the information you have provided and the issue you are experiencing is that the data in /Dataverse is 75.00, but when dynamic content is inserted in the email it shows 75/. Is this correct?

We have tested the above process but are unable to reproduce your issue. Can you please provide more information on this issue? For example, a picture of the issue, etc. This will help us to better understand your problem and come up with a more effective solution.

I hope my answer is helpful to you! If you have any other questions, please feel free to contact me.

Best Regards,
Rudy Zhang