web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Introducing our New Video Series: Community Spotlight
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Cloud for Sustainability | MSM, SDSF,... / Filtering activity dat...
Microsoft Cloud for Sustainability | MSM, SDSF,...
Answered

Filtering activity data by excel import name

(0) ShareShare
ReportReport
Posted on by DU-21011536-0 20
Hello,
 
When using import from excel feature to import activity data, is it possible to filter them by the excel connection name in their activity data view? I know that it's not a live connection but I wonder if this can be done. Because we can import the same data using the same excel again, there is no duplicate detection rule I guess.
Categories:
Sustainability Manager
I have the same question (0)
  • Verified answer
    ManoVerse Profile Picture
    ManoVerse 495 Super User 2026 Season 1 on at
    Dynamics 365 CE does not store or expose any “Excel connection name,” so it cannot be used to filter imported activity records. you might have to introduce a custom field(Batch Id) if you like to track the import by excel name.  Add it both side in Excel and Dynamics. 
  • DU-21011536-0 Profile Picture
    DU-21011536-0 20 on at
    I see, that's the only way of filtering them down by excel connection then. Thank you for your suggestion of workaround!
  • Suggested answer
    Subhajit Chatterjee Profile Picture
    Subhajit Chatterjee on at
    Within Microsoft Sustainability Manager App, all activity data tables have a column by the name "Data connection" which is a look up to the Data Connection record that imported the record. So, you can filter the view using that field using the specific connection name to view the results imported. For duplicate detection / upserts, we make use of the OCID column.  Refer guidance here: Data traceability in Microsoft Sustainability Manager - Microsoft for Industry | Microsoft Learn

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

Introducing our New Video Series: Community Spotlight

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the December Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Microsoft Cloud for Sustainability | MSM, SDSF, EID

#1
CU14012018-1 Profile Picture

CU14012018-1 3

#2
CL-04020835-0 Profile Picture

CL-04020835-0 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans