I am new in using SharePoint List.I have list created with two columns in same sharepoint list Column A(Text) and B(currrency). I want to set value of column B when Column A value is selected of same ID value of Item.


abc $12

xyz $2

pqr $20

Please give me solution to use this list to use in powerApps for calculations

  • Your question is not clear enough. Are you using this list in another list as a lookup? – harshal gite Sep 11 at 19:05
  • No, I have just created one simple list with 2 columns and 15 items for both columns. I am trying to create calculator application.so If item abc is selected from column A in powerapps then it will consider value $12 from column B. I have no idea how to use lookup. can you please suggest. – Krinal Sep 11 at 20:30

You can use PowerApps itself to set the field value. Check this:https://wonderlaura.com/2018/06/01/powerapps-set-a-field-value/

Or you can use a SharePoint calculated column to show the value. The formula will be like

=IF( A="abc" , 12, IF( A="xyz", 2 , IF( A="pqr", 20 , [other value you need])))

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.