create Sharepoint column with list of currency choices

New Contributor



I would like to create 2 columns.

1. Currency 

2. PO (Purchase Order) cost


Currency column should show list of currency format ex:(USD, EURO, INR, YEN)

When currency column select any specific currency format then PO cost column currency SYMBOL should change.


Please help us how to achieve this.


Regards / Faisal



2 Replies

@ConnectFaisal a currency column cannot have multiple currencies & currency symbols. But you could have a choice column to select the currency symbol then a number column to store the amount.


Los Gallardos
Microsoft Power Automate Community Super User



Dear Rob,


Thanks for the response, to better understand, i am attaching a screenshot.

It has 2 fields (Columns), Currency and PO cost .

Currency field will have choices to select anyone currency and picked up USD then immediately in the PO cost field the currency symbol of USD  appears.


Similar to above scenario, i would like to develop in share point. Can we achieve this by power automate ?


Regards / Faisal