Event banner
Microsoft Syntex AMA
Event Ended
Tuesday, Nov 15, 2022, 10:00 AM PSTEvent details
Microsoft Syntex is Content AI integrated in the flow of work. Syntex automatically reads, tags, and indexes high volumes of content and connects it where it’s needed—in search, in applications, and ...
EmilyPerina
Updated Nov 15, 2022
Wayne_Addison
Nov 14, 2022Copper Contributor
Re Content Assembly feature... I'm trying to generate documents from a SharePoint list with a currency column, each generated doc shows the amount without any formatting (eg shows 4500 when I would like it to show $4500.00), if I format the number to currency in Power Automate (and use the newly formatted variable) I get error 'Answer for data type currency has wrong format'. Has anyone succeeded in embedding formatted currency in documents from SP list columns? Thanks.
IanStory
Microsoft
Nov 15, 2022Thank you Wayne, we'll look into this - I'll ask our content assembly gurus to chime in on this, expect to hear from Ankit or Shreya shortly here!
- Shreya_GangulyNov 16, 2022
Microsoft
Thank you, Ian, for looping me in. Thanks, Wayne, for the feedback. When we tried to reproduce the issue, we saw that in manual document generation we keep the formatting of currency column in the generated document. But for automated document generation via Power Automate flow, as you correctly pointed out - we do not retain the formatting / throw error when you format the field to currency. We have logged this as a bug on our end and we will work on this. We will keep you posted with the progress we make in here. Thank you for your patience. Regards, Shreya Product@Syntex