Showing results for 
Search instead for 
Did you mean: 
New Member

Covert a look up value to a numerical value

I am trying to create a flow for a SharePoint list that will convert a lookup value so it can be used in a calculation.  The register/ SharePoint list has a look up to currency codes, dependent on the code selected it pulls back the relevant rate.  I want to use that rate to calculate a forecast but because its a lookup it doesn't show up in the calculation.  is there a way to create a flow to retrieve the lookup value and create it as a number in a new column so it can be used?  


I then have the same issue in that when i want a sum of the forecast column its not available because they are calculations.  Any help appreciated for someone with little experience in this area.





Helpful resources

MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (1,195)