Power Automate Environment Variables Used by TrackMaster

Summary

TrackMaster uses Power Automate for several automations, from keeping the People list up-to-date with data from MCommunity, to getting info from Office 365, to bulk uploads and more. Many of TrackMaster's automation tasks require specific configurations, so that TrackMaster can work independently of Eisenberg Family Depression Center systems and be deployed to any U-M research center or institute.

Body

Summary

TrackMaster uses Power Automate for several automations, from keeping the People list up-to-date with data from MCommunity, to getting info from Office 365, to bulk uploads and more. Many of TrackMaster's automation tasks require specific configurations, so that TrackMaster can work independently of Eisenberg Family Depression Center systems and be deployed to any U-M research center or institute.

 

Details

Accessing Environment Variables

  • Login to TrackMaster and click Settings -> Power Automate -> Edit TrackMaster Flows, or login to https://make.powerautomate.com and look for the TrackMaster solution under the Solutions menu on the left panel.
    Uploaded Image (Thumbnail)
     
  • In the Solution, click Environment Variables

    Uploaded Image (Thumbnail)
     
  • Click on the environment variable you want to change and update the Current Value as needed. See additional notes in screenshot below.
    Uploaded Image (Thumbnail)
     

 

List of Environment Variables

Display Name Internal Name Description Default Value
Calendar Categories for Outlook Sync
efdc_CalendarCategoriesforOutlookSync
Allowed event categories in CSV format for calendar sync. Center,Communication,Membership,Finance,Operations,Data and Design,Mobile Technologies,Research Innovation,Outreach and Education
Center Leadership Contact Type
efdc_CenterLeadershipContactType
The contact type used for center leadership. When a contact is set to this value, the contact type is never changed automatically. This contact type value should have the highest priority (0) set in the Contact Type Rank setting. Leadership
Center Member Contact Type
efdc_CenterMemberContactType
The value of the "Contact Type" drop-down to use to identify center members. (Default = "Member"). Member
Center Membership Group Email
efdc_CenterMembershipGroupEmail
The MCommunity email address of the Groups List entry that should be used as the source for center membership. mycenter.members@umich.edu
Center Membership Group ID
efdc_CenterMembershipGroupID
Enter the ID of the Groups List entry that should be used as the source for center membership. 1
Center Membership Group Name
efdc_CenterMembershipGroupName
The Title (name) of the Groups List entry that should be used as the source for center membership. Center Members
Center Membership Management Email
efdc_CenterMembershipManagementEmail
The email address that should receive membership-related alerts, such as when new members join or existing member accounts are deactivated.  
Center Name
efdc_CenterName
The name of the Center or Institute, used wherever the Center's name would be displayed. Eisenberg Family Depression Center
Center Staff Contact Type
efdc_CenterStaffContactType
Default contact type for center staff. Staff
Center Staff Department
efdc_CenterStaffDepartment
The department for center staff, for auto detection of staff contact types. MM Eisenberg Family Depression
Center Staff Email Address
efdc_CenterStaffEmailAddress
The default email to use for notifications when all staff members must be notified. mycenter.staff@umich.edu
Contact Maintainer Email
efdc_ContactMaintainerEmail
Email address that receives notifications for contact cleanup tasks.  
Contact Type Rank
efdc_ContactTypeRank
JSON-formatted list of contact types and their rank, with zero being the highest priority. This helps prevent overriding contact types with less desirable values. { "Other": 10, "U-M Staff": 9, "U-M External Partner": 8, "Undergraduate Student": 8, "U-M Partner": 7, "U-M Communication Contact": 7, "Prospective Member": 6, "Community Partner": 5, "Vendor": 4, "Donor": 4, "EFDC Staff": 3, "Peer-to-Peer Partner": 3, "Member": 2, "Alumni": 1, "EFDC Leadership": 0 }
Group Maintainer Email Address
efdc_GroupMaintainerEmailAddress
The email address that is notified of group cleanup tasks.  
Job Ranks
efdc_JobRanks
JSON-formatted array of Job Ranks, for auto-calculating job ranks based on job titles. {"JobRanks": ["Learner", "Research Fellow", "Assistant Professor", "Assistant Research Investigator", "Assistant Research Scientist", "Clinical Assistant Professor", "Collegiate Assistant Professor", "Research Assistant Professor", "Associate Professor", "Associate Research Investigator", "Associate Research Scientist", "Clinical Associate Professor", "Collegiate Associate Professor", "Research Associate Professor", "Clinical Professor", "Collegiate Professor", "Research Investigator", "Research Professor", "Research Scientist", "Emerita", "Emeritus", "Professor"]}
MCommunity API AppID
efdc_MCommunityAPIAppID
The app ID to access the MCommunity API, for group and person info syncing. (Not yet used) GroupNameProvidedByIA,ou=apiusers,o=services
MCommunity API Base URL
efdc_MCommunityAPIBaseURL
The base URL to the MCommunity API, without the / slash at the end. (Not yet used) https://mcommunity.umich.edu/api
MCommunity API Secret
efdc_MCommunityAPISecret
The password for the group or system account used to access the MCommunity API. (Not yet used) PASSWORD_PROVIDED_BY_IA
Prospective Member Contact Type
efdc_ProspectiveMemberContactType
Default contact type for prospective members. Prospective Member
RSS API Base URL
efdc_RSS_API_BaseURL
The base URL for the RSS API, including parameter name in query string. (Only needed until we switch to Mcommunity API) https://automation.depressioncenter.org/api/GetMCommunityGroupMembersRSS.php?groupName=
TrackMaster SharePoint Site Base URL
efdc_TrackMasterSharePointSiteBaseURL
The URL of the TrackMaster site, without a trailing slash and without a page name. https://umhealth.sharepoint.com/sites/Sandbox-DepressionCenter-TrackMaster-DEV
TrackMaster Support Email
efdc_TrackMasterSupportEmail
Email address for technical support for TrackMaster. It is used for notifications related to system or sync errors, and for other technical tasks.  

 

Notes

  • Only administrators can make the changes described in this article.

 

Resources

 

About the Author

Gabriel Mongefranco is a Mobile Data Architect at the University of Michigan's Eisenberg Family Depression Center. Gabriel has over a decade of experience with automation, data analytics, database architecture, dashboard design, software development, and technical writing. He supports U-M researchers with data cleaning, data pipelines, automation and enterprise architecture for wearables and other mobile technologies.

 |   |   | 

 

Details

Details

Article ID: 13816
Created
Tue 5/6/25 10:35 AM
Modified
Tue 5/6/25 12:39 PM
Author(s)
Gabriel Mongefranco
Code Repository
GitHub Code Repository URL

Related Articles

Related Articles (2)

This document presents three different sync approaches between MCommunity and SharePoint Lists that work within the security restrictions of Office 365 and Power Automate, including Microsoft's default Data Loss Prevention (DLP) policy which restricts calling 3rd-party APIs directly.
TrackMaster uses Power Automate for several automated tasks, from keeping the People list up-to-date with data from MCommunity, to getting info from Office 365, to bulk uploads and more. These automations are called "flows" in Power Automate. This article provides a snapshot of all the Power Automate flows that are used by TrackMaster as of the latest version.
All code is available in GitHub at: https://github.com/DepressionCenter/TrackMaster