Skip to main content
Post a question

Notifications

Announcements

🌸 Community Spring Festival 2025 Challenge 🌸
News and Announcements icon
Community site session details

Community site session details

Session Id : K2+xVVgrCVrTFod9gGGp0M
Dynamics 365 Community / Forums / Microsoft Cloud for Sustainability | MSM, SDSF,... / Use of sold products -...
Microsoft Cloud for Sustainability | MSM, SDSF,...
Suggested answer

Use of sold products - purchased Electricity

Like (4) ShareShare
ReportReport
Posted on 21 Mar 2025 10:24:24 by Joke Laukens 70
I'm trying to set op some demo data on use of sold products - purchased Electricity.
 
The OOTB calculation model 'Use of Sold Products - Purchased Electricity: Location-Based' uses following logic referencing the activity.msdyn_lifespaninyears.
 
 
When importing some activity data, I cannot map with a 'lifespaninyears' field.
 
 
The field is not available in the Excel template either.
 
When checking out the documentation referenced in the excel template (https://learn.microsoft.com/en-us/common-data-model/schema/core/industrycommon/sustainability/purchasedenergy), there is mention of the lifespaninyears field.
 
 
So there should be a field.. however, there seems to be no possibility to fill it with de OOTB import possibilities??
 
FYI: I'm not considering manual entry as I want to prove the automation options.
 
What am I missing, or what is MSM missing? 
 
Thanks.
 
Follow up question:
 
I wasn't able to import data into that field, but somehow (bug??/magic??) some data was automatically entered into the lifespan (in years) field.. 
How did that happen?
 
Categories:
Sustainability Manager
  • Joke Laukens Profile Picture
    Joke Laukens 70 on 31 Mar 2025 at 09:52:23
    Use of sold products - purchased Electricity
     
    Thank you for your reply. This helps a lot.
     
    Follow up question:
     
    You mention that it is a calculated field, as I can see in the form, but I'm not quite sure how I should see that..
    There is a lock icon - but so has the correlation ID and the correlation ID was provided by me in the source Excel.
     
    I cannot find that information in the documentation either, see screenshots below.
     
    Can you please point out where I could find this information? Maybe I'm missing a crucial part of documentation.
     
    Thank you.
     
     
  • Suggested answer
    Ivan (Vanya) Kashperuk Profile Picture
    Ivan (Vanya) Kashperuk on 21 Mar 2025 at 23:10:50
    Use of sold products - purchased Electricity
    So Lifespan is as you can see on the form is a calculated field, you cannot manually specify it.
    The way it is calculated is quite simple - total number of days between consumption start and end dates, divided by 365 (so it's total number of years, essentially)
     
    Your screenshot seems to have the From/To dates the same, which should result in 0, and that's what happens in a test environment I tried. 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

🌸 Community Spring Festival 2025 Challenge 🌸

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,333 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,262 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans