cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PinkFloyd202020
Level: Powered On

Adding two numeric values from a Lookup table in SharePoint

I have an Onboarding list in SharePointonboarding.JPG

 

Also have a Software list that has Software cost
software.JPG

  1. The "Onboarding" list has a Software lookup field, which connects to the "Software" list
  2. When someone creates a new Onboarding item, I want it to calculate the total cost of selected software (multi-select)
  3. Since there is no out of the box solution to calculate total software cost in the "Onboarding" list in SharePoint, so apparently we have to use Flow to calculate total cost of Software in the "Onboarding" list
  4. I tried creating a Flow that would be triggered on change/create and have it calculate the Total, but was unsuccessful.

flow.JPG

Any ideas how this can be accomplished?

 

Thanks everyone in advance and happy holidays.🎄

 

2 REPLIES 2
Super User
Super User

Re: Adding two numeric values from a Lookup table in SharePoint

@PinkFloyd202020 

Please see my example below and let me know if you have any questions.

LU5.png

LU6.pngLU5.png

 

LU1.pngLU2.pngLU3.png

LU4.png

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott
PinkFloyd202020
Level: Powered On

Re: Adding two numeric values from a Lookup table in SharePoint

Scott,

 

Thank you so much for the clear and concise response. 😊

I'll give it a shot now.

 

Happy Holidays🎄

Helpful resources

Announcements
firstImage

New Ranks and Rank Icons in April

Read the announcement for more information!

firstImage

Better Together Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (8,949)