Format Dynamic Culture Setting

Documents
1

I have a need to generate documents and format the Currency Values.

I see in the format, I can provide culture...

/* QD.LP is a variable from the passed in JSON */
{{QD.LP}:format(C2, en-US)}

Shows the value in USD ($139.45)
And

{{QD.LP}:format(C2, en-GB)}

Shows the value is GBP (£139.45)

What I want to do is pass a variable to set the culture....

/* QD.LP is a variable from the passed in JSON
CultureValue is a variable from the passed in JSON */
{{QD.LP}:format(C2, {{CultureValue}})}

I tried this, but I get an error when trying to run the Process.

Input string was not in a correct format.

How do I do this? Or is there any suggestions you may have to accomplish this?

2

Hi @sphilson,

Unfortunately, it's not possible to pass the culture value dynamically. The culture value is taken from Documents process settings by default. Probably, you can create several processes to use with a different cultures and select a specific process in Power Automate depending on the JSON value?

image
image806×496 10.9 KB

Best regards,
Petr
Plumsail team