create Sharepoint column with list of currency choices

%3CLINGO-SUB%20id%3D%22lingo-sub-2115012%22%20slang%3D%22en-US%22%3Ecreate%20Sharepoint%20column%20with%20list%20of%20currency%20choices%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2115012%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20like%20to%20create%202%20columns.%3C%2FP%3E%3CP%3E1.%20Currency%26nbsp%3B%3C%2FP%3E%3CP%3E2.%20PO%20(Purchase%20Order)%20cost%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECurrency%20column%20should%20show%20list%20of%20currency%20format%20ex%3A(USD%2C%20EURO%2C%20INR%2C%20YEN)%3C%2FP%3E%3CP%3EWhen%20currency%20column%20select%20any%20specific%20currency%20format%20then%20PO%20cost%20column%20currency%20SYMBOL%20should%20change.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20help%20us%20how%20to%20achieve%20this.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%20%2F%20Faisal%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2115012%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2117325%22%20slang%3D%22en-US%22%3ERe%3A%20create%20Sharepoint%20column%20with%20list%20of%20currency%20choices%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2117325%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F174092%22%20target%3D%22_blank%22%3E%40RobElliott%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDear%20Rob%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20the%20response%2C%20to%20better%20understand%2C%20i%20am%20attaching%20a%20screenshot.%3C%2FP%3E%3CP%3EIt%20has%202%20fields%20(Columns)%2C%20Currency%20and%20PO%20cost%20.%3C%2FP%3E%3CP%3ECurrency%20field%20will%20have%20choices%20to%20select%20anyone%20currency%20and%20picked%20up%20USD%20then%20immediately%20in%20the%20PO%20cost%20field%20the%20currency%20symbol%20of%20USD%26nbsp%3B%20appears.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESimilar%20to%20above%20scenario%2C%20i%20would%20like%20to%20develop%20in%20share%20point.%20Can%20we%20achieve%20this%20by%20power%20automate%20%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%20%2F%20Faisal%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2115266%22%20slang%3D%22en-US%22%3ERe%3A%20create%20Sharepoint%20column%20with%20list%20of%20currency%20choices%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2115266%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F956177%22%20target%3D%22_blank%22%3E%40ConnectFaisal%3C%2FA%3E%26nbsp%3Ba%20currency%20column%20cannot%20have%20multiple%20currencies%20%26amp%3B%20currency%20symbols.%20But%20you%20could%20have%20a%20choice%20column%20to%20select%20the%20currency%20symbol%20then%20a%20number%20column%20to%20store%20the%20amount.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi,

 

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.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

@RobElliott 

 

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