Power Automate change first letter or sign of currency

[MadPrince]

Hi everyone.

I have a problem to solve in my flow, I got stuck in this step.

First I need to pull out a column, then I would check its corresponding column. If the column SEX is Male then the currency should be in Dollar sign and if not, it should be corrected to the needed currency sign.

I provided a sample below. In sex column, male should be in £. And female should be in $ sign.

How do I do that? And some concern, the cells are not in currency format. So that is another problem.

[SanmeshG · Accepted solution]

Hi @MadPrince  ,

I have done a test on my side by writing a small flow and it works fine. 

Please refer the below screenshot.

The expression to replace the $ , £ is as below. Use this in the full expression and use that compose , else use it directly in the Currency column.

The expression replaces $ , to £ and £ to $ based on the sex. If none of the condition match , it places the currency column data as it is.

If(And(Equals(item()?['Sex '],'Male'),Contains(item()?['Currency'],'$')),
Replace(item()?['Currency'],'$','£'),
If(And(Equals(item()?['Sex '],'Female'),Contains(item()?['Currency'],'£')),
Replace(item()?['Currency'],'£','$'),
item()?['Currency']
))

If this helps , please give this answer a thumbs up and accept this as a solution.

Thanks,

Sanmesh

[Amirin]

Hi Sanmesh

What if the column D is not in currency format?

What if the data is like this " $400 payment" 

Because that is my problem, the format is not in currency, but in general.. 

[Amirin]

Hi Sanmesh

Look at the table below, at the 4th row of column M(Incentive Name). it is not in $ sign, What I want is for it to change to $ once the Column Country is United States. And if Column Country is United Kingdom, I want the sign to be in £ sign.

[SanmeshG]

Hi @Amirin ,

That is not a problem , as Power Automate searches for a string in the Currency column and replaces it with the new character as per the condition.

Hope this helps!

If this helps , please give this answer a thumbs up and accept the answer as a solution.

Thanks,

Sanmesh

[sandeepstw]

Hi There,

User 'Get Item' action of SharePoint. you need to give SharePoint targeted list. And then use apply to each action. Add a condition control compare Sex column should be Male. In True part of condition update currency column with £ and in false part use $. 

User separate column to store symbols and append when needed with value. 

Please give kudos and mark as solution if it helps.  

Thanks, 

Sandeep Mishra 

[MadPrince]

Hi guys

Thank you for your help.. All is good now. Appreciate the help..

[SanmeshG]

Hi @MadPrince ,

Please accept the answer as solution.

Thanks,

Sanmesh