Forum Discussion

ConnectFaisal's avatar
ConnectFaisal
Copper Contributor
Feb 05, 2021

create Sharepoint column with list of currency choices

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

 

 

SharePoint Online

2 Replies

  • RobElliott's avatar
    RobElliott
    Silver Contributor
    Feb 05, 2021

    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

    • ConnectFaisal's avatar
      ConnectFaisal
      Copper Contributor
      Feb 08, 2021

      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

       

       

Resources