Power Automate Environment Variables Used by TrackMaster

TrackMaster powerautomate

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.
In the Solution, click Environment Variables
Click on the environment variable you want to change and update the Current Value as needed. See additional notes in screenshot below.

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

Microsoft Learn - Use environment variables - https://learn.microsoft.com/en-us/power-automate/guidance/coding-guidelines/use-environment-variables
Microsoft Learn - Use environment variables in Power Automate solution cloud flows - https://learn.microsoft.com/en-us/power-apps/maker/data-platform/environmentvariables-power-automate

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.

| | |

0 reviews

Print Article

Updating...