Hello Joyce,

the currency can be edited in the knowledge model - in the variables section you need to change the variable from EUR to USD or do you only want the AF to send out USD data and everything else should be in EUR? If so, you would need to add the currency conversion formula in the AF.

Did you schedule your AF right? Perhaps this is causing the multiple AF sendouts. Or what also could cause this scenario - did you map the data somewhere? If you do this e.g. mapping per employee than you will receive multiple mails from the AF (because every employee would normally get a separate mail).

Let me know if that helped you.

BR

Julia Bauer

Hi Julia! thanks for the help, the issue is when is filling out the excel file, is not maintaining the USD conversion, so not sure how I can preset that, because the file will be updated everytime we run the action flow, right now I need to access the file and manually adjust the currency...

Hi Joyce,

The dollar/euro conversion could be caused by your Excel Locale settings. If your location is in Europe, it might be the case that Excel is changes this automatically (see How To Change Default Currency In Excel - Step-by-Step Guide (simplesheets.co)).

Regarding the multiple executions, every signal (i.e. row in your data) will trigger this flow. To prevent this, you'll need an aggregation operator in the beginning, that gathers all rows and then continue with the flow. The example of @julia.bauer in this post Webhook for DataPush API - Error: Internal error while converting the CSV file to parquet. (celopeers.com) shows this operator in the beginning. The next step would be to transform this to Excel and send it out.

I hope this helps!

Best regards,

Jan-peter

thanks a lot Jan!